PostgreSQL Administration

Author

reg:pg_ctl

sandhya

2006-01-19, 3:24 am

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

2006-01-19, 3:24 am

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 < jeff@frostconsulting
llc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Jeff Frost

2006-01-19, 3:24 am

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" < jeff@frostconsulting
llc.com>
> To: "sandhya" <sandhyar@amiindia.co.in>
> Cc: "Postgres" <pgsql-admin@postgresql.org>
> Sent: Thursday, January 19, 2006 11:09 AM
> Subject: Re: [ADMIN] reg:pg_ctl
>
>
> Files\PostgreSQL\8.0\data
> "Files\PostgreSQL\8.0\data")
>
>
>
>

--
Jeff Frost, Owner < jeff@frostconsulting
llc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

sandhya

2006-01-19, 3:24 am

ok.. I will try.
Thank you
----- Original Message -----
From: "Jeff Frost" < jeff@frostconsulting
llc.com>
To: "sandhya" <sandhyar@amiindia.co.in>
Cc: <pgsql-admin@postgresql.org>
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:
>
the[color=darkred]
application[color=da
rkred]
>
> --
> Jeff Frost, Owner < jeff@frostconsulting
llc.com>
> Frost Consulting, LLC http://www.frostconsultingllc.com/
> Phone: 650-780-7908 FAX: 650-649-1954
>

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links