Re: [GENERAL] Recovery damaged dump file

On Mon, Mar 13, 2017 at 7:40 PM, mac pack wrote: > Any one knows how pg_dump saves the dump in custom format. What is the > structure of the format, there is any doc about that? There are no docs, but the code in src/bin/pg_dump/pg_backup_custom.c can speak by itself if you are willing to know wh

Re: [GENERAL] Recovery damaged dump file

2017-03-10 14:58 GMT+00:00 Adrian Klaver : > On 03/10/2017 01:25 AM, mac pack wrote: > >> >> 2017-03-10 5:11 GMT+00:00 Adrian Klaver > >: >> >> >> On 03/09/2017 09:09 PM, Adrian Klaver wrote: >> >> On 03/09/2017 03:55 AM, mac pack wrote: >> >>

Re: [GENERAL] Recovery damaged dump file

2017-03-10 5:11 GMT+00:00 Adrian Klaver : > On 03/09/2017 09:09 PM, Adrian Klaver wrote: > >> On 03/09/2017 03:55 AM, mac pack wrote: >> >>> Hi. >>> >>> My PostgreSQL server was affect by a Ransomware virus. I'm trying to >>> restore the database from a dump file made by pg_dump in custom format >

Re: [GENERAL] Recovery damaged dump file

On 03/10/2017 01:25 AM, mac pack wrote: 2017-03-10 5:11 GMT+00:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>>: On 03/09/2017 09:09 PM, Adrian Klaver wrote: On 03/09/2017 03:55 AM, mac pack wrote: Hi. My PostgreSQL server was affect by a Ransomware vir

Re: [GENERAL] Recovery damaged dump file

On 03/09/2017 09:09 PM, Adrian Klaver wrote: On 03/09/2017 03:55 AM, mac pack wrote: Hi. My PostgreSQL server was affect by a Ransomware virus. I'm trying to restore the database from a dump file made by pg_dump in custom format (-F c option), but the dump file seems to be damaged in the first'

Re: [GENERAL] Recovery damaged dump file

On 03/09/2017 03:55 AM, mac pack wrote: Hi. My PostgreSQL server was affect by a Ransomware virus. I'm trying to restore the database from a dump file made by pg_dump in custom format (-F c option), but the dump file seems to be damaged in the first's 1000 lines. Opening the file with vi shows

Re: [GENERAL] Recovery damaged dump file

On Thu, Mar 9, 2017 at 8:55 PM, mac pack wrote: > pg_restore db.backup > out.sql > > pg_restore: [custom archiver] unrecognized data block type (0) while > searching archive > > The follow commands works fine: > pg_restore -s db.backup > out.sql > pg_restore -l db.backup If you are lucky and as

[GENERAL] Recovery damaged dump file

Hi. My PostgreSQL server was affect by a Ransomware virus. I'm trying to restore the database from a dump file made by pg_dump in custom format (-F c option), but the dump file seems to be damaged in the first's 1000 lines. Opening the file with vi shows ^@^@^@^@^@^@^@^@^@^@^ followed by part of

Re: [GENERAL] Recovery Assistance

On 01/29/2017 03:12 PM, Brian Mills wrote: OK. I think I'm on to something here, I first reset back to my file level backup. I created a recovery.conf file in the root of the data directory like this: - restore_command = 'cp /mnt/archive/%f %p' recovery_target_time = '2017-01-

Re: [GENERAL] Recovery Assistance

OK. I think I'm on to something here, I first reset back to my file level backup. I created a recovery.conf file in the root of the data directory like this: - restore_command = 'cp /mnt/archive/%f %p' recovery_target_time = '2017-01-24 02:08:00.023064+11' recovery_target_inclus

Re: [GENERAL] Recovery Assistance

On 01/28/2017 11:23 PM, Brian Mills wrote: I presume this is a binary log file for the database. Am I able to recover to a point in time using this log file? What I would do in SQL Server would be recover to a point in time, say a bit before the last completed transaction time the log mentions,

Re: [GENERAL] Recovery Assistance

On 01/28/2017 11:23 PM, Brian Mills wrote: I presume this is a binary log file for the database. Am I able to recover to a point in time using this log file? What I would do in SQL Server would be recover to a point in time, say a bit before the last completed transaction time the log mentions,

Re: [GENERAL] Recovery Assistance

I presume this is a binary log file for the database. Am I able to recover to a point in time using this log file? What I would do in SQL Server would be recover to a point in time, say a bit before the last completed transaction time the log mentions, then take a backup. Is that possible in post

Re: [GENERAL] Recovery Assistance

I have a consistent sql dump from 24 hour previous. The file level backup was done with rsync -a of full data directory after the issue occurred so could reset as I learned. Brian On Sun, 29 Jan 2017 at 9:18 am, Adrian Klaver wrote: > On 01/28/2017 01:55 PM, Brian Mills wrote: > > Yes, its th

Re: [GENERAL] Recovery Assistance

On 01/28/2017 01:55 PM, Brian Mills wrote: Yes, its the last one in the directory, pg_xlog directory ...more files... -rw--- 1 postgres postgres 16777216 Jan 21 10:05 0001000500A1 -rw--- 1 postgres postgres 16777216 Jan 22 21:29 0001000500A2 -rw--- 1 postgr

Re: [GENERAL] Recovery Assistance

Yes, its the last one in the directory, pg_xlog directory ...more files... -rw--- 1 postgres postgres 16777216 Jan 21 10:05 0001000500A1 -rw--- 1 postgres postgres 16777216 Jan 22 21:29 0001000500A2 -rw--- 1 postgres postgres 16777216 Jan 24 02:08 0001000

Re: [GENERAL] Recovery Assistance

Hello Brian, On Sun, 2017-01-29 at 07:16 +1100, Brian Mills wrote: > Hi, > > No, it hasn't changed since the first time I looked at it.  > > root@atlassian:/home/tbadmin# ps ax | grep post >  1364 ?        Ss     0:00 /usr/lib/postfix/master >  5198 pts/3    S      0:00 su postgres >  5221 pts/3

Re: [GENERAL] Recovery Assistance

Hi, No, it hasn't changed since the first time I looked at it. root@atlassian:/home/tbadmin# ps ax | grep post 1364 ?Ss 0:00 /usr/lib/postfix/master 5198 pts/3S 0:00 su postgres 5221 pts/3S 0:00 /usr/lib/postgresql/9.3/bin/postgres -D /etc/postgresql/9.3/main 522

Re: [GENERAL] Recovery Assistance

On 01/27/2017 05:40 PM, Brian Mills wrote: First of all, Thank you for your time to assist me learning. I really appreciate it. root# ps ax | grep post 1364 ?Ss 0:00 /usr/lib/postfix/master 5198 pts/3S 0:00 su postgres 5221 pts/3S 0:00 /usr/lib/postgresql/9.3/bin

Re: [GENERAL] Recovery Assistance

First of all, Thank you for your time to assist me learning. I really appreciate it. root# ps ax | grep post 1364 ?Ss 0:00 /usr/lib/postfix/master 5198 pts/3S 0:00 su postgres 5221 pts/3S 0:00 /usr/lib/postgresql/9.3/bin/postgres -D /etc/postgresql/9.3/main 5222 ?

Re: [GENERAL] Recovery Assistance

On 01/27/2017 01:31 PM, Brian Mills wrote: Hi, I have a Atlassian Confluence Wiki that depends on postgres, but I haven't much experience with postgres other than for this purpose. A few days ago, the hard disk filled, so all services stopped working. When the admin realised this he increased t

[GENERAL] Recovery Assistance

Hi, I have a Atlassian Confluence Wiki that depends on postgres, but I haven't much experience with postgres other than for this purpose. A few days ago, the hard disk filled, so all services stopped working. When the admin realised this he increased the disk size (its in a cloud, so that was eas

Re: [GENERAL] recovery dump on database with different timezone

On 01/24/2017 06:58 AM, Edmundo Robles wrote: thanks for your comments, i will change the constraints from date to timestamp with time zone, i hope this works :) There is good chance it will not work until the data is cleaned up or unless you pick just the right timezone to use in the constra

Re: [GENERAL] recovery dump on database with different timezone

thanks for your comments, i will change the constraints from date to timestamp with time zone, i hope this works :) On Mon, Jan 23, 2017 at 7:48 PM, Tom Lane wrote: > Adrian Klaver writes: > > On 01/23/2017 05:14 PM, David G. Johnston wrote: > >> To your example - testing in UTC is going to al

Re: [GENERAL] recovery dump on database with different timezone

Adrian Klaver writes: > On 01/23/2017 05:14 PM, David G. Johnston wrote: >> To your example - testing in UTC is going to always result in failure >> for Z values <= 0 since they will all result in a UTC date of >> 2011-01-01. Choosing +06 would result in a passed test. > That was sort of the poi

Re: [GENERAL] recovery dump on database with different timezone

On 01/23/2017 05:14 PM, David G. Johnston wrote: On Mon, Jan 23, 2017 at 6:08 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>>wrote: production=# show timezone; TimeZone -- UTC (1 row) production=# select ' 2011-01-01 00:00:03.925-06'::timestamptz < '

Re: [GENERAL] recovery dump on database with different timezone

On Mon, Jan 23, 2017 at 6:08 PM, Adrian Klaver wrote: > > production=# show timezone; > TimeZone > -- > UTC > (1 row) > > production=# select ' 2011-01-01 00:00:03.925-06'::timestamptz < > '2011-01-01'::date; > ?column? > -- > f > ​What Tom said - though I missed the part ab

Re: [GENERAL] recovery dump on database with different timezone

On 01/23/2017 05:01 PM, David G. Johnston wrote: On Mon, Jan 23, 2017 at 5:57 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>>wrote: * this the constraint: "time_stamp_201012ad" CHECK (time_stamp >= '2010-12-01'::date AND time_stamp < '2011-01-01'::

Re: [GENERAL] recovery dump on database with different timezone

Edmundo Robles writes: > * this the constraint: "time_stamp_201012ad" CHECK (time_stamp >= > '2010-12-01'::date AND time_stamp < '2011-01-01'::date) If that's on a timestamptz column, it's a seriously dangerous constraint, because the limitations it enforces are dependent on the current timezon

Re: [GENERAL] recovery dump on database with different timezone

On Mon, Jan 23, 2017 at 5:57 PM, Adrian Klaver wrote: > > * this the constraint: "time_stamp_201012ad" CHECK (time_stamp >= >> '2010-12-01'::date AND time_stamp < '2011-01-01'::date) >> >> if change 2011-01-01 00:00:03.925+00 to 2011-01-01 >> 00:00:03.925-06 wor

Re: [GENERAL] recovery dump on database with different timezone

On 01/23/2017 04:30 PM, Edmundo Robles wrote: * at last, i did 'pg_restore -l backup.dmp| sed "s:+00:-06:g"|psql The above is not the complete command, correct? the complete command is: pg_restore backup.dmp| sed "s:+00:-06:g"|psql database Another thought, do you ha

Re: [GENERAL] recovery dump on database with different timezone

On Mon, Jan 23, 2017 at 4:45 PM, Edmundo Robles wrote: > * This is the message: COPY failed for table "stlm_201012ad": ERROR: new > row for relation "stlm_201012ad" violates check constraint > "time_stamp_201012ad" > DETAIL: Failing row contains (..., 2011-01-01 00:00:03.925+00, .., 0). > > *

Re: [GENERAL] recovery dump on database with different timezone

On 01/23/2017 04:30 PM, Edmundo Robles wrote: On Mon, Jan 23, 2017 at 6:02 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 01/23/2017 03:45 PM, Edmundo Robles wrote: Hi! I have backed up a database with a 'UTC' timezone, but i can not to

Re: [GENERAL] recovery dump on database with different timezone

On Mon, Jan 23, 2017 at 6:02 PM, Adrian Klaver wrote: > On 01/23/2017 03:45 PM, Edmundo Robles wrote: > >> Hi! >> >> I have backed up a database with a 'UTC' timezone, but i can not to >> restore it on a database with 'localtime' timezone. >> > > Dealing with time is complex, so some inline q

Re: [GENERAL] recovery dump on database with different timezone

On 01/23/2017 03:45 PM, Edmundo Robles wrote: Hi! I have backed up a database with a 'UTC' timezone, but i can not to restore it on a database with 'localtime' timezone. Dealing with time is complex, so some inline questions below to try to figure out exactly what the setup is. I hav

[GENERAL] recovery dump on database with different timezone

Hi! I have backed up a database with a 'UTC' timezone, but i can not to restore it on a database with 'localtime' timezone. I have a time constraints, the reason of the mistakes. * First, I did: 'alter database set timezone='UTC'; 'but no restore it... * After I did change 'timezone

Re: [GENERAL] Recovery regression tests

work for me. Thanks. Regards Suraj kharage -Original Message- From: Michael Paquier [mailto:michael.paqu...@gmail.com] Sent: 08 January 2016 18:11 To: Kharage, Suraj Cc: PostgreSQL mailing lists Subject: Re: [GENERAL] Recovery regression tests On Fri, Jan 8, 2016 at 6:55 PM, kharagesuraj

Re: [GENERAL] Recovery regression tests

On Fri, Jan 8, 2016 at 6:55 PM, kharagesuraj wrote: > I have postgres-9.6 dev source code. > While executing regression tests(make check) for recovery i got following > message. > "TAP tests not enabled" > > I have pgTap(0.95) installed. The in-core TAP tests and pgTap are two independent things,

[GENERAL] Recovery regression tests

I have postgres-9.6 dev source code. While executing regression tests(make check) for recovery i got following message. "TAP tests not enabled" I have pgTap(0.95) installed. please help me on this. regards -- View this message in context: http://postgresql.nabble.com/Recovery-regression-tes

Re: [GENERAL] recovery of a windows archive in linux

Adrian, Jim: thanks a lot for your help. I'll replay my logs on a Windows machine very similar to the one that was hosting my db and see how it goes before I make a pg_dump for Linux. 2015-04-13 21:49 GMT-04:00 Adrian Klaver : > On 04/13/2015 04:37 PM, Guillaume Drolet wrote: > >> Dear list, >> >

Re: [GENERAL] recovery of a windows archive in linux

On 04/13/2015 04:37 PM, Guillaume Drolet wrote: Dear list, I have a base backup and archive logs from a Windows 7 PGSQL 9.3 install. The machine OS disk started to show signs of failure so I replaced it and now I want to switch for a Linux system. My question is: will I be able to play my archi

Re: [GENERAL] recovery of a windows archive in linux

On 4/13/15 6:37 PM, Guillaume Drolet wrote: Dear list, I have a base backup and archive logs from a Windows 7 PGSQL 9.3 install. The machine OS disk started to show signs of failure so I replaced it and now I want to switch for a Linux system. My question is: will I be able to play my archive l

[GENERAL] recovery of a windows archive in linux

Dear list, I have a base backup and archive logs from a Windows 7 PGSQL 9.3 install. The machine OS disk started to show signs of failure so I replaced it and now I want to switch for a Linux system. My question is: will I be able to play my archive logs and point-in-time recover on the Linux mac

Re: [GENERAL] recovery from incomplete backup (pgsql 8.3)

On 09/28/2013 11:31 AM, Henrik wrote: hello, I am trying to recover data from postgesql 8.3 incomplete backup. I have contents of data/base/ (fs snapshot), but there some tablespaces (indexes, some tables) were in other locations. On new server (clean install) I created database, replaced base

Re: [GENERAL] recovery from incomplete backup (pgsql 8.3)

On 09/28/2013 11:31 AM, Henrik wrote: hello, I am trying to recover data from postgesql 8.3 incomplete backup. I have contents of data/base/ (fs snapshot), but there some tablespaces (indexes, some tables) were in other locations. On new server (clean install) I created database, replaced base

[GENERAL] recovery from incomplete backup (pgsql 8.3)

hello, I am trying to recover data from postgesql 8.3 incomplete backup. I have contents of data/base/ (fs snapshot), but there some tablespaces (indexes, some tables) were in other locations. On new server (clean install) I created database, replaced base folder, renamed database folder to match

[GENERAL] Recovery failure

Hi List! On an originally designated hot_standby that had been not so hot for the last 24h i tried to replay the wal_files left over from a (seemingly corrupted) master server [missing clog... ]. I get this output: "/etc/postgresql/9.1/main/postgresql.conf" 584L, 19942C written root@pgstandby7:/

Re: [GENERAL] Recovery continually requests new WAL files

On 13/06/12 09:10, Albe Laurenz wrote: Alex Good wrote: I have a simple setup with one master and one backup server. I have an issue where I have performed a backup and copied it to the data directory for the slave, written a recovery.conf and copied in the backup_label file and then started the

Re: [GENERAL] Recovery continually requests new WAL files

On 13/06/12 11:10, Albe Laurenz wrote: Alex Good wrote: Although pgpool is involved this isn't actually about pgpool, I've been running through the recovery process manually to try and understand what needs to be done in order to get onlinve recovery working with pgpool. Pgpool isn't actuall

Re: [GENERAL] Recovery continually requests new WAL files

Alex Good wrote: > Although pgpool is involved this isn't actually about pgpool, I've been > running through the recovery process manually to try and understand what > needs to be done in order to get onlinve recovery working with pgpool. > Pgpool isn't actually running at the moment. Oh, I see.

Re: [GENERAL] Recovery continually requests new WAL files

On 13/06/12 10:29, Albe Laurenz wrote: Alex Good wrote: What I expected to see was the server requesting each WAL file up until the one which was archived during pg_stop_backup and then the server would consider itself to be recovered. Clearly I have misunderstood something here. These two se

Re: [GENERAL] Recovery continually requests new WAL files

Alex Good wrote: > What I expected to see was the server requesting each WAL file up until > the one which was archived during pg_stop_backup and then the server > would consider itself to be recovered. Clearly I have misunderstood > something here. > > These two servers are actually sat behind pg

Re: [GENERAL] Recovery continually requests new WAL files

Alex Good wrote: > I have a simple setup with one master and one backup server. I have an > issue where I have performed a backup and copied it to the data > directory for the slave, written a recovery.conf and copied in the > backup_label file and then started the server, it happily restores > eve

[GENERAL] Recovery continually requests new WAL files

Hey! I have a simple setup with one master and one backup server. I have an issue where I have performed a backup and copied it to the data directory for the slave, written a recovery.conf and copied in the backup_label file and then started the server, it happily restores everything up until

Re: [GENERAL] Recovery from Archive files

On Thu, Oct 20, 2011 at 11:42 AM, Raghavendra wrote: > On Thu, Oct 20, 2011 at 11:58 PM, John R Pierce wrote: >> >> On 10/20/11 2:33 AM, Raghavendra wrote: >>> >>> Am assuming you are having $PGDATA (data directory) and their WAL >>> Archives. >> >> he said he does not have the base backup ($PGDA

Re: [GENERAL] Recovery from Archive files

On Thu, Oct 20, 2011 at 11:58 PM, John R Pierce wrote: > On 10/20/11 2:33 AM, Raghavendra wrote: > >> Am assuming you are having $PGDATA (data directory) and their WAL >> Archives. >> > > he said he does not have the base backup ($PGDATA), so this is pointless. > > Ahh.. Agreed. I mis-read, I tho

Re: [GENERAL] Recovery from Archive files

On 10/20/11 2:33 AM, Raghavendra wrote: Am assuming you are having $PGDATA (data directory) and their WAL Archives. he said he does not have the base backup ($PGDATA), so this is pointless. -- john r pierceN 37, W 122 santa cruz ca mid-left

Re: [GENERAL] Recovery from Archive files

On Thu, Oct 20, 2011 at 10:01 AM, senthilnathan wrote: > Thanks John., > > Yes its from WAL Archives. I dont have the basebackup instead i am having > all the WAL files that are archived right from the server start. My > question > is how(steps?) to to build whole setup(postgres server)by replayin

Re: [GENERAL] Recovery from Archive files

On 10/19/11 9:31 PM, senthilnathan wrote: Thanks John., Yes its from WAL Archives. I dont have the basebackup instead i am having all the WAL files that are archived right from the server start. My question is how(steps?) to to build whole setup(postgres server)by replaying all WAL files WAL f

Re: [GENERAL] Recovery from Archive files

Thanks John., Yes its from WAL Archives. I dont have the basebackup instead i am having all the WAL files that are archived right from the server start. My question is how(steps?) to to build whole setup(postgres server)by replaying all WAL files (from 000100010

Re: [GENERAL] Recovery from Archive files

On 10/19/11 4:57 AM, senthilnathan wrote: How to recover a standalone postgres setup using archive files alone? What are the steps/config involved? 'archive files' ? you mean a WAL archive? you need the base backup *and* all WAL files since to recover with that. -- john r pierce

Re: [GENERAL] Recovery with WAL

Albert wrote: > > > Where can I find information about recovery_target_time or > recovery_target_xid. I have two servers db1 and db2, > WAL files are copied from db1 to db2. Database will colapse at 17:10 and > i wan't to recove base from 17:05, so where can I find info about > recovery_time.

[GENERAL] Recovery with WAL

Where can I find information about recovery_target_time or recovery_target_xid. I have two servers db1 and db2, WAL files are copied from db1 to db2. Database will colapse at 17:10 and i wan't to recove base from 17:05, so where can I find info about recovery_time. Albert -- Sent via p

Re: [GENERAL] recovery from out of disk space

On Wed, Oct 20, 2010 at 9:32 AM, Alexander B wrote: > I use PostGre 8.3 on Ubuntu. > > I realized last Friday that my /opt hard disk was full. The disk was full > about 2-4 hours of moderate activity. The disk  ran out of space for reasons > outside of postgres > I'm really at a loss of what to do

Re: [GENERAL] recovery from out of disk space

2010/10/20 Alexander B : > I use PostGre 8.3 on Ubuntu. > > I realized last Friday that my /opt hard disk was full. The disk was full > about 2-4 hours of moderate activity. The disk  ran out of space for reasons > outside of postgres > I'm really at a loss of what to do.  Does anyone have suggesti

Re: [GENERAL] recovery from out of disk space

One more note. I added extra disk space, so I cleared that part up. /dev/sdg1103210940 5766776 92201356 6% /opt From: Alexander B To: pgsql-general@postgresql.org Sent: Wed, October 20, 2010 8:32:22 AM Subject: [GENERAL] recovery from out of

[GENERAL] recovery from out of disk space

I use PostGre 8.3 on Ubuntu. I realized last Friday that my /opt hard disk was full. The disk was full about 2-4 hours of moderate activity. The disk ran out of space for reasons outside of postgres I'm really at a loss of what to do. Does anyone have suggestions for what my next step shoul

Re: [GENERAL] recovery fail

Hi! 2010/8/25 Łukasz Bieniek : > I'have made a backup my DB with pg_dump its (' pg_dump -U username dbname > >backupfilename.sql.gz. When i want to restore it ( I drop the old database > ,creaete new and language to it and i type a command 'cat > backupfilename.sql.gz|gunzip|/usr/local/pgsql/bi

Re: [GENERAL] recovery fail

2010/8/25 Łukasz Bieniek : > I'have made a backup my DB with pg_dump its (' pg_dump -U username dbname > >backupfilename.sql.gz. When i want to restore it ( I drop the old database > ,creaete new and language to it and i type a command 'cat > backupfilename.sql.gz|gunzip|/usr/local/pgsql/bin/psq

Re: [GENERAL] recovery fail

Le 25.08.2010 15:15, Łukasz Bieniek a écrit : I'have made a backup my DB with pg_dump its (' pg_dump -U username dbname>backupfilename.sql.gz. When i want to restore it ( I drop the old database ,creaete new and language to it and i type a command 'cat backupfilename.sql.gz|gunzip|/usr/local/p

[GENERAL] recovery fail

I'have made a backup my DB with pg_dump its (' pg_dump -U username dbname >backupfilename.sql.gz. When i want to restore it ( I drop the old database ,creaete new and language to it and i type a command 'cat backupfilename.sql.gz|gunzip|/usr/local/pgsql/bin/psql -U username dbname) this backup

Re: [GENERAL] recovery after interrupt in the middle of a previous recovery

Thanks. 2010/5/26 Tom Lane > Or Kroyzer writes: > > I am using postgres 8.3.1, > > ... you really ought to be using 8.3.something-recent ... > > > and have implemented warm standby very much like > > the one described in the high availability documentation on this site. > > It seems to work wel

Re: [GENERAL] recovery after interrupt in the middle of a previous recovery

Or Kroyzer writes: > I am using postgres 8.3.1, ... you really ought to be using 8.3.something-recent ... > and have implemented warm standby very much like > the one described in the high availability documentation on this site. > It seems to work well except for this problem: I've had a case w

[GENERAL] recovery after interrupt in the middle of a previous recovery

Hello, I am using postgres 8.3.1, and have implemented warm standby very much like the one described in the high availability documentation on this site. It seems to work well except for this problem: I've had a case where the postgresql server was interrupted while in recovery (I think it was a us

Re: [GENERAL] recovery mode

paulo matadr writes: > analyzing log file of server found this error: > cat /var/log/menssages > kernel: postmaster[1023]: segfault at fff0 rip 0060d993 > rsp 7fff15f53c28 error 4 > which means that? Well, it's a crash, but there's not nearly enough information here

[GENERAL] recovery mode

Hi all, my database entered in recovery mode last week, analyzing log file of server found this error: cat /var/log/menssages kernel: postmaster[1023]: segfault at fff0 rip 0060d993 rsp 7fff15f53c28 error 4 which means that? att Paul _

[GENERAL] recovery mode

Hi all, my database entered in recovery mode last week, analyzing log file of server found this error: cat /var/log/menssages kernel: postmaster[1023]: segfault at fff0 rip 0060d993 rsp 7fff15f53c28 error 4 which means that? att Paul __

[GENERAL] Recovery from crashed DB seems to occur progressively

Hello, I'm using version 8.3.5. The partition in which the 'pgsql' directory was became full. This database is normally used via an Hibernate/JDBC layer and one of the most common request is "SELECT * FROM MYTABLE LIMIT 10", from a webpage. I tried to delete some rows manually from psql ("dele

Re: [GENERAL] recovery after segmentation fault

Martijn van Oosterhout wrote: > On Wed, Apr 08, 2009 at 05:24:08PM +0200, Ivan Sergio Borgonovo wrote: >> How on Debian? >> Debian does all it's automagic stuff in init. I never learned how to >> start pg manually. > > What might be easier is turning on core dumps (ulimit -S -c unlimited) > and th

Re: [GENERAL] recovery after segmentation fault

On Wed, 8 Apr 2009 23:59:43 +0200 Martijn van Oosterhout wrote: > What might be easier is turning on core dumps (ulimit -S -c > unlimited) and then start postgres and see if it drops a core thanks. > > Is there a way to just kill recovery for one DB? Just don't > > start it at all? > > Unfortu

Re: [GENERAL] recovery after segmentation fault

On Wed, Apr 08, 2009 at 05:24:08PM +0200, Ivan Sergio Borgonovo wrote: > How on Debian? > Debian does all it's automagic stuff in init. I never learned how to > start pg manually. What might be easier is turning on core dumps (ulimit -S -c unlimited) and then start postgres and see if it drops a c

Re: [GENERAL] recovery after segmentation fault

On Wed, 08 Apr 2009 10:59:54 -0400 Tom Lane wrote: > Ivan Sergio Borgonovo writes: > > 2009-04-08 16:36:53 CEST LOG: startup process (PID 3176) was > > terminated by signal 11: Segmentation fault 2009-04-08 16:36:53 > > CEST LOG: aborting startup due to startup process failure > > Hmm, what P

Re: [GENERAL] recovery after segmentation fault

Ivan Sergio Borgonovo writes: > 2009-04-08 16:36:53 CEST LOG: startup process (PID 3176) was > terminated by signal 11: Segmentation fault 2009-04-08 16:36:53 CEST > LOG: aborting startup due to startup process failure Hmm, what Postgres version is this? Can you get a stack trace from the star

[GENERAL] recovery after segmentation fault

postgresql suddenly died... during recovery 2009-04-08 16:35:34 CEST FATAL: the database system is starting up ^^^ several 2009-04-08 16:35:34 CEST LOG: incomplete startup packet 2009-04-08 16:36:53 CEST FATAL: the database system is starting up 2009-04-08 16:36:53 CEST LOG: startup process

[GENERAL] Recovery mode

Hi there, Just noticed this in my webapp logs: ERROR: FATAL: the database system is in recovery mode Only one instance, so I'm not too concerned, but why, how often, how long for, etc. Am I negelecting to do some important database maintenace? Could it be related to the backup cron performs

Re: [GENERAL] recovery via base + WAL replay failure

Finally figured out what was wrong. The data folder had incorrect permissions after unzipping the base backup. For me, the solution was unchecking the "Inherit from parent the permission entries that apply to child objects" option in the Advanced Security Settings dialog for the data folder & g

Re: [GENERAL] recovery via base + WAL replay failure

PROTECTED]> wrote: From: Greg Smith <[EMAIL PROTECTED]> Subject: Re: [GENERAL] recovery via base + WAL replay failure To: "Rob Adams" <[EMAIL PROTECTED]> Cc: "postgres general" Date: Monday, August 4, 2008, 5:58 PM On Sun, 3 Aug 2008, Rob Adams wrote: I made a

Re: [GENERAL] recovery via base + WAL replay failure

. Thanks again, --Rob Adams Lennin Caro wrote: what error show the log file? --- On Mon, 8/4/08, Greg Smith <[EMAIL PROTECTED]> wrote: From: Greg Smith <[EMAIL PROTECTED]> Subject: Re: [GENERAL] recovery via base + WAL replay failure To: "Rob Adams" <[EMAIL PROTE

Re: [GENERAL] recovery via base + WAL replay failure

The WAL file archiving appears to be working correctly. These are the settings I'm using for archiving the WAL files: archive_mode = on archive_command = 'copy %p C:\backup\%f /A' archive_timeout = 15s Thanks again, --Rob Greg Smith wrote: On Sun, 3 Aug 2008, Rob Adams wrote: I made a b

Re: [GENERAL] recovery via base + WAL replay failure

what error show the log file? --- On Mon, 8/4/08, Greg Smith <[EMAIL PROTECTED]> wrote: > From: Greg Smith <[EMAIL PROTECTED]> > Subject: Re: [GENERAL] recovery via base + WAL replay failure > To: "Rob Adams" <[EMAIL PROTECTED]> > Cc: "postgres gene

Re: [GENERAL] recovery via base + WAL replay failure

On Sun, 3 Aug 2008, Rob Adams wrote: I made a base backup while the postgres was running using the following batch file: psql -d test_database -U user_name -c "SELECT pg_start_backup('test');" What did you have archive_command set to? That needs to dump the WAL files generated while the bac

Re: [GENERAL] recovery via base + WAL replay failure

Rob Adams wrote: > I'm trying to demonstrate recovery using the "continuous archiving" > backup technique. I'm using 8.3 on Windows. > > I made a base backup while the postgres was running using the following > batch file: > > -- > psql -d test_database -U user_name -c "S

[GENERAL] recovery via base + WAL replay failure

I'm trying to demonstrate recovery using the "continuous archiving" backup technique. I'm using 8.3 on Windows. I made a base backup while the postgres was running using the following batch file: -- psql -d test_database -U user_name -c "SELECT pg_start_backup('test')

Re: [GENERAL] recovery do not finish

On Fri, 11 Jul 2008, Benedek Laszlo wrote: We have waited for more than 2 hours, but psql still says that the system is starting up. In addition to the suggestions you've gotten to try a later version instead, I'd add that you should consider running vmstat in another window while the recov

Re: [GENERAL] recovery do not finish

On Fri, 2008-07-11 at 16:53 -0400, Alvaro Herrera wrote: > Benedek Laszlo wrote: > > Hello, > > > > I have a serious problem with a production database. > > We had a no disk space left on device problem, and postgres did not stop, > > so it was killed ( kill -9 ) > > we made free space and reboo

Re: [GENERAL] recovery do not finish

Benedek Laszlo wrote: > Hello, > > I have a serious problem with a production database. > We had a no disk space left on device problem, and postgres did not stop, so > it was killed ( kill -9 ) > we made free space and reboot, but postgres not start properly. > We have waited for more than 2 hou

[GENERAL] recovery do not finish

Hello, I have a serious problem with a production database. We had a no disk space left on device problem, and postgres did not stop, so it was killed ( kill -9 ) we made free space and reboot, but postgres not start properly. We have waited for more than 2 hours, but psql still says that the sys

Re: [GENERAL] Recovery from another installation

postgres 2.5 ??? wow ... that's an old version... Consider an upgrade... >From what i know, it shouldn't be a problem, because it's primarily the same sub-version... It would be another story if it was from 2.5 to 2.6 (in that case, you should use pg_dump_all) ... But i really don't know if with a

[GENERAL] Recovery from another installation

Dear Sirs, my question if it is possible to recovery a set of databases from a directory 'data' of a different machine. I have a machine with Postegres 2.5 and Windows 2000 crashed (OS does not start) but with filesystem OK, and another machine (with XP PRO and Postgres also 2.5). Can I copy the

Re: [GENERAL] Recovery/Restore and Roll Forward Question.

On Jun 21, 2007, at 5:16 AM, Bruce McAlister wrote: Thats exactly what I think. There is something strange going on. At the moment I think it is the disk I am writing the data to that is slow, possibly due to the fact that it is mounted up as "forcedirectio", so as not to interfere with the

  1   2   >