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
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
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.
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
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
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
-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
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
: 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
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
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
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
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,
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
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
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
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
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
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
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
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
-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
22 matches
Mail list logo