pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAdvise on restoring from FileSystem backup
3+ messages / 2 participants
[nested] [flat]
* Advise on restoring from FileSystem backup
@ 2015-09-07 16:48 Porwal, Utkarsh <utkarsh.porwal@emc.com>
0 siblings, 1 reply; 3+ messages in thread
From: Porwal, Utkarsh @ 2015-09-07 16:48 UTC (permalink / raw)
To: pgsql-admin
Hi All,
I am taking a filesystem backup of the postgress data directory with the db stopped since I don't have pg_dump backups. Can you suggest how to restore it from this backup?
Can I stop the db, delete the actual data directory and move back the backed up data directory and start postgress?
Thanks and Regards,
Utkarsh Porwal
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Advise on restoring from FileSystem backup
@ 2015-09-07 16:53 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Porwal, Utkarsh <utkarsh.porwal@emc.com>
0 siblings, 1 reply; 3+ messages in thread
From: Scott Ribe @ 2015-09-07 16:53 UTC (permalink / raw)
To: Porwal, Utkarsh <utkarsh.porwal@emc.com>; +Cc: pgsql-admin
On Sep 7, 2015, at 10:48 AM, Porwal, Utkarsh <utkarsh.porwal@emc.com> wrote:
>
> Can I stop the db, delete the actual data directory and move back the backed up data directory and start postgress?
Yes, but first move the current data directory, don't delete it until you're sure the new is working.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
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: Advise on restoring from FileSystem backup
@ 2015-09-07 17:00 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 3+ messages in thread
From: Scott Ribe @ 2015-09-07 17:00 UTC (permalink / raw)
To: Porwal, Utkarsh <utkarsh.porwal@emc.com>; pgsql-admin
On Sep 7, 2015, at 10:55 AM, Porwal, Utkarsh <utkarsh.porwal@emc.com> wrote:
>
> But the filesystem backup should work, isn't it?
Yes, if:
- You've actually stopped the db when you think you have.
- You've actually correctly copied the data directory.
- Nothing mysterious was modifying the data while you were copying it.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
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:[~2015-09-07 17:00 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-09-07 16:48 Advise on restoring from FileSystem backup Porwal, Utkarsh <utkarsh.porwal@emc.com>
2015-09-07 16:53 ` Scott Ribe <scott_ribe@elevated-dev.com>
2015-09-07 17:00 ` Scott Ribe <scott_ribe@elevated-dev.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