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

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

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

ok.. I will try.
Thank you
----- Original Message -----
From: "Jeff Frost" <jeff@frostconsultingllc.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:
>
> > 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@frostconsultingllc.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
> >
> >
> >> 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@frostconsultingllc.com>
> >> Frost Consulting, LLC http://www.frostconsultingllc.com/
> >> Phone: 650-780-7908 FAX: 650-649-1954
> >>
> >
> >
> >
> >
>
> --
> Jeff Frost, Owner <jeff@frostconsultingllc.com>
> Frost Consulting, LLC http://www.frostconsultingllc.com/
> Phone: 650-780-7908 FAX: 650-649-1954
>