Re: [GENERAL] Problems logging in

2006-04-24 Thread Richard Broersma Jr
> > redirect_stderr = true > > log_directory = 'pg_log' > > log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' > > log_rotation_size = 10240 > > log_min_messages = info > > log_line_prefix = '%t%%%d ' > > > > These are the setting in my conf file. > > [EMAIL PROTECTED] root]# tail /var/log/pgsqll

Re: [GENERAL] Problems logging in

2006-04-24 Thread John Oliver
On Sat, Apr 22, 2006 at 07:51:19PM -0700, Richard Broersma Jr wrote: > > Is whitespace important? Tabs? The number of spaces? > > Ohhhkyyy... so, what settings would be needed to get usable logs? > > Set everything that has "log" in the name to "true"? > > --postgresql.conf > > redirect_std

Re: [GENERAL] Problems logging in

2006-04-22 Thread Richard Broersma Jr
> Is whitespace important? Tabs? The number of spaces? > Ohhhkyyy... so, what settings would be needed to get usable logs? > Set everything that has "log" in the name to "true"? --postgresql.conf redirect_stderr = true log_directory = 'pg_log' log_filename = 'postgresql-%Y-%m-%d_%H%M%S.l

Re: [GENERAL] Problems logging in

2006-04-22 Thread John Oliver
On Sat, Apr 22, 2006 at 06:18:18PM -0700, Richard Broersma Jr wrote: > > you can reference the following page for ideas: > http://www.postgresql.org/docs/7.4/interactive/client-authentication.html#EXAMPLE-PG-HBA.CONF > > but to get started I would recommend: > " > TYPE DATABASEUSERI

Re: [GENERAL] Problems logging in

2006-04-22 Thread Richard Broersma Jr
> I installed the RPMs and the service starts and runs. I added a user > and gave it a password, and gave the psql user "postgres" a different > password. But I can log on with neither. No, I didn't forget the > passwords :-) when you first start postgres you need to specify the database you ar