pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpgdump
2+ messages / 2 participants
[nested] [flat]
* pgdump
@ 2006-12-08 00:21 anuradha devi <anura19@yahoo.com>
2006-12-08 01:55 ` Re: pgdump Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: anuradha devi @ 2006-12-08 00:21 UTC (permalink / raw)
To: pgsql-admin
Hi
I have a pgdump.sql file and i want to restore it.The postgreSQL database server is running and i issue the command psql -U postgres pgdump.sql in the command prompt.
i get the following error.
C:\Program Files\PostgreSQL\8.2\bin>psql -U postgres pgdump.sql
psql: could not connect to server: Invalid argument (0x00002726/10022)
Is the server running on host "???" and accepting
TCP/IP connections on port 5432?
Thanks
Anuradha
---------------------------------
Everyone is raving about the all-new Yahoo! Mail beta.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pgdump
2006-12-08 00:21 pgdump anuradha devi <anura19@yahoo.com>
@ 2006-12-08 01:55 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Rajesh Kumar Mallah @ 2006-12-08 01:55 UTC (permalink / raw)
To: anuradha devi <anura19@yahoo.com>; +Cc: pgsql-admin
On 12/8/06, anuradha devi <anura19@yahoo.com> wrote:
> Hi
> I have a pgdump.sql file and i want to restore it.The postgreSQL database
> server is running and i issue the command psql -U postgres pgdump.sql in the
> command prompt.
> i get the following error.
> C:\Program Files\PostgreSQL\8.2\bin>psql -U postgres pgdump.sql
> psql: could not connect to server: Invalid argument (0x00002726/10022)
> Is the server running on host "???" and accepting
> TCP/IP connections on port 5432?
Hi,
This error means the psql client is not able to connect to the server
that (may or maynot) be running in the machine. Make sure that
the server is running. see if the process postmaster is running.
once the server is running the command to restore is
the command to run a sql script file is :
psql -U postgres -f pgdump.sql
(you missed the -f)
Regds
mallah.
> Thanks
> Anuradha
>
>
> ________________________________
> Everyone is raving about the all-new Yahoo! Mail beta.
>
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-12-08 01:55 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-08 00:21 pgdump anuradha devi <anura19@yahoo.com>
2006-12-08 01:55 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox