Re: [GENERAL] DB crashed and duplicated template0 db

2007-07-06 Thread Tom Lane
"Luki Rustianto" <[EMAIL PROTECTED]> writes: > One of my customer's server goes down, I don't know yet how, but when > when they restart the machine I got this: > 1. DB is working like usual > 2. template0 and template1 database is *duplicated* > 3. I can't do pg_dump, because error returned (see b

Re: [GENERAL] DB crashed and duplicated template0 db

2007-07-06 Thread Sibte Abbas
On 7/6/07, Luki Rustianto <[EMAIL PROTECTED]> wrote: Hi, One of my customer's server goes down, I don't know yet how, but when when they restart the machine I got this: 1. DB is working like usual 2. template0 and template1 database is *duplicated* 3. I can't do pg_dump, because error returned (

[GENERAL] DB crashed and duplicated template0 db

2007-07-06 Thread Luki Rustianto
Hi, One of my customer's server goes down, I don't know yet how, but when when they restart the machine I got this: 1. DB is working like usual 2. template0 and template1 database is *duplicated* 3. I can't do pg_dump, because error returned (see below) How can I backup the database (other than

Re: [GENERAL] DB crashed

2006-11-27 Thread Ranjan Kumar Baisak
t; *Sent:* Monday, November 27, 2006 8:26 PM *Subject:* [GENERAL] DB crashed I have been using postgres since a long time. Recently number of users in my portal has been increased drastically and because of that load on Database server has been increased. Suddenly postgres Database

Re: [GENERAL] DB crashed

2006-11-27 Thread Thomas H.
post some more informations, i.e. version, latest entries in logfile before crash, etc. - thomas - Original Message - From: rbaisak To: pgsql-general@postgresql.org Sent: Monday, November 27, 2006 8:26 PM Subject: [GENERAL] DB crashed I have been using postgres since a

[GENERAL] DB crashed

2006-11-27 Thread rbaisak
I have been using postgres since a long time. Recently number of users in my portal has been increased drastically and because of that load on Database server has been increased. Suddenly postgres Database crashed and I need to restart the DB. I am not able to find out root cause of this problem.