I do:
pg_dump -Ft mydb > mydb.tar
pg_restore -d newdb mydb.tar
and I get tuns of errors. Like:
pg_restore: [archiv߰ (db)] could not execute query: ERROR: relation "pg_ts_cfg
map" already exists
Command was: CREATE TABLE pg_ts_cfgmap (
ts_name text NOT NULL,
tok_alias text NOT NULL,
dict_name text[
Basically I need to copy db1 to db2 which I create manually. How do I do that,
I tried pg_dump pg_restore but I get some errors with foreign key restraint...
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http:/
>From time to time I get Notice: Unknown: Cannot set connection to blocking
>mode in Unknown on line 0.
What it is? Is it really a problem with postgresql. I am using Apache/2.2.3
(Unix) PHP/5.1.6/ postgresql 8.1
---(end of broadcast)---
TIP 4: Ha
I am experiencing pgAdmin (windows xp) crash whenever I try to connect to the
postgresql server (type password and hit enter). It started after installing
the new 8.2 version it didn't do it with the earlier versions. What do I have
wrong?
Thanks.
---(end of broadcast)--