Re: [ADMIN] logfile per DataBase

2012-02-24 Thread Igor Neyman
> -Original Message- > From: Lutz Steinborn [mailto:l.steinb...@4c-ag.de] > Sent: Friday, February 24, 2012 8:55 AM > To: pgsql-admin@postgresql.org > Subject: logfile per DataBase > > Hello, > > is it possible to configure postgresql to produce one logfile per > database in a cluster?

[ADMIN] logfile per DataBase

2012-02-24 Thread Lutz Steinborn
Hello, is it possible to configure postgresql to produce one logfile per database in a cluster? I can't find any hint about this in the doc. Something like: log_filename = 'postgresql-[DBNAME]-%Y-%m-%d_%H%M%S.log' It would be very use full for a development server. have a happy weekend Lutz

Re: [ADMIN] Logfile

2010-10-29 Thread Kevin Grittner
Eduardo Sá dos Reis wrote: > I have several databases installed on my Postgre 8.4.2. > I set the postgresql.conf so that all connections are logged in > the log file. > Now I need to create another database but do not want the > connections in this new database to be recorded in the Log Files. >

[ADMIN] Logfile

2010-10-29 Thread Eduardo Sá dos Reis
I have several databases installed on my Postgre 8.4.2. I set the postgresql.conf so that all connections are logged in the log file. Now I need to create another database but do not want the connections in this new database to be recorded in the Log Files. Can anyone help me? Eduardo

Re: [ADMIN] Logfile permission

2006-10-19 Thread Peter Eisentraut
Cassiano, Marco wrote: > Is there a way to modify > the UMASK used by postmaster to create the logfiles ? No. You should use syslog if you have extraordinary log file management requirements. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broad

[ADMIN] Logfile permission

2006-10-19 Thread Cassiano, Marco
 Hi All,   By default Postgres creates its logfiles with rw user permission only (600). I would like to have rw permission also on the group to share via samba the log with the development team. Is there a way to modify the UMASK used by postmaster to create the logfiles ? Th

Re: [ADMIN] logfile

2006-06-06 Thread Jim C. Nasby
On Tue, Jun 06, 2006 at 02:37:11PM +0200, H.J. Sanders wrote: > I assume I do not understand the manual right (or my kind of english). > > In PGSQL 7.4 I only want error situations in the logfile, and if an error > occurs as much as possible information like e.g. the sql statement. > > I entered

[ADMIN] logfile

2006-06-06 Thread H.J. Sanders
I assume I do not understand the manual right (or my kind of english).   In PGSQL 7.4 I only want error situations in the logfile, and if an error occurs as much as possible information like e.g. the sql statement.   I entered in postgresql.conf:   client_min_messages = error log_min_messag

Re: [ADMIN] logfile problem?

2003-08-30 Thread Bruce Momjian
tw_vincent wrote: > Dear All: > >I start postgresql with "/app/pgsql/bin/pg_ctl start -l >/app/pgsql/logfile -D /app/pgsql/data", when I use "cat > /dev/null > /app/pgsql/logile" to clear logfile, I can't clear > logfile. How can I clear the logfile, thank you! The problem is that the log

[ADMIN] logfile problem?

2003-08-28 Thread tw_vincent
Dear All:           I start postgresql with "/app/pgsql/bin/pg_ctl start -l /app/pgsql/logfile -D /app/pgsql/data", when I use "cat /dev/null > /app/pgsql/logile" to clear logfile, I can't clear logfile. How can I clear the logfile, thank you!   vincent