Tagged Questions
0
votes
1answer
181 views
Moving data between Oracle and PostgreSQL
For a future project I need to use the following setup:
Some small (offline) data boxes (colleting data over the time) fill PostgreSQL databases. (Summing up to about 1 TB a year.
For time to time, I ...
3
votes
1answer
279 views
“Zero” downtime and minimal space requirements for upgrade to PostgreSQL 9.2
Need to migrate from PostgreSQL 8.3.x to 9.2
Constraint 1: 8.4 and above have made datetime format to be integer by default. Wasn't so in 8.3.x. As a result pg_upgrade can't be used. Unless server is ...
3
votes
2answers
161 views
Migrating and normalizing data
We are rewriting a large Django application which uses a MySQL database, and the database schema needs to undergo major modifications. We're also porting the app to use PostgreSQL, for a couple of ...
2
votes
1answer
216 views
Oracle to PostgreSQL
I'm having som test databases running Oracle 10 & 11 that I plan to try to migrate to PostgreSQL.
Some googling hinted that the perl script "ora2pg" could be of use, and free of charge. However, ...
1
vote
2answers
206 views
PostgreSQL Database Migration
How can I migrate data from on PostgreSQL database to another PostgreSQL database? Is there any technique to migrate data with SQL scripting?
12
votes
1answer
2k views
Best practices for schema changes and data migrations to a live database without downtime?
How do you make schema changes to a live database without downtime?
For instance, lets say I have a PostgreSQL database with a table including various user data like email addresses etc, all ...
3
votes
2answers
5k views
How to solve UTF8 invalid byte sequence copy errors on a restore, when the source database is encoded in UTF8?
I was given the task to migrate a PostgreSQL 8.2.x database to another server. To do this I'm using the pgAdmin 1.12.2 (on Ubuntu 11.04 by the way) and using the Backup and Restore using the ...
7
votes
1answer
2k views
How to migrate large blob table from mysql to postgresql?
I'm now in process of migrating my MySQL database to PostgreSQL. Almost everything went fine (well, after lots of googling for correct mysqldump params etc.) except one table I have - actually the ...
5
votes
2answers
513 views
Save postgres database from broken ubuntu 10.04 server
Recently a database server with an important db broke (some grub linux issue that I'd prefer not to solve).
I can still access the filesystem. Is there a chance to transfer the database by only ...
9
votes
4answers
2k views
Tools to migrate from SQLite to PostgreSQL
I need to continuously migrate from SQLite to PostgreSQL. By continuously, I mean that I will reimport the SQLite database into PostgreSQL every day. It would be nice if I could make changes to the ...
