Re: [GENERAL] Problem with starting PostgreSQL server 7.4.19

2008-03-11 Thread Tom Lane
"Kakoli Sen" <[EMAIL PROTECTED]> writes: > Actually, I tried stopping server by 'kill `cat > /opt/pgsql/data/postmaster.pid`. This did not work. So I used kill -9 on Red > Hat 4. Define "did not work" ... what happened exactly? I do not know of any prepackaged Postgres distribution for Red Hat th

Re: [GENERAL] Problem with starting PostgreSQL server 7.4.19

2008-03-11 Thread Craig Ringer
Kakoli Sen wrote: Hi, Actually, I tried stopping server by 'kill `cat /opt/pgsql/data/postmaster.pid`. This did not work. So I used kill -9 on Red Hat 4. This is a test database where we are in the process of setting up. So it does not have live data. Still I do agree, it was not a good idea. N

Re: [GENERAL] Problem with starting PostgreSQL server 7.4.19

2008-03-11 Thread Kakoli Sen
March 12, 2008 11:09 AM > To: Kakoli Sen > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Problem with starting PostgreSQL server 7.4.19 > > > Kakoli Sen wrote: > > Hello all, > > It was running fine initially and the database was > lying idle f

Re: [GENERAL] Problem with starting PostgreSQL server 7.4.19

2008-03-11 Thread Tom Lane
Craig Ringer <[EMAIL PROTECTED]> writes: > Kakoli Sen wrote: >> It was running fine initially and the database was lying idle for a >> few days. Today I looged into the machine and restarted the server by >> killing the process by 'kill -9 pid'. And then restarted it by >> 'postmaster -i -D /opt/pg

Re: [GENERAL] Problem with starting PostgreSQL server 7.4.19

2008-03-11 Thread Craig Ringer
Kakoli Sen wrote: Hello all, It was running fine initially and the database was lying idle for a few days. Today I looged into the machine and restarted the server by killing the process by 'kill -9 pid'. And then restarted it by 'postmaster -i -D /opt/pgsql/data/'. Why did you use `ki

[GENERAL] Problem with starting PostgreSQL server 7.4.19

2008-03-11 Thread Kakoli Sen
Hello all, It was running fine initially and the database was lying idle for a few days. Today I looged into the machine and restarted the server by killing the process by 'kill -9 pid'. And then restarted it by 'postmaster -i -D /opt/pgsql/data/'. Then it gives the following error on stdou