pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgdump
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