1
vote
2answers
1k views

How can I restore a microsoft sql server database backup to postgres?

I need to take a Microsoft SQL Server database backup (dump) file and import/restore into a PostgreSQL database. Does anybody have some sort of transform script (maybe a perl/sed/awk script) that ...
1
vote
1answer
1k views

How to make a full backup of an ubuntu root server with tar?

I am running ubuntu 10.04 LTS on a remote root server and almost the same setup on a development server over virtualbox. My goal is to backup the remote root server to an ftp-account. In case the hard ...
4
votes
2answers
15k views

Export and import a PostgreSQL database with a different name?

Is there a way to export a PostgreSQL database and later import it with another name? I'm using PostgreSQL with Rails and I often export the data from production, where the database is called ...
1
vote
1answer
219 views

How does one restore dump of block device in Linux

Lets say I create a dump of a block device like so dump -0 -A L0.archive -f L0.dump /dev/sde1 Now in this case sde1 is not mounted, as to not be live. So how can I restore sde1 from the other ...
1
vote
1answer
60 views

restore -A usage

I have created a number of dump files using Linux dump(8), using the -A option to get a table of contents on disk (the backups are on tape). Now I'm trying to look into these archive files, using ...
0
votes
3answers
959 views

PostgreSQL, update existing rows with pg_restore

I need to sync two PostgreSQL databases (some tables from development db to production db) sometimes. So I came up with this script: [...] pg_dump -a -F tar -t table1 -t table2 -U user1 dbname1 | \ ...