Re: [GENERAL] Database Recovery from Corrupted Dump or Raw database table file.

On 07/11/2016 13:44, Vick Khera wrote: On Mon, Nov 7, 2016 at 8:23 AM, Howard News wrote: pg_restore: executing SEQUENCE SET example_seq pg_restore: processing data for table example_table pg_restore: [compress_io] ** crash ** What crashes? the pg_restore process

Re: [GENERAL] Database Recovery from Corrupted Dump or Raw database table file.

On Mon, Nov 7, 2016 at 8:23 AM, Howard News wrote: > pg_restore: executing SEQUENCE SET example_seq > pg_restore: processing data for table example_table > pg_restore: [compress_io] > > ** crash ** What crashes? the pg_restore process or the backend server? -- Sent

Re: [GENERAL] Database Recovery from Corrupted Dump or Raw database table file.

On 07/11/2016 13:12, Albe Laurenz wrote: Howard News wrote: I have a raid catastrophe which has effectively blitzed a cluster data directory. I have several pg_dump backups but these will not restore cleanly. I assume the disk has been failing for some time and the backups are of the

Re: [GENERAL] Database Recovery from Corrupted Dump or Raw database table file.

Howard News wrote: > I have a raid catastrophe which has effectively blitzed a cluster data > directory. I have several pg_dump backups but these will not restore > cleanly. I assume the disk has been failing for some time and the > backups are of the corrupted database. > > Using a selective

[GENERAL] Database Recovery from Corrupted Dump or Raw database table file.

Hi all, I have a raid catastrophe which has effectively blitzed a cluster data directory. I have several pg_dump backups but these will not restore cleanly. I assume the disk has been failing for some time and the backups are of the corrupted database. Using a selective pg_restore on the

Re: [GENERAL] Database recovery.

On 2011-03-24, Waqar Azeem waqarazeem.priv...@gmail.com wrote: --0015174766a0ffbf86049f35206e Content-Type: text/plain; charset=ISO-8859-1 My XP is crashed and now I have to take a full backup of my postgresql 8.4 I am used to get backup of ldf/mdf files in case of SQLServer Please let me

[GENERAL] Database recovery.

My XP is crashed and now I have to take a full backup of my postgresql 8.4 I am used to get backup of ldf/mdf files in case of SQLServer Please let me know the right way of doing this for postgresql 8.4. -- Thanks Best Regards, Waqar Azeem

Re: [GENERAL] Database recovery.

On 03/24/11 12:07 AM, Waqar Azeem wrote: My XP is crashed and now I have to take a full backup of my postgresql 8.4 I am used to get backup of ldf/mdf files in case of SQLServer Please let me know the right way of doing this for postgresql 8.4. you need everything in the $PGDATA directory.

Re: [GENERAL] Database recovery.

I copy the whole folder 'Data' to another PC where fresh postgresql 8.4 is installed (same as default config. that previous version have had) when i started the server got following ... The postgresql-8.4 - PostgreSQL Server 8.4 service could not be started. The service did not report an

Re: [GENERAL] Database recovery.

On Thu, Mar 24, 2011 at 04:31:19PM +0500, Waqar Azeem wrote: The postgresql-8.4 - PostgreSQL Server 8.4 service could not be started. The service did not report an error. More help is available by typing NET HELPMSG 3534. The start command returned an error (2) Press return to

Re: [GENERAL] Database recovery.

On 24/03/2011 11:31, Waqar Azeem wrote: I copy the whole folder'Data' to another PC where freshpostgresql8.4 is installed (same as default config. that previous version have had) when i started the server got following ... The postgresql-8.4 - PostgreSQL Server 8.4 service could not be

Re: [GENERAL] Database recovery.

On Thu, Mar 24, 2011 at 12:37:25PM +0100, Karsten Hilbert wrote: More help is available by typing NET HELPMSG 3534. ... any clue? And the second Google result has this: http://archives.postgresql.org/pgsql-bugs/2009-05/msg5.php Karsten -- GPG key ID E4071346 @

Re: [GENERAL] Database recovery.

my windows event viewer says: 2011-03-24 11:24:22 GMT FATAL: could not create lock file postmaster.pid: Permission denied is this helpfull? On Thu, Mar 24, 2011 at 4:31 PM, Waqar Azeem waqarazeem.priv...@gmail.comwrote: I copy the whole folder 'Data' to another PC where fresh postgresql 8.4

Re: [GENERAL] Database recovery.

Thanks Karsten n' Raymond, Finally, I change the logging in account to Local System account as suggested in your URL. And then change it back to .\postgres This magically worked for me. I think ctrl+alt+del was a compulsory part of XP trouble shootings :) -- Waqar On Thu, Mar 24, 2011 at 5:10

Re: [GENERAL] Database recovery.

Waqar, my windows event viewer says: 2011-03-24 11:24:22 GMT FATAL:  could not create lock file postmaster.pid: Permission denied is this helpfull? yes. that says that the windows-user your PostgreSQL Service is running as has no write priv on the data directory. Check your file systems

[GENERAL] Database recovery after dropdb

Hi guy, I just droped a development database by mistake using the dropdb command witch contains valuable data. Can I still restaure it ? I have no backup. Best regards, Romain -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Database recovery after dropdb

On Wed, 2010-07-14 at 18:18 +0200, easyCity Team wrote: Hi guy, I just droped a development database by mistake using the dropdb command witch contains valuable data. Can I still restaure it ? I have no backup. No. Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor

Re: [GENERAL] Database recovery

Christian Schröder wrote: we have a PostgreSQL 8.2 database on an xfs filesystem. By mistake the first blocks of this filesystem were overwritten. An xfs_repair reconstructed the superblock and also found many orphaned files and directories. Actually, all we have on the filesystem now is in

[GENERAL] Database recovery

Hi list, we have a PostgreSQL 8.2 database on an xfs filesystem. By mistake the first blocks of this filesystem were overwritten. An xfs_repair reconstructed the superblock and also found many orphaned files and directories. Actually, all we have on the filesystem now is in lost+found. ;-)

[GENERAL] Database recovery

Hello! My filesystem (UFS-FreeBSD) was crashed and I have lost files from PGSQL DATA DIR FOLDER after fsck-utility. I have lost files from directory pg_xlog I reset my pg_xlog. And now have such error by starting pgsql-server: LOG: database system was interrupted at 2008-03-18 22:29:48 EET

Re: [GENERAL] Database Recovery Procedures

Network Administrator [EMAIL PROTECTED] writes: ..if I using the psql client, and issue a select * from corrupt table name limit 5 if get this... PANIC: read of clog file 5, offset 16384 failed: Success Hm, not good :-(. What files actually exist in $PGDATA/pg_clog/ (names and sizes)? So

Re: [GENERAL] Database Recovery Procedures

Quoting Tom Lane [EMAIL PROTECTED]: Network Administrator [EMAIL PROTECTED] writes: ..if I using the psql client, and issue a select * from corrupt table name limit 5 if get this... PANIC: read of clog file 5, offset 16384 failed: Success Hm, not good :-(. What files actually exist

Re: [GENERAL] Database Recovery Procedures

Network Administrator [EMAIL PROTECTED] writes: PANIC: read of clog file 5, offset 16384 failed: Success Hm, not good :-(. What files actually exist in $PGDATA/pg_clog/ (names and sizes)? -rw---1 postgres users 262144 Jul 20 15:53 -rw---1 postgres users

Re: [GENERAL] Database Recovery Procedures

Quoting Tom Lane [EMAIL PROTECTED]: Network Administrator [EMAIL PROTECTED] writes: PANIC: read of clog file 5, offset 16384 failed: Success Hm, not good :-(. What files actually exist in $PGDATA/pg_clog/ (names and sizes)? -rw---1 postgres users 262144 Jul 20 15:53

Re: [GENERAL] Database Recovery Procedures

Network Administrator [EMAIL PROTECTED] writes: PANIC: XLogWrite: write request 5/2D498000 is past end of log 5/2D498000 I'll bet you are running 7.3.3. You need to update to 7.3.4 to escape this startup bug. regards, tom lane ---(end of

Re: [GENERAL] Database recovery after fs crash

What operating system and file system? Can I guess Linux/ext2? --- Christian von Kietzell wrote: Hi, I've got a serious problem. After a horrible filesystem crash the only thing left of my database are some files in

Re: [GENERAL] Database recovery after fs crash

How do I do that? I don't know the format of the clog files. The only information I found was in clog.h and xlog.h. xlog is fairly easy, I think resetxlog or something can work there. For clog I just noted from the logs which clog files it was missing and created them filled with either 0x00

Re: [GENERAL] Database recovery after fs crash

Wow. Take to pull out those backups... Hmm, presumably you don't have those. There are programs to read postgresql data files however they need to know the exact structure of the table before you can even start to decode them. I usually start by browsing files by hand to see if I can determine

Re: [GENERAL] Database recovery after fs crash

On Tue, Aug 26, 2003 at 10:17:48AM +1000, Martijn van Oosterhout wrote: Wow. Take to pull out those backups... Hmm, presumably you don't have those. There are programs to read postgresql data files however they need to know the exact structure of the table before you can even start to decode

Re: [GENERAL] Database recovery after fs crash

Hmm, presumably you don't have those. Unfortunately not. All backup measures I took failed on the exact same occasion - worst case possible. I usually start by browsing files by hand to see if I can determine from any embedded text which table it was. Seems easy enough. Then if you create

[GENERAL] Database recovery after fs crash

Hi, I've got a serious problem. After a horrible filesystem crash the only thing left of my database are some files in /lost+found (with changed names!). Is there a way to recover the data from those files? I managed to identify the files belonging to PostgreSQL (unfortunately, these are part of

[GENERAL] Database Recovery Help...

Hi, I recently came across a problem wherein I am not able to start my postgreSQL 7.0.3 server. Here's what happens..;-( postgres@kahoy /root$ postmaster -D /var/lib/pgsql/data FATAL: StreamServerPort: bind() failed: Permission denied Is another postmaster already running on that

Re: [GENERAL] Database Recovery Help...

If you are sure that no other postmaster is running, try deleting the file /tmp/.s.PGSQL.5432, as the error message suggests. When you've done that, you should be able to start the postmaster. Poul L. Christiansen On Tue, 8 May 2001, John Clark L. Naldoza wrote: Hi, I recently came

[GENERAL] Database Recovery

Hi ! I have a big problem : all my datas are unavailable. When I do a vaccuum, that ok there are rows. When I do a "SELECT" or "\d", nothing. One of you told me that could be that I reached the max transaction ID. My pg_log is very big (1 Go !!) How could I retrieve my datas ? Of course I