Re: postgreSQL

["Oliver Elphick" <olly@lfix.co.uk>]

bob parker wrote:
  >Using potato r3 and postmaster is running.
  >
  >Attempt to 'psql' get error message:
  >FATAL1: SetUserID: user 'bob' is not in pg_shadow
  >
  >How may i sign on to postgres - command line please

Have you created a PostgreSQL user called "bob"?

When PostgreSQL is installed, there is only one user, "postgres" and
(in potato) the access policy (in /etc/postgresql/pg_hba.conf) is 
open.

So either connect to psql calling yourself postgres:

  $ psql -u
  Username: postgres
  Password:                  (leave it blank)
  template1:-> CREATE USER bob;


or else do it from the command line:

  $ su
  Password: root password
  # su - postgres
  $ createuser bob


Do check the respective manual pages:

man create_user

and

man createuser

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "But the end of all things is at hand; be ye therefore 
      sober, and watch unto prayer. And above all things 
      have fervent love among yourselves; for love shall  
      cover the multitude of sins."      I Peter 4:7,8