[ADMIN] Postgres database is not logging any messages after the reboot

Hi The server that hosts our production postgres databases had to be rebooted last night as the file systems got remounted as read only. After the reboot we re-started the databases but now nothing is getting logged into the pglogs. Can you please assist us in figuring out the problem and help re

Re: [ADMIN] Postgres database is not logging any messages after the reboot

ks Paramjeet Kaur -Original Message- From: Bhella Paramjeet-PFCW67 Sent: Wednesday, October 10, 2007 10:43 AM To: 'pgsql-admin@postgresql.org' Cc: Subbiah Stalin-XCGF84 Subject: Postgres database is not logging any messages after the reboot Hi The server that hosts our produc

Re: [ADMIN] Postgres database is not logging any messages after the reboot

Paramjeet-PFCW67 Cc: pgsql-admin@postgresql.org; Subbiah Stalin-XCGF84 Subject: Re: [ADMIN] Postgres database is not logging any messages after the reboot "Bhella Paramjeet-PFCW67" <[EMAIL PROTECTED]> writes: > Here are the messages from the pg_log before and after server reboot.

[ADMIN] Postgres database is not logging any messages after the reboot

Hi The server that hosts our production postgres databases had to be rebooted last night as the file systems got remounted as read only. After the reboot we re-started the databases but now nothing is getting logged into the pglogs. Can you please assist us in figuring out the problem and help re

[ADMIN] Pg_statio_user_tables view does not get populated

I have installed postgres 8.2.4 in my development environment. I have the stats_command_string, stats_start_collector, stats_block_level, stats_row_level options turned on in postgresql.conf file but still the pg_statio_user_tables view does not get populated. Is there any other option I need to en

Re: [ADMIN] Pg_statio_user_tables view does not get populated

Yes I did restart the database after making these changes but still there is no data in pg_statio_user_tables view. -Original Message- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 15, 2008 7:20 AM To: Bhella Paramjeet-PFCW67 Cc: pgsql-admin@postgresql.org Subject

Re: [ADMIN] Pg_statio_user_tables view does not get populated

-PFCW67 Cc: Scott Marlowe; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Pg_statio_user_tables view does not get populated "Bhella Paramjeet-PFCW67" <[EMAIL PROTECTED]> writes: > Yes I did restart the database after making these changes but still > there is no data in pg_s

[ADMIN] Postgres 8.2 install on solaris 10

Hi Group, We are considering having postgres 8.2 on solaris 10 machine for our production environment. While reading through sun docs, it looks like the solaris 10 update 6 onwards comes with the postgres 8.2 installed under /usr/postgres/8.2 . My question is can we have postgres binaries under a

Re: [ADMIN] Postgres 8.2 install on solaris 10

: Bhella Paramjeet-PFCW67 Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgres 8.2 install on solaris 10 On 05.02-14:05, Bhella Paramjeet-PFCW67 wrote: [ ... ] > We are considering having postgres 8.2 on solaris 10 machine for our > production environment. While reading through sun do

[ADMIN] Postgres database and firewall

Hi We will be setting up a production postgres database to which an application will connect through a firewall. Can any one please tell me if there is any configuration that needs to be done on the postgres database side for firewall. Is there any documentation that I can refer to. Any help wil

Re: [ADMIN] Postgres database and firewall

be enough to keep the idle connections alive or is there anything else I need to be aware of. Your help will be highly appreciated. Thanks Paramjeet Kaur -Original Message- From: Shane Ambler [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2008 12:48 AM To: Bhella Paramjeet-PFCW67 Cc

[ADMIN] Vacuumdb error

Hi, We have our production postgres 8.0.10 database running on linux x86_64 machine. Recently we have started getting an error from one of our database while running vacuumdb. We are not getting this error during backups just only during vacuuming of a database. Can anyone please help us figure ou

Re: [ADMIN] Vacuumdb error - corruption

es and people have reported this problem but there were no responses as to how they resolved this issue. Do you still think it is due to block corruption on disk? Please advice. Thanks Paramjeet Kaur -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, April 17,

Re: [ADMIN] Vacuumdb error - corruption

40:31 CDTFATAL: invalid memory alloc request size 936749196708242529" and also "invalid page header" errors. Thanks Paramjeet Kaur -Original Message- From: Eric Comeau [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 2:39 PM To: Bhella Paramjeet-PFCW67; Tom

[ADMIN] Warm-standby in 8.2

Hi, We have created a postgres database with a warm-standby in postgres 8.2 following the document on the archive by Charles Duffy. The standby database is in continuous recovery mode and archived logs are synced to the standby from primary, every 10 minutes. The primary and the standby database a

[ADMIN] Postgres on polyserve cluster file system

Hi, We are going to be moving our production postgres databases to new SAN with polyserve clustering filesystem. Can anyone running postgres on polyserver tell us what file system mount options should we use to get best performance? Our existing san with ext3 filesystem mounted with " rw,noatime

[ADMIN] Online backups are failing

Hi, We are running into a problem where our online backups are failing randomly. We are using postgres 8.2.7 and we are seeing this problem in both Solaris and Linux platforms. Our online backup script copies the PGDATA dir with the command "cp -r -P". First we saw this problem on our postgres 8

Re: [ADMIN] Online backups are failing

backup mode $PGSQL_HOME/bin/psql -d template1 -U postgres -e -f $BACKUP_SQL/end_backup.sql > > $BACKUP_LOGS_DIR/$backup_log_filename Thanks Paramjeet kaur -----Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Bhella Paramjeet-PF

[ADMIN] Partioning in postgres

Hi, We are planning on implementing partioning in our postgres production database.=20 In my test system I created a table called eventlog which has 7 partitions. I have created rules for data to be inserted in respective partitions. I tested a scenario where in one terminal window I insert rows i

Re: [ADMIN] Partioning in postgres

From: Richard Broersma [mailto:richard.broer...@gmail.com] Sent: Monday, June 29, 2009 12:36 PM To: Bhella Paramjeet-PFCW67 Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Partioning in postgres On Mon, Jun 29, 2009 at 12:19 PM, Bhella Paramjeet-PFCW67 wrote: > I tested a scenario wher

[ADMIN] tuning auto vacuum for highly active tables

Hi All, We have a postgres database in which couple of tables get bloated due to heavy inserts and deletes. Auto vacuum is running. My question is how can I make auto vacuum more aggressive? I am thinking of enabling autovacuum_vacuum_cost_delay and autovacuum_vacuum_cost_limit parameters. Can

Re: [ADMIN] tuning auto vacuum for highly active tables

-Original Message- From: Scott Marlowe [mailto:scott.marl...@gmail.com] Sent: Tuesday, March 23, 2010 2:42 PM To: Bhella Paramjeet-PFCW67 Cc: pgsql-admin@postgresql.org; pgsql-performa...@postgresql.org Subject: Re: [ADMIN] tuning auto vacuum for highly active tables On Tue, Mar 23, 2010