| From: | Ali Mumcu <alimumcu1077(at)gmail(dot)com> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | File system Backup On Postgresql |
| Date: | 2017-02-08 08:37:28 |
| Message-ID: | CAByegeJqCb59bQ5oAH4pdo8HGfJg5w-evRbYEY+H-vo_X2sw-A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Hello Frineds,
i wannt to get postgresl cluster file system level backup.
My scenario is like this:
*1.Step ) Pre Synchronization*
rsync -avHK --delete /var/lib/pgsql/ /backup/pgsql/
*2. Step.) Stop Service for consistent Backup *
systemctl stop postgresql-9.5
*3. Step.) Make File System Level Backup*
rsync -avHK --delete /var/lib/pgsql/ /backup/pgsql/
*4.Step.) Start Service Again*
systemctl start postgresql-9.5
*In This Scenario *
*I ask to you , can we lock all databases for write , delete and update
query during the backup Instead of stopping the service. ??*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Graham Jackson | 2017-02-08 10:27:58 | Ctrl+f doesn't work |
| Previous Message | Murtuza Zabuawala | 2017-02-06 14:08:46 | Re: pgAdmin4 - Fetching Type Error |