pg_rman show doesn't show anything and incrementals don't work after validate?
63 views
Skip to first unread message
Ken
Feb 8, 2012, 4:02:52 PM2/8/12
to pg_rman
bash-4.1$ /usr/pgsql-9.1/bin/pg_rman backup -B /home/postgres/bak
INFO: database backup start
NOTICE: pg_stop_backup complete, all required WAL segments have been
archived
bash-4.1$ /usr/pgsql-9.1/bin/pg_rman validate -B /home/postgres/bak
bash-4.1$ /usr/pgsql-9.1/bin/pg_rman backup -b i -B /home/postgres/bak
INFO: database backup start
ERROR: There is indeed a full backup but it is not validated.So I
can't take any incremental backup.Please validate it and retry.
NOTICE: pg_stop_backup complete, all required WAL segments have been
archived
bash-4.1$ /usr/pgsql-9.1/bin/pg_rman show -B /home/postgres/bak
============================================================================
Start Time Total Data WAL Log Backup
Status
============================================================================
I'm puzzled by this behavior...for some reason, pg_rman doesn't know
there are any backups.
the timeline_history file is blank
The subdirectory 20120208 contains files that look like backups.
This is a new postgresql 9.1 server with a database with tables, but
no data in the tables yet. I just wanted to test whether it can
backup/restore an empty database and restore the DB schema...
INFO: database backup start
NOTICE: pg_stop_backup complete, all required WAL segments have been
archived
bash-4.1$ /usr/pgsql-9.1/bin/pg_rman validate -B /home/postgres/bak
bash-4.1$ /usr/pgsql-9.1/bin/pg_rman backup -b i -B /home/postgres/bak
INFO: database backup start
ERROR: There is indeed a full backup but it is not validated.So I
can't take any incremental backup.Please validate it and retry.
NOTICE: pg_stop_backup complete, all required WAL segments have been
archived
bash-4.1$ /usr/pgsql-9.1/bin/pg_rman show -B /home/postgres/bak
============================================================================
Start Time Total Data WAL Log Backup
Status
============================================================================
I'm puzzled by this behavior...for some reason, pg_rman doesn't know
there are any backups.
the timeline_history file is blank
The subdirectory 20120208 contains files that look like backups.
This is a new postgresql 9.1 server with a database with tables, but
no data in the tables yet. I just wanted to test whether it can
backup/restore an empty database and restore the DB schema...
Ken
Feb 10, 2012, 10:32:35 AM2/10/12
to pg_rman
FYI, I added data to the database, but the behavior is still the
same....seems like a pg_rman bug to me :-P
And to make it clear, I'm running this as the postgres user, so there
should be no permissions issues...
same....seems like a pg_rman bug to me :-P
And to make it clear, I'm running this as the postgres user, so there
should be no permissions issues...
Jota
Mar 2, 2012, 12:09:13 PM3/2/12
to pg_rman
Hello,
I have the same problem. I'm working with PostgreSQL 9.0.4 and CentOS
release 5.6 (Final). Is there any problem with this pair? I'm
avaliable to help if necessary.
News about this problem?
Regards
release 5.6 (Final). Is there any problem with this pair? I'm
avaliable to help if necessary.
News about this problem?
Regards
Arun Ramakrishnan
Oct 15, 2013, 1:18:16 AM10/15/13
to pg_...@googlegroups.com, ken...@gmail.com
I am getting the same behavior with Postgres 9.2 and Sles 11(64bit) on my machines as well. I tried the same with RHEL and again no output from the show command. The backup seems to succeed when observed with --debug. So not sure why the backup entry doesnt appear in the show/show timeline output at all.
Thanks for your help.
Thanks for your help.
Reply all
Reply to author
Forward
0 new messages