I'm attempting to restore a dump from one server to another (one is a Mac and one is a Linux base, if that makes any difference). I keep running into issues like this:
pg_restore: [archiver (db)] could not execute query: ERROR: function public.random_page_link_id_gen() does not exist
This is what I'm using to restore the files with:
pg_restore -O -x -s -N -d nuvio mac_postgres_2_2_2005_13_24
Any suggestions on how to get around this problem? It's a huge pain so far just to sync my two servers up.
Bradley Miller
<x-tad-bigger>NUVIO CORPORATION</x-tad-bigger><x-tad-bigger>
Phone: 816-444-4422 ext. 6757
Fax: 913-498-1810
</x-tad-bigger><x-tad-bigger>http://www.nuvio.com</x-tad-bigger><x-tad-bigger>
</x-tad-bigger><x-tad-bigger>[EMAIL PROTECTED]</x-tad-bigger>
- [SQL] pg_restore problem Bradley Miller
- Re: [SQL] pg_restore problem Joel Fradkin
- Re: [SQL] pg_restore problem Tom Lane
- Re: [SQL] pg_restore problem Bradley Miller
- Re: [SQL] pg_restore problem Richard Huxton
- Re: [SQL] pg_restore problem Bradley Miller