From sandhyar@amiindia.co.in Thu Jan 19 05:31:35 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 25B9A9DC841 for ; Thu, 19 Jan 2006 01:31:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31084-05 for ; Thu, 19 Jan 2006 01:31:33 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 46D0E9DC9C1 for ; Thu, 19 Jan 2006 01:31:28 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with SMTP id k0J5QWJE003951 for ; Thu, 19 Jan 2006 10:56:32 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 27E7133266C; Thu, 19 Jan 2006 10:56:04 +0530 (IST) Message-ID: <005501c61cba$0baf7220$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Cc: "sandhya" Subject: reg:pg_ctl Date: Thu, 19 Jan 2006 11:04:39 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0052_01C61CE8.2431C630" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:77.99669 C:21 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.067 required=5 tests=[AWL=0.065, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.067 X-Spam-Level: X-Archive-Number: 200601/204 X-Sequence-Number: 20292 This is a multi-part message in MIME format. ------=_NextPart_000_0052_01C61CE8.2431C630 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am facing the following problem, C:\Program Files\PostgreSQL\8.0\bin>pg_ctl reload -D C:\Program = Files\PostgreSQL\8.0\data pg_ctl: too many command-line arguments (first is = "Files\PostgreSQL\8.0\data") Try "pg_ctl --help" for more information. Please explain me what i need to do... -Sandhya ------=_NextPart_000_0052_01C61CE8.2431C630 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
I am facing the following problem,
C:\Program Files\PostgreSQL\8.0\bin>pg_ctl reload = -D=20 C:\Program Files\PostgreSQL\8.0\data
 
pg_ctl: too many command-line arguments (first is=20 "Files\PostgreSQL\8.0\data")
Try "pg_ctl --help" for more=20 information.
 
Please explain me what i need to do...
 
-Sandhya
------=_NextPart_000_0052_01C61CE8.2431C630-- From jeff@frostconsultingllc.com Thu Jan 19 05:39:18 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id BBA489DC80D for ; Thu, 19 Jan 2006 01:39:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27851-09 for ; Thu, 19 Jan 2006 01:39:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp106.sbc.mail.mud.yahoo.com (smtp106.sbc.mail.mud.yahoo.com [68.142.198.205]) by postgresql.org (Postfix) with SMTP id EB7239DC820 for ; Thu, 19 Jan 2006 01:39:14 -0400 (AST) Received: (qmail 6944 invoked from network); 19 Jan 2006 05:39:14 -0000 Received: from unknown (HELO discord.dyndns.org) (jeffroe996@sbcglobal.net@69.226.242.241 with plain) by smtp106.sbc.mail.mud.yahoo.com with SMTP; 19 Jan 2006 05:39:13 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by discord.dyndns.org (8.13.4/8.13.4) with ESMTP id k0J5dAsm030907; Wed, 18 Jan 2006 21:39:13 -0800 Date: Wed, 18 Jan 2006 21:39:10 -0800 (PST) From: Jeff Frost X-X-Sender: jeff@discord.dyndns.org To: sandhya cc: Postgres Subject: Re: reg:pg_ctl In-Reply-To: <005501c61cba$0baf7220$cd00000a@sandhyar> Message-ID: References: <005501c61cba$0baf7220$cd00000a@sandhyar> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/206 X-Sequence-Number: 20294 You have to put quotes around the paths. Ex: pg_ctl reload -D "C:\Program Files\PostgreSQL\8.0\data" On Thu, 19 Jan 2006, sandhya wrote: > Hi, > > I am facing the following problem, > C:\Program Files\PostgreSQL\8.0\bin>pg_ctl reload -D C:\Program Files\PostgreSQL\8.0\data > > pg_ctl: too many command-line arguments (first is "Files\PostgreSQL\8.0\data") > Try "pg_ctl --help" for more information. > > Please explain me what i need to do... > > -Sandhya -- Jeff Frost, Owner Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 From jeff@frostconsultingllc.com Thu Jan 19 07:00:38 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A8F969DC820 for ; Thu, 19 Jan 2006 03:00:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 45449-07 for ; Thu, 19 Jan 2006 03:00:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp103.sbc.mail.mud.yahoo.com (smtp103.sbc.mail.mud.yahoo.com [68.142.198.202]) by postgresql.org (Postfix) with SMTP id A65259DC80D for ; Thu, 19 Jan 2006 03:00:35 -0400 (AST) Received: (qmail 16870 invoked from network); 19 Jan 2006 07:00:36 -0000 Received: from unknown (HELO discord.dyndns.org) (jeffroe996@sbcglobal.net@69.226.242.241 with plain) by smtp103.sbc.mail.mud.yahoo.com with SMTP; 19 Jan 2006 07:00:36 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by discord.dyndns.org (8.13.4/8.13.4) with ESMTP id k0J70XMO001500; Wed, 18 Jan 2006 23:00:36 -0800 Date: Wed, 18 Jan 2006 23:00:33 -0800 (PST) From: Jeff Frost X-X-Sender: jeff@discord.dyndns.org To: sandhya cc: pgsql-admin@postgresql.org Subject: Re: reg:pg_ctl In-Reply-To: <00b501c61cc5$8e178940$cd00000a@sandhyar> Message-ID: References: <005501c61cba$0baf7220$cd00000a@sandhyar> <00b501c61cc5$8e178940$cd00000a@sandhyar> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/207 X-Sequence-Number: 20295 Please do not resend questions to me directly that you have already sent to the list. I do not work in VC++ but I would first check that the postgres user (or whatever user the postmaster is running as) has access to the files. On Thu, 19 Jan 2006, sandhya wrote: > Hi Thank you Jeff, > But the same i am using in Application VC++.Here also it is considering the > space after Program.... in Program Files. > What needs to be modified in that case .Please help me in solving this. > I am using 'lo_import' in windows application and trying to import the > files to the database. > > If the path i am giving like: > C:\\Program Files\\sample.htm > > It is not considering and i am getting the error as: > Could not open server file "C:\\Program Files\\sample.htm" > If i give : > C:\\sample.htm > > It is importing properly and storing it in the specified table also. > > Why it is not doing in the previous case. > But the same i did throug command line and worked file.Through application > it is not doing..... > Please help me.I need it very urgently. > ----- Original Message ----- > From: "Jeff Frost" > To: "sandhya" > Cc: "Postgres" > Sent: Thursday, January 19, 2006 11:09 AM > Subject: Re: [ADMIN] reg:pg_ctl > > >> You have to put quotes around the paths. Ex: >> >> pg_ctl reload -D "C:\Program Files\PostgreSQL\8.0\data" >> >> >> On Thu, 19 Jan 2006, sandhya wrote: >> >>> Hi, >>> >>> I am facing the following problem, >>> C:\Program Files\PostgreSQL\8.0\bin>pg_ctl reload -D C:\Program > Files\PostgreSQL\8.0\data >> >>> >>> pg_ctl: too many command-line arguments (first is > "Files\PostgreSQL\8.0\data") >>> Try "pg_ctl --help" for more information. >>> >>> Please explain me what i need to do... >>> >>> -Sandhya >> >> -- >> Jeff Frost, Owner >> Frost Consulting, LLC http://www.frostconsultingllc.com/ >> Phone: 650-780-7908 FAX: 650-649-1954 >> > > > > -- Jeff Frost, Owner Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 From sandhyar@amiindia.co.in Thu Jan 19 07:04:22 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A483C9DCA3E for ; Thu, 19 Jan 2006 03:04:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 46274-10 for ; Thu, 19 Jan 2006 03:04:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 67D069DCA2C for ; Thu, 19 Jan 2006 03:04:17 -0400 (AST) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k0J6x9s1019758; Thu, 19 Jan 2006 12:29:09 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 07A47332669; Thu, 19 Jan 2006 12:29:09 +0530 (IST) Message-ID: <00cf01c61cc7$0d763c80$cd00000a@sandhyar> From: "sandhya" To: "Jeff Frost" Cc: References: <005501c61cba$0baf7220$cd00000a@sandhyar> <00b501c61cc5$8e178940$cd00000a@sandhyar> Subject: Re: reg:pg_ctl Date: Thu, 19 Jan 2006 12:37:47 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:21 M:2 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.069 required=5 tests=[AWL=0.068, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.069 X-Spam-Level: X-Archive-Number: 200601/209 X-Sequence-Number: 20297 ok.. I will try. Thank you ----- Original Message ----- From: "Jeff Frost" To: "sandhya" Cc: Sent: Thursday, January 19, 2006 12:30 PM Subject: Re: [ADMIN] reg:pg_ctl > Please do not resend questions to me directly that you have already sent to > the list. > > I do not work in VC++ but I would first check that the postgres user (or > whatever user the postmaster is running as) has access to the files. > > On Thu, 19 Jan 2006, sandhya wrote: > > > Hi Thank you Jeff, > > But the same i am using in Application VC++.Here also it is considering the > > space after Program.... in Program Files. > > What needs to be modified in that case .Please help me in solving this. > > I am using 'lo_import' in windows application and trying to import the > > files to the database. > > > > If the path i am giving like: > > C:\\Program Files\\sample.htm > > > > It is not considering and i am getting the error as: > > Could not open server file "C:\\Program Files\\sample.htm" > > If i give : > > C:\\sample.htm > > > > It is importing properly and storing it in the specified table also. > > > > Why it is not doing in the previous case. > > But the same i did throug command line and worked file.Through application > > it is not doing..... > > Please help me.I need it very urgently. > > ----- Original Message ----- > > From: "Jeff Frost" > > To: "sandhya" > > Cc: "Postgres" > > Sent: Thursday, January 19, 2006 11:09 AM > > Subject: Re: [ADMIN] reg:pg_ctl > > > > > >> You have to put quotes around the paths. Ex: > >> > >> pg_ctl reload -D "C:\Program Files\PostgreSQL\8.0\data" > >> > >> > >> On Thu, 19 Jan 2006, sandhya wrote: > >> > >>> Hi, > >>> > >>> I am facing the following problem, > >>> C:\Program Files\PostgreSQL\8.0\bin>pg_ctl reload -D C:\Program > > Files\PostgreSQL\8.0\data > >> > >>> > >>> pg_ctl: too many command-line arguments (first is > > "Files\PostgreSQL\8.0\data") > >>> Try "pg_ctl --help" for more information. > >>> > >>> Please explain me what i need to do... > >>> > >>> -Sandhya > >> > >> -- > >> Jeff Frost, Owner > >> Frost Consulting, LLC http://www.frostconsultingllc.com/ > >> Phone: 650-780-7908 FAX: 650-649-1954 > >> > > > > > > > > > > -- > Jeff Frost, Owner > Frost Consulting, LLC http://www.frostconsultingllc.com/ > Phone: 650-780-7908 FAX: 650-649-1954 >