Re: [BUGS] Error in starting PostgreSQL Server 7.4 after crash

2008-09-21 Thread Tom Lane
sagar koirala <[EMAIL PROTECTED]> writes: > So, I used pg_resetxlog PGDATA with PGDATA pointing to my current > /pgsql/data. It said transaction log reset. At this point, the postgresql is > not running, so I cannot dump my old data. Starting the postgresql doesn't > work. > So I tried: export

[BUGS] Error in starting PostgreSQL Server 7.4 after crash

2008-09-21 Thread sagar koirala
It all started like this: My postgresql 7.4 running in CentOS crashed with one database missing in all my backups. But, I have a copy of the entire pgsql/data directory (which is unforunately a version grabbed while the server was still running...) I need to recover that database and I have tri