pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_stop_backup()
3+ messages / 3 participants
[nested] [flat]
* pg_stop_backup()
@ 2010-03-17 14:41 Vitaly Burshteyn <vburshteyn@broadway.com>
2010-03-17 15:18 ` Re: pg_stop_backup() Bruce Momjian <bruce@momjian.us>
2010-03-18 08:58 ` Re: pg_stop_backup() Simon Riggs <simon@2ndQuadrant.com>
0 siblings, 2 replies; 3+ messages in thread
From: Vitaly Burshteyn @ 2010-03-17 14:41 UTC (permalink / raw)
To: pgsql-admin
Out of curiosity, any idea why every time I run select pg_stop_backup(); it goes into an infinite loop? While the first part of this select pg_start_backup(‘label’) works without any issues??
Vitaly Burshteyn
Senior Network Engineer
Broadway.com, Theatre Direct International
729 7th Avenue
New York, New York 10019
Phone: 212.817.9117
Cell# 917-701-5732
____________________________________
The information contained in this transmission may contain privileged
and confidential information. It is intended only for the use of the
person(s) named above. If you are not the intended recipient, you are
hereby notified that any review, dissemination, distribution or
duplication of this communication is strictly prohibited. If you are
not the intended recipient, please contact the sender by reply email
and destroy all copies of the original message.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_stop_backup()
2010-03-17 14:41 pg_stop_backup() Vitaly Burshteyn <vburshteyn@broadway.com>
@ 2010-03-17 15:18 ` Bruce Momjian <bruce@momjian.us>
1 sibling, 0 replies; 3+ messages in thread
From: Bruce Momjian @ 2010-03-17 15:18 UTC (permalink / raw)
To: Vitaly Burshteyn <vburshteyn@broadway.com>; +Cc: pgsql-admin
Vitaly Burshteyn wrote:
> Out of curiosity, any idea why every time I run select
> pg_stop_backup(); it goes into an infinite loop? While the
> first part of this select pg_start_backup(?label?) works without
> any issues??
pg_start_backup() is waiting for the archives to be stored. I would
look in the server logs to see if something if failing there. 9.0 will
have better feedback when pg_stop_backup hangs like that.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_stop_backup()
2010-03-17 14:41 pg_stop_backup() Vitaly Burshteyn <vburshteyn@broadway.com>
@ 2010-03-18 08:58 ` Simon Riggs <simon@2ndQuadrant.com>
1 sibling, 0 replies; 3+ messages in thread
From: Simon Riggs @ 2010-03-18 08:58 UTC (permalink / raw)
To: Vitaly Burshteyn <vburshteyn@broadway.com>; +Cc: pgsql-admin
On Wed, 2010-03-17 at 10:41 -0400, Vitaly Burshteyn wrote:
> Out of curiosity, any idea why every time I run select
> pg_stop_backup(); it goes into an infinite loop?
When you say "infinite" do you mean to say it never comes out of the
loop at all? Not sure if you are reporting a bug, or not.
The manual describes what is happening:
http://developer.postgresql.org/pgdocs/postgres/continuous-archiving.html#BACKUP-BASE-BACKUP
Step 5
Is there anything you think should be added to the manual?
--
Simon Riggs www.2ndQuadrant.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-03-18 08:58 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-17 14:41 pg_stop_backup() Vitaly Burshteyn <vburshteyn@broadway.com>
2010-03-17 15:18 ` Bruce Momjian <bruce@momjian.us>
2010-03-18 08:58 ` Simon Riggs <simon@2ndQuadrant.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