PostgreSQL General Operations

1. Add users other than the Postgres super user.
   

   CREATEUSER-DRSP TestUser

2. Create a dedicated database for users

   Createdb-o testuser TestDB

When you back up your data, you should take the Postgres super user to avoid some permission class errors.

SSH Password-free login:

If you want to log on a machine to B:

1. Generate public and private keys on a machine # ssh-keygen-t RSA
   

2. Copy the generated id_rsa.pub public key to Authorized_keys. # CP Id_rsa.pub Authorized_keys

3. Append the Authorized_keys SCP to the ~/.ssh/directory of Machine B, appended to the existing Authorized_keys file. If not, create one yourself.

The Django error message is as follows:

Integrityerror at (some URL): Duplicate key value violates UNIQUE constraint "Krypdos_value_pkey"

Workaround:

Select Setval (' Tablename_id_seq ', (SELECT MAX (ID) from tablename) +1)

This article is from the "Blue Fin Dolphin" blog, please be sure to keep this source http://likunheng.blog.51cto.com/9527645/1589035

PostgreSQL General Operations