pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedNeed assistance in incremental backup for my environment
3+ messages / 3 participants
[nested] [flat]
* Need assistance in incremental backup for my environment
@ 2013-01-15 06:23 Vinod V <vinodv@collabera.com>
2013-01-18 10:09 ` Re: Need assistance in incremental backup for my environment Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 1 reply; 3+ messages in thread
From: Vinod V @ 2013-01-15 06:23 UTC (permalink / raw)
To: pgsql-admin
Hi Team,
We need to implement incremental backup (PITR) in our environment, since our production database is in high risk.
We are running with PostgreSQL 9.1
We need to implement this on both Windows7 and Linux platforms.
We were able to get the WAL files generated on Windows platform but the recovery from the log files are not happening. Below were the error messages that we were getting when trying to restore it (while restarting the server).
2013-01-10 01:58:46 PST LOG: could not bind IPv6 socket: No error
2013-01-10 01:58:46 PST HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2013-01-10 01:58:46 PST LOG: could not bind IPv4 socket: No error
2013-01-10 01:58:46 PST HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
2013-01-10 01:58:46 PST WARNING: could not create listen socket for "*"
2013-01-10 01:58:46 PST FATAL: could not create any TCP/IP sockets
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
The system cannot find the file specified.
Below are the archive_command and restore_command,which I am using (on Windows7).
wal_level = archive
archive_mode = on
archive_command = 'copy "%p" "C:\\Program Files\\PostgreSQL\\9.1\\data\\wals\\%f"'
restore_command='copy 'C:\\Program Files\\PostgreSQL\\9.1\\data\\wals\\%f %p'
Please correct me if I am following a wrong procedure.
Thanks,
Vinod V
This e-mail contains Privileged and Confidential Information intended solely for the use of the addressee(s). It shall not attach any liability on the
sender or Collabera or its affiliates. Any views or opinions presented in this email are solely those of the sender and may not necessarily reflect the
opinions of Collabera or its affiliates. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify
the sender immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. While Collabera has taken reasonable precautions to minimize this risk, Collabera accepts no
liability for any damage that may be caused to you in the event that there is any virus in this e-mail or any attachments attached hereto. It is the
addresses(s) duty to check and scan this email and any attachments attached hereto for the presence of viruses prior to opening the email.
** Thank You **
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Need assistance in incremental backup for my environment
2013-01-15 06:23 Need assistance in incremental backup for my environment Vinod V <vinodv@collabera.com>
@ 2013-01-18 10:09 ` Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 0 replies; 3+ messages in thread
From: Albe Laurenz @ 2013-01-18 10:09 UTC (permalink / raw)
To: Vinod V *EXTERN* <vinodv@collabera.com>; pgsql-admin
Vinod V wrote:
> We need to implement incremental backup (PITR) in our environment, since our production database is in
> high risk.
>
> We are running with PostgreSQL 9.1
>
> We need to implement this on both Windows7 and Linux platforms.
You are not trying to restore WAL files from Windows on Linux
or vice versa, are you? Because that wouldn't work.
> We were able to get the WAL files generated on Windows platform but the recovery from the log files
> are not happening. Below were the error messages that we were getting when trying to restore it (while
> restarting the server).
>
>
>
> 2013-01-10 01:58:46 PST LOG: could not bind IPv6 socket: No error
> 2013-01-10 01:58:46 PST HINT: Is another postmaster already running on port 5432? If not, wait a few
> seconds and retry.
Is there something else blocking port 5432?
> 2013-01-10 01:58:46 PST LOG: could not bind IPv4 socket: No error
> 2013-01-10 01:58:46 PST HINT: Is another postmaster already running on port 5432? If not, wait a few
> seconds and retry.
> 2013-01-10 01:58:46 PST WARNING: could not create listen socket for "*"
> 2013-01-10 01:58:46 PST FATAL: could not create any TCP/IP sockets
>
> The system cannot find the file specified.
[...]
> Below are the archive_command and restore_command,which I am using (on Windows7).
>
> wal_level = archive
> archive_mode = on
> archive_command = 'copy "%p" "C:\\Program Files\\PostgreSQL\\9.1\\data\\wals\\%f"'
>
> restore_command=’copy ‘C:\\Program Files\\PostgreSQL\\9.1\\data\\wals\\%f %p’
What are these non-ASCII characters doing in restore_command?
That doesn't look right to me.
Use double quotes like in archive_command.
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Need assistance in incremental backup for my environment
@ 2013-01-17 21:38 Kevin Grittner <kgrittn@mail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Kevin Grittner @ 2013-01-17 21:38 UTC (permalink / raw)
To: Vinod V <vinodv@collabera.com>; pgsql-admin
Vinod V wrote:
> Below were the error messages that we were getting ... (while
> restarting the server).
>
>
> 2013-01-10 01:58:46 PST LOG: could not bind IPv6 socket: No error
> 2013-01-10 01:58:46 PST HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
> 2013-01-10 01:58:46 PST LOG: could not bind IPv4 socket: No error
> 2013-01-10 01:58:46 PST HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
> 2013-01-10 01:58:46 PST WARNING: could not create listen socket for "*"
> 2013-01-10 01:58:46 PST FATAL: could not create any TCP/IP sockets
It would appear that something is probably already (or still)
running on port 5432 when you try to start.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-01-18 10:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-01-15 06:23 Need assistance in incremental backup for my environment Vinod V <vinodv@collabera.com>
2013-01-18 10:09 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2013-01-17 21:38 Re: Need assistance in incremental backup for my environment Kevin Grittner <kgrittn@mail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox