Starting postgres with a password

From: Doug Silver <dsilver(at)urchin(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Starting postgres with a password
Date: 2003-04-24 22:47:54
Message-ID: 200304241547.32864.dsilver@urchin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I've searched around but didn't see this answered (at least in the first 100
answers!). If the postgres user has a password (in Postgres, not the system)
*and* the hba_conf file does not trust the 127.0.0.1 host but requires a
password, how can you start up Postgresql? Can you pass this during the init
script, e.g. "password=test"?

I don't trust some of the users on a server and want to make sure they can't
just login to postgres as the admin (psql -U pgsql).

Thanks!

-doug

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2003-04-24 23:29:05 Re: [NOVICE] ODBC & Access [Try 2]
Previous Message Jeff Eckermann 2003-04-24 19:07:54 Re: ODBC & Access [Try 2]