basic PostgreSQL question

Discussion in 'OT Technology' started by spoofy, May 16, 2004.

  1. spoofy

    spoofy Chemically Enhanced

    Joined:
    Aug 21, 2001
    Messages:
    5,014
    Likes Received:
    0
    Location:
    houston
    I just compiled and installed it.. but how do i create the admin account? I cant log in without password.. and i dont see a createadm binary or anything :wtc:
     
  2. Joe_Cool

    Joe_Cool Never trust a woman or a government. Moderator

    Joined:
    Jun 30, 2003
    Messages:
    299,206
    Likes Received:
    518
    the admin account is user postgres - it's created automatically.

    Just do 'su - postgres' (without the quotes, of course). Your more important commands to remember are createdb, dropdb, and psql which is the command interface to postgres.
    Try this:

    $ createdb test
    $ psql test
     

Share This Page