Hi all,
I am trying to setup a second instance of bricolage for development, I
want to periodically
import the data from my production instance to the my dev instance...
I am trying to dump and restore from one DB to another but I keep
running into problems.
I am using postgres version 7.2.2 (stock version shipped with RH8.0)
both DB's are running on the same machine under the same postmaster.
The problem is that I cannot get the dump to load into the dev db.
pg_dump -F t bric > /tmp/pgdump.tar
pg_restore -d bricdev -N /tmp/pgdump.tar
<snip for brevity>
pg_restore: [archiver (db)] could not execute query: ERROR: Function
'login_avail(varchar, numeric, numeric)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
I've tried dumping in the plaintext format (calling pg_dump with no
arguments, with args, etc...), but the problem always seems to be that
dependent tables are not re-created
in the order in which they need to be (despite the fact I am using
"pg_restore -N -- restore in original dump order").
Sorry this is so longwinded...but I was hoping that somebody on this
list has run into this problem (this seems like a bug in PG 7.2.2 ) or
could tell me how they go about setting up a second db periodically
importing bric data from another database.
Thanks much,
--
-------------------------
Sean P. Scanlon
perl -le 'print pack("h*", "3707370426c6575646f647e2e65647")'
-------------------------
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general
I am trying to setup a second instance of bricolage for development, I
want to periodically
import the data from my production instance to the my dev instance...
I am trying to dump and restore from one DB to another but I keep
running into problems.
I am using postgres version 7.2.2 (stock version shipped with RH8.0)
both DB's are running on the same machine under the same postmaster.
The problem is that I cannot get the dump to load into the dev db.
pg_dump -F t bric > /tmp/pgdump.tar
pg_restore -d bricdev -N /tmp/pgdump.tar
<snip for brevity>
pg_restore: [archiver (db)] could not execute query: ERROR: Function
'login_avail(varchar, numeric, numeric)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
I've tried dumping in the plaintext format (calling pg_dump with no
arguments, with args, etc...), but the problem always seems to be that
dependent tables are not re-created
in the order in which they need to be (despite the fact I am using
"pg_restore -N -- restore in original dump order").
Sorry this is so longwinded...but I was hoping that somebody on this
list has run into this problem (this seems like a bug in PG 7.2.2 ) or
could tell me how they go about setting up a second db periodically
importing bric data from another database.
Thanks much,
--
-------------------------
Sean P. Scanlon
perl -le 'print pack("h*", "3707370426c6575646f647e2e65647")'
-------------------------
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general