Re: [GENERAL] cannot dump structures
От | Martin Korous |
---|---|
Тема | Re: [GENERAL] cannot dump structures |
Дата | |
Msg-id | 1824.2729-29882-315633005-1197299256@seznam.cz обсуждение исходный текст |
Ответ на | Re: cannot dump structures (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Re: [GENERAL] cannot dump structures
|
Список | pgsql-general |
< You're running a 7.something pg_dump against an 8.something server. < This will not work because that pg_dump doesn't know about 8.x < catalog layout. its standard answer for message `ERROR: column "datpath"....` but I wrote: DATABASE: #/var/pgsql/bin/pg_dump --version pg_dump (PostgreSQL) 8.2.5 and WEBSERVER in CHROOT: #chroot /usr/local/chroot/apache_phpPgAdmin /var/pgsql/bin/pg_dump --version pg_dump (PostgreSQL) 8.2.5 < My advice is never, never, never use the -i option to pg_dump. < It is generally only useful for shooting yourself in the foot, < as is happening here. dump only data is not good too, works only with -i < You need to reconsider "impossible". Maybe your search path < isn't what you think it is. I dont use search path, i wrote absolute path: $cmd = '/var/pgsql/bin/pg_dump dbname -U username -h hostname -s -i'; pg_dump out of chroot work in chroot doesnt work...mystery regards Martin Korous
В списке pgsql-general по дате отправления: