All Questions
Tagged with backup postgresql-9.2
8 questions
5
votes
1
answer
10k
views
Check if database backup using pg_dump is in progress
I am using PostgreSQL 9.2 and using pg_dump to create DB backup. How could I determine is db backup and restore is in progress. So I can prevent another user in initiating another.
- 51
3
votes
2
answers
3k
views
Automate COPY command - Postgres 9.2
I've a backup table with several distinct IDS... I wanna do a BACKUP of those rows, by ID.
The function has to be executed by a limit of account_id ( select dump(21); - Where 21 = number of account_id ...
- 311
1
vote
1
answer
139
views
Migrating from 32 bit using pg_basebackup
Has anyone migrated a 32 bit postgres 9.2 database to a 64 bit postgres 9.2?
I'm trying to use pg_basebackup but I'm not sure whether this is the right approach.
- 11
0
votes
1
answer
721
views
PostgreSQL replication with periodic log shipping
I'm using Windows Server 2008 R2 with 64-bit PostgreSQL 9.2 on both test machines. What I wish to achieve is that one server will be a master and other will be a slave. This is just for tests, finally ...
- 101
1
vote
1
answer
3k
views
database not restoring from dump file
I'm running the following command to create a dump of all database on my production server:
prodserver:/# pg_dumpall -U postgres -h 1.1.1.1 > prod.sql
on my development box, I also take a backup ...
- 781
0
votes
1
answer
438
views
postgresql backup and recovery
I’m trying to set up backup strategy for a production postgreSQL DB.
It will have large amount of data and it should be running 24 X 7.
Could you recommend some backup & recovery strategies that ...
- 21
3
votes
1
answer
2k
views
I need help understanding Postgres's archive cleanup functionality
I'm reading http://www.postgresql.org/docs/9.2/static/pgarchivecleanup.html and to me it seems like it will remove any and all WAL segments from my slave server that aren't required to perform ...
- 1,209
4
votes
1
answer
375
views
Postgresql, write archive file over mount, secure against simultaneous access?
I am using Postgres 9.2.1 and am saving my archivable WAL over a NFS share.
I just use the basic command, given as an example in the postgresql.conf
test ! -f /mnt/server/archivedir/%f && cp ...
- 577