I noticed today morning that my pg.log doesn't exist in my server.
Why it occurs ?
My /var/lib/pgsql/data is like that:
[EMAIL PROTECTED] data]# ls -la
total 92
drwx-- 10 postgres postgres 4096 Jan 31 08:35 .
drwx-- 4 postgres postgres 4096 Jul 26 2006 ..
drwx-- 7 postgres
Check for log_directory setting in your postgresql.conf file...
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/31/07, Ezequias Rodrigues da Rocha [EMAIL PROTECTED] wrote:
I noticed today morning that my pg.log doesn't exist in my server.
Why it occurs ?
My
It was commented. Thank you Shoaib Mir
I must restart my server ?
Ezequias
2007/1/31, Shoaib Mir [EMAIL PROTECTED]:
Check for log_directory setting in your postgresql.conf file...
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/31/07, Ezequias Rodrigues da Rocha [EMAIL
I restart the server but the pg_log folder doesn't appears.
My log session is like this on postgresql.conf:
# These are only used if redirect_stderr is on:
log_directory = 'pg_log'# Directory where log files are written
# Can be absolute or relative to PGDATA
Change it in the postgresql.conf file only if you want to make it permanent.
Otherwise just set the variable for your current session without a
server restart.
--Imad
www.EnterpriseDB.com
On 1/31/07, Ezequias Rodrigues da Rocha [EMAIL PROTECTED] wrote:
It was commented. Thank you Shoaib Mir
I
You need to create the folder manually, give the postgres user permission
for write on it and then restart the database server. This way you should be
able to set the log files in pg_log folder...
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/31/07, Ezequias Rodrigues da
I did it, my pg_log folder was like this:
drwxr-xr-x 2 root root 4096 Jan 31 09:36 pg_log
Afer I changed to:
drwxr-xr-x 2 postgres postgres 4096 Jan 31 09:36 pg_log
After this I restart the service (service postgresql restart) ,return to
execute an inaceptble sql statement with
I really don't know how to set it. I created my pg_log on:
/var/lib/pgsql/data.
the settings on pgsql.conf is like this:
#---
# ERROR REPORTING AND LOGGING
You need to set it like this:
log_destination = 'syslog,stderr'
redirect_stderr = on
and then restart the server. It should show up the log from then onwards
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/31/07, Ezequias Rodrigues da Rocha [EMAIL PROTECTED] wrote:
I
On Wed, 2007-01-31 at 10:12 -0200, Ezequias Rodrigues da Rocha wrote:
I restart the server but the pg_log folder doesn't appears.
My log session is like this on postgresql.conf:
# These are only used if redirect_stderr is on:
Did you look at
Great. Now the log is working. Thank you, Thank you, Thank you,
But my statement does not report an error anymore. I really confused now.
Any suggestion ?
Ezequias
2007/1/31, Shoaib Mir [EMAIL PROTECTED]:
You need to set it like this:
log_destination = 'syslog,stderr'
redirect_stderr = on
No problemo :)
What was the query and the statement for error? that way we might be able to
help...
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/31/07, Ezequias Rodrigues da Rocha [EMAIL PROTECTED] wrote:
Great. Now the log is working. Thank you, Thank you, Thank you,
Thank you Shoiab,
Now everything is working like I desire. Thank you all very much.
I am notthing without Postgresql community.
Ezequias
2007/1/31, Shoaib Mir [EMAIL PROTECTED]:
No problemo :)
What was the query and the statement for error? that way we might be able
to help...
On Tue, Jan 30, 2007 at 03:01:05PM -0200, Ezequias Rodrigues da Rocha wrote:
I know there are many logs in postgresql but I don't have many
familiarity with all them.
It's not totally plain what you want to have happen -- whether you
want all queries, whether you merely want ERRORs to show up
So you are tell me that it is impossible to retrieve it ok ?
Just by changing this values (what I did now) it is possible to get
the error messages and their statements OK?.
My best Regards
Ezequias
2007/1/30, Andrew Sullivan [EMAIL PROTECTED]:
On Tue, Jan 30, 2007 at 03:01:05PM -0200,
Hi list,
I lost some data becouse my application does not throws an exception
when an update statement report an error.
It is possible to find out if the PostgreSQL could have this error
(and more important the complete statement that make this errors
occurs) ?
I know there are many logs in
On Tue, Jan 30, 2007 at 04:41:13PM -0200, Ezequias Rodrigues da Rocha wrote:
So you are tell me that it is impossible to retrieve it ok ?
No.
Just by changing this values (what I did now) it is possible to get
the error messages and their statements OK?.
Yes, but you need to signal the
17 matches
Mail list logo
