Re: [ADMIN] startup subprocess hangs

2005-06-17 Thread Andrew Janian
, June 17, 2005 4:45 PM To: Andrew Janian; pgsql-admin@postgresql.org Subject: RE: [ADMIN] startup subprocess hangs   Without any actual messages, not sure what to say in regards to whether it is still recovering, or finished recovering successfully (from the logs).   There are a few ways to check

Re: [ADMIN] startup subprocess hangs

2005-06-17 Thread Andrew Janian
one table.   How long should the recovery process take?   Thanks,   Andrew   From: Anjan Dave [mailto:[EMAIL PROTECTED] Sent: Friday, June 17, 2005 3:32 PM To: Andrew Janian; pgsql-admin@postgresql.org Subject: RE: [ADMIN] startup subprocess hangs   Probably some kind of a

[ADMIN] startup subprocess hangs

2005-06-17 Thread Andrew Janian
I am running Postgres 7.4.5 and I have recently run into a problem.  My database was running fine for days and then today in the middle of the day it seems that the startup subprocess kicked in and started recovering.  I am not sure from what, and I am not sure how it started, but nothing w

[ADMIN] Database size

2004-09-13 Thread Andrew Janian
also noticed that the disk space was not recovered to the OS. I assumed that was because there was no vacuum full being performed. I am currently performing a vacuum full and noticing that no space is being recovered. Is it normal for a DB to be that much bigger than it's dumps? Thanks, A

Re: [ADMIN] Connecting Postgres using other network

2004-08-13 Thread Andrew Janian
postgresql.conf file. Isn't that the same thing while starting up postmaster with -i. Becasue i am starting up the server using pg_ctl .   Regards   Andrew Janian <[EMAIL PROTECTED]> wrote: Are you using -i option when you start Postgres?  If not, it wil

Re: [ADMIN] Connecting Postgres using other network

2004-08-12 Thread Andrew Janian
Are you using -i option when you start Postgres?  If not, it will not allow remote requests even if you have the ACL set correctly.   Andrew -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Mohammad Tanvir HudaSent: Thursday, August 12, 2004 1

Re: [ADMIN] Corrupted or deleted pg_tables

2004-06-09 Thread Andrew Janian
Can you post your errors? Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Curtis Klumas Sent: Tuesday, June 08, 2004 8:09 PM To: [EMAIL PROTECTED] Cc: Jonathan Yee Subject: Re: [ADMIN] Corrupted or deleted pg_tables We have a database that we manag