Quote: "However if you have to modify table definitions, you will probably
not be able to import data in that new schema and it will be necesary to
look for a new strategy."
For schema, are we talking about attribute columns (structure of table) and
"table definitions" referraled you talking about
Thanks. Is it by doing these steps I can avoid constrain restriction? for
step 3, how should I modify the schema? and which schema? the target DB's
schema that I am trying to dump the schema and data in? But this is the
problem, I am not sure whats different between the two schema's, there are
just
yeah that's what I means to do.
How do I use 8.4 pg_restore? the DB server I am trying to restore is using
8.3. Do you mean do pg_restore on the same machine that I did pg_dump?? I am
thinking of doing that too, but I am not sure how to do the command.
Is this correct? pg_restore -h (my target ma
On 23/02/10 09:17, Net Tree Inc. wrote:
Why am I keep getting error with version issues I am trying to restore a
backup file from a 8.4 postgresql server to a 8.3 postgresql server.
Well, an 8.4 dump isn't always going to be compatible with an 8.3
server, is it? If there weren't difference
Why am I keep getting error with version issues I am trying to restore a
backup file from a 8.4 postgresql server to a 8.3 postgresql server.
[postg...@localhost ~]$ pg_restore -C -d postgres -i isamdb.backup
pg_restore.bin: [archiver] unsupported version (1.11) in file header
On Tue, Feb 23
"Net Tree Inc." wrote:
> When I do restore it shown alot errors related with constraints.
> How can I dump and to restore from old to new without dealing with
> constraint and just forces data dump to where it suppose to belong?
What version are you dumping from and to? Exactly what errors ar