[ADMIN] Urgent help required
Hi team, i am nagaraj, i am newbi in this database world. i required your help. 2 dyas back i formatted one of my client system. which is having postgresql 8.2 database that was having data. but i am not taken backup of the data. 1) how to take the data from the formatted harddisk. ? 2) how many folders or files will be their at base folder. When we install postgresql 8.2? 3) how to identify which folder contain which file. ? Please help it is very urgent. thanks and regards -- Nagaraj V Shindagi
Re: [ADMIN] Urgent help required
On Thu, Apr 19, 2012 at 5:47 PM, Nagaraj Shindagi nagaraj.shind...@gmail.com wrote: Hi team, i am nagaraj, i am newbi in this database world. i required your help. 2 dyas back i formatted one of my client system. which is having postgresql 8.2 database that was having data. but i am not taken backup of the data. 1) how to take the data from the formatted harddisk. ? If you have formatted your system, then your data is gone. You may have luck with some data-recovery service. 2) how many folders or files will be their at base folder. When we install postgresql 8.2? You need the PostgreSQL 'data' directory and *all *the files underneath. 3) how to identify which folder contain which file. ? That depends on where you you downloaded postgres from and which platform you are on. --Scott Please help it is very urgent. thanks and regards -- Nagaraj V Shindagi
Re: [ADMIN] Urgent help required
Usually the standard location for data is /var/lib/pgsql/data for postgresql 8. So try to restore this directory first and underneath. Only with that you can hopefully restore the whole system assuming that if tablespaces were creates are under the standard location. I would ask others to make sure there are no backups, sometimes there is guy who knows... Good luck A.A. On 04/19/2012 10:47 AM, Nagaraj Shindagi wrote: Hi team, i am nagaraj, i am newbi in this database world. i required your help. 2 dyas back i formatted one of my client system. which is having postgresql 8.2 database that was having data. but i am not taken backup of the data. 1) how to take the data from the formatted harddisk. ? 2) how many folders or files will be their at base folder. When we install postgresql 8.2? 3) how to identify which folder contain which file. ? Please help it is very urgent. thanks and regards -- Nagaraj V Shindagi -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Urgent Help required
Hi, We are running with postgres sql 7.3.2. We were trying to create an index on a big table. The create index command ran for nearly 5 hours at which point we decided to interrupt it. Since this was interrupted, any operations attempted on the table on which the index was being created gives following error in pgsql log: LOG: all server processes terminated; reinitializing shared memory and semaphor es LOG: database system was interrupted at 2009-10-16 10:44:54 BST LOG: checkpoint record is at 150/71A0C0CC LOG: redo record is at 150/71A0C0CC; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 1757299460; next oid: 43508941 LOG: database system was not properly shut down; automatic recovery in progress LOG: ReadRecord: record with zero length at 150/71A0C10C LOG: redo is not required LOG: database system is ready Any idea what this means and what we need to do to resolve access to this table again? We can see the next oid number increases over time. Access to all other tables in the database is fine. Any help would be greatly appreciated. Many Thanks Neha.
Re: [ADMIN] Urgent Help required
Drop the index first and create Palani Sent from my iPhone On Oct 17, 2009, at 7:23 PM, Neha Patel npa...@nevi-soft.commailto:npa...@nevi-soft.com wrote: Hi, We are running with postgres sql 7.3.2. We were trying to create an index on a big table. The create index command ran for nearly 5 hours at which point we decided to interrupt it. Since this was interrupted, any operations attempted on the table on which the index was being created gives following error in pgsql log: LOG: all server processes terminated; reinitializing shared memory and semaphor es LOG: database system was interrupted at 2009-10-16 10:44:54 BST LOG: checkpoint record is at 150/71A0C0CC LOG: redo record is at 150/71A0C0CC; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 1757299460; next oid: 43508941 LOG: database system was not properly shut down; automatic recovery in progress LOG: ReadRecord: record with zero length at 150/71A0C10C LOG: redo is not required LOG: database system is ready Any idea what this means and what we need to do to resolve access to this table again? We can see the next oid number increases over time. Access to all other tables in the database is fine. Any help would be greatly appreciated. Many Thanks Neha.
Re: [ADMIN] Urgent Help required
2009/10/16 Neha Patel npa...@nevi-soft.com:
Hi,
We are running with postgres sql 7.3.2. We were trying to create an index on
a big table. The create index command ran for nearly 5 hours at which point
we decided to interrupt it. Since this was interrupted, any operations
attempted on the table on which the index was being created gives following
error in pgsql log:
LOG: all server processes terminated; reinitializing shared memory and
semaphor
es
LOG: database system was interrupted at 2009-10-16 10:44:54
BST
LOG: checkpoint record is at
150/71A0C0CC
LOG: redo record is at 150/71A0C0CC; undo record is at 0/0; shutdown
TRUE
LOG: next transaction id: 1757299460; next oid:
43508941
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: ReadRecord: record with zero length at
150/71A0C10C
LOG: redo is not
required
LOG: database system is ready
Any idea what this means and what we need to do to resolve access to this
table again? We can see the next oid number increases over time. Access to
all other tables in the database is fine. Any help would be greatly
appreciated.
Have you tried using pg_dump and dumping just that table?
What does \d {table name} tell you?
What does ps -ef|grep post
show?
Although the log looks like it is restarting itself, have you tried
shutting down the database (and restarting it)?
Many Thanks
Neha.
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
