Tagged Questions
0
votes
0answers
28 views
Should I keep pg_xlog on the same disk as data if using disk snapshotting?
We're running on EBS volumes on EC2. We're interested in leveraging
EBS snapshotting for backups. However, does this mean we'd need to
ensure our pg_xlog is on the same EBS volume as our data?
(I ...
0
votes
1answer
311 views
What is the proper way to backup MySQL database with rsnapshot?
I want to backup my website that contains both user uploaded images and data stored in MySQL database such that they are always consistent with each other in any particular point of time. While ...
4
votes
3answers
157 views
What methods are available to create a snapshot of an oracle database for testing purposes?
I am new to databases and have just been assigned to work with Oracle. We want to create a snapshot of the database for testing purposes that will allow us to revert back once we're done.
I'm a bit ...
0
votes
1answer
556 views
How to Create Snapshot Backups in MySQL
I've seen a lot of people talking about snapshots backup, even I'm reading a book about mysql but nobody explain the code how to make a snapshots backup. This is what the book says:
flush tables ...
4
votes
1answer
354 views
Why are Stored Procedure schema changes not being replicated when using ”initialize with backup”?
In SQL Server I have set up transational replication using the "initialize with backup" option. Data is being replicated fine, as are schema changes to tables. However, schema changes to stored ...
