Tom Lane wrote:
Fischer Ulrich <[EMAIL PROTECTED]> writes:
pg_dump (PostgreSQL) 7.3.2
(pg_dumpall -g GLOBALobjects.sql)
pg_dump -s DATABASE > DBschema.sql
pg_dump -Fc DATABASE > DBdata.tar
and rebuilt on the new system with:
psql (PostgreSQL) 7.4.1
1. createdb DATABASE
2 Apr 2004, Fischer Ulrich wrote:
Some additional infos to my problem
Old System: Postgresql 7.3.2
New System: Postgresql 7.4.1
pg_dump (PostgreSQL) 7.3.2
(pg_dumpall -g GLOBALobjects.sql)
pg_dump -s DATABASE > DBschema.sql
pg_dump -Fc DATABASE > DBdata.tar
and rebuilt on the new
tgreSQL) 7.4.1". I
get the same error. When I do not update the dict-settings
(setup_ge_ispell.sql) I can not even restore the other datas.
Ulrich
Andreas Schmitz wrote:
How exactly is the dump created and the restore started ?
On Thursday 22 April 2004 10:55, Fischer Ulrich wrote
Hi
I'm trying to restore tsearch2 featuring database like discribed in the
'tsearch-V2-intro' document.
(http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html)
In point '5) Restore the data for the database' I get the following Error:
pg_restore: ERROR: duplicate k
The schema/data separation is higly recommended in the HowTo of tsearch2.
Thanks for your idea, I'l try it!
Ulrich
Grega Bremec wrote:
...and on Wed, Apr 21, 2004 at 02:46:54PM +0200, Fischer Ulrich used the keyboard:
Hi
I try to move my datas from a postresql 7.3.2 to a postgresql 7.4.1
Hi
I try to move my datas from a postresql 7.3.2 to a postgresql 7.4.1. The
database was dumped with:
pg_dumpall -g GLOBALobjects.sql
pg_dump -s DATABASE > DBschema.sql
pg_dump -Fc DATABASE > DBdata.tar
and rebuilt on the new system with:
createdb DATABASE
psql DATABASE < GLOBALobject
