Jay McGaffigan writes:
> So my first question.
> If I can't use a psql 9.2.2 instance to create the backup. Are there
> 'best' practices I should follow in creating the backup. All my googling
> hasn't really been able to point to the best approach.
We do recommend using the newer pg_dump in
If Tom's suggestion doesn't work, can you do your text dump by schema,
or for a subset of tables, and see if you can isolate the problem
table. (using the -n or -t options)
Have you changed the locale / languages settings between db versions?
If you find a quoting problem in a very large table you
Jay McGaffigan writes:
> I've been trying to restore a fairly sizeable database dump from my
> production server onto my dev box.
> Recently upgraded to 9.2.2 and wanted to try it out.
> So I grabbed a text dump of the database and tried the "Createdb dbname;
> psql < dmpfile" way of restoring
On 02/08/2013 12:43 PM, Jay McGaffigan wrote:
Hi,
I've been trying to restore a fairly sizeable database dump from my
production server onto my dev box.
Recently upgraded to 9.2.2 and wanted to try it out.
So I grabbed a text dump of the database and tried the "Createdb
dbname; psql < dmpfi
Hi,
I've been trying to restore a fairly sizeable database dump from my
production server onto my dev box.
Recently upgraded to 9.2.2 and wanted to try it out.
So I grabbed a text dump of the database and tried the "Createdb dbname;
psql < dmpfile" way of restoring that's always worked for me be
