pg_restore - Mailing list pgsql-bugs

From Branka Stancic
Subject pg_restore
Date
Msg-id BAY174-W14C6C62FF410A27CD3561DBB460@phx.gbl
Whole thread Raw
Responses Re: pg_restore
List pgsql-bugs
Hi=2CI have problem.I want to restore only data in database.In pgAdmin I wa=
s backup only data from old database and now i have  backup file backup.sql=
.In terminale I want restore only data in new database and I using command =
pg_restore -i -h localhost -p 5432 -U postgres -d payroll --data-only -v "/=
home/postgres/backup.sql"=2Cbut i get an error:pg_restore:[archiver] input =
file appears to be a text format dump.Please use psql
Thanks in advance for your suggestions.

                           =

pgsql-bugs by date:

Previous
From: dnd1066@gmail.com
Date:
Subject: BUG #7738: Installer takes hours running icacls
Next
From: "Kevin Grittner"
Date:
Subject: Re: Installing PG 7.3.4 on Linux 6