At 2003-09-12T23:28:41Z, "Andrew L. Gould" <[EMAIL PROTECTED]> writes:
> You might be interested in 'ident same' or some other combination of
> options.
That was exactly what I needed - thanks!
My pg_hba.conf now looks like:
local all pgsql
story short:
su -l postgres -c "/usr/local/pgsql/bin/postmaster -o -i -D /usr/local/pgsql/data -s &"
in the /etc/rc.local and it will start postgres w/o asking for
password. now, be carefull and read ( man postmaster) about switches.
if you need more help, please let us know. if it works let us kno
On Friday 12 September 2003 05:13 pm, Kirk Strauser wrote:
> At 2003-09-12T21:39:14Z, "Andrew L. Gould" <[EMAIL PROTECTED]> writes:
> > You're looking for something difficult when the easier answer is correct.
> >
> > As root, set pgsql's password by executing:
> >
> > passwd pgsql
>
> What would t
At 2003-09-12T22:36:43Z, alexander v p <[EMAIL PROTECTED]> writes:
> look in /usr/local/pgsql/data/pg_hba.conf
> by default is:
>
> local all all trust
> hostall all 127.0.0.1 255.255.255.255 trust
>
> what you ha
look in /usr/local/pgsql/data/pg_hba.conf
by default is:
local all all trust
hostall all 127.0.0.1 255.255.255.255 trust
what you have to do is to change trust into password or md5
hope that helps
alex
p.s. resta
At 2003-09-12T21:39:14Z, "Andrew L. Gould" <[EMAIL PROTECTED]> writes:
> You're looking for something difficult when the easier answer is correct.
>
> As root, set pgsql's password by executing:
>
> passwd pgsql
What would that buy me? After doing that, I can still access any database
on the sys
On Friday 12 September 2003 03:59 pm, Kirk Strauser wrote:
> I'm running PostgreSQL 7.3 on a FreeBSD 5.1 server. The databases are
> working well and it's humming along nicely, but I really want to secure it.
>
> In particular, my pg_hba.conf looks like:
>
>local all pgsql
I'm running PostgreSQL 7.3 on a FreeBSD 5.1 server. The databases are
working well and it's humming along nicely, but I really want to secure it.
In particular, my pg_hba.conf looks like:
local all pgsql trust
hostall all
