From anura19@yahoo.com Fri Dec 8 00:28:22 2006 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id AA8A59F9C9E for ; Thu, 7 Dec 2006 20:28:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 29891-04 for ; Thu, 7 Dec 2006 20:28:13 -0400 (AST) X-Greylist: delayed 00:06:39.436081 by SQLgrey-1.7.4 Received: from web90510.mail.mud.yahoo.com (web90510.mail.mud.yahoo.com [216.252.100.177]) by postgresql.org (Postfix) with SMTP id 67EC29F9C35 for ; Thu, 7 Dec 2006 20:28:13 -0400 (AST) Received: (qmail 47583 invoked by uid 60001); 8 Dec 2006 00:21:32 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=q2QbHKhFbrWeRkA+9gaFUtOwrhHzNy1GL5kp0yD5eyMD17nZJDDsZdRPCCgfXPQnNKSMZ+Qs67w2De+YA3FJam7rsuAn4VqjddSdUGGYuh89kyw+J1PfDOPbJWMvc3n77l48YcnJunvgdEvC2770V4bJjQke7fyiqUhJOREJbtI=; X-YMail-OSG: 00uUyiQVM1k06zQRAW7C0ir51Il9.l1YROW8_EbSfJMTooP525ZVAlB5RN3R585kLd7Lw3TTnQuEc59yByHe7yRchuCQTPjYB34xKPIYQhtxJwtHfuQgkP1qfluORw.D01zbj8EUdXYsQQgU1jNeNG66O_gqNv_qlcLBsVWFfhBwPxBedvmrOBV_TjCk8PFESm14VqUNLQ3Qrn0- Received: from [12.104.159.252] by web90510.mail.mud.yahoo.com via HTTP; Thu, 07 Dec 2006 16:21:32 PST Date: Thu, 7 Dec 2006 16:21:32 -0800 (PST) From: anuradha devi Subject: pgdump To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-550440521-1165537292=:46863" Content-Transfer-Encoding: 8bit Message-ID: <693379.46863.qm@web90510.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/49 X-Sequence-Number: 23841 --0-550440521-1165537292=:46863 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-550440521-1165537292=:46863 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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. --0-550440521-1165537292=:46863-- From mallah.rajesh@gmail.com Fri Dec 8 01:55:21 2006 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0286A9FA19D for ; Thu, 7 Dec 2006 21:55:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 50200-10 for ; Thu, 7 Dec 2006 21:55:15 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.179]) by postgresql.org (Postfix) with ESMTP id A6ED69FA136 for ; Thu, 7 Dec 2006 21:55:15 -0400 (AST) Received: by py-out-1112.google.com with SMTP id d32so354728pye for ; Thu, 07 Dec 2006 17:55:14 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=RMGhhCTnPs7f+KgZETpqEdBkKskPDRhqWUt1FpL4YqRQ9iUazfoVuNIH62kYiRdYEgr8+qHM4rMXRWK9mxGytcLO+5dLstYeQmhXfr3XCJ/KWaNIoFjdWVteQXOW0w8Sf1LvQOaHjgcCPpGsH7RMygUschkLofSQhaNWcBAW9ok= Received: by 10.35.9.15 with SMTP id m15mr2266211pyi.1165542914464; Thu, 07 Dec 2006 17:55:14 -0800 (PST) Received: by 10.35.80.8 with HTTP; Thu, 7 Dec 2006 17:55:14 -0800 (PST) Message-ID: Date: Fri, 8 Dec 2006 07:25:14 +0530 From: "Rajesh Kumar Mallah" To: "anuradha devi" Subject: Re: pgdump Cc: pgsql-admin@postgresql.org In-Reply-To: <693379.46863.qm@web90510.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <693379.46863.qm@web90510.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/50 X-Sequence-Number: 23842 On 12/8/06, anuradha devi 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. > >