From: | Joe Moraca <jmoraca(at)home(dot)com> |
---|---|
To: | Nabil Sayegh <nsmail(at)sayegh(dot)de> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: How do I start postmaster with -i for tcp-ip |
Date: | 2001-06-09 20:21:55 |
Message-ID: | 01060916215500.01475@cc1000196-a.srst1.fl.home.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thanks for the help but I still can't get it to work..
This is what is in my startup file:
su -l -s /bin/sh postgres -c "LC_ALL=C /usr/bin/pg_ctl -D $PGDATA -p/
usr/bin/postmaster start >/dev/null 2>&1" < /dev/null
I have tried to put -i or -i\ in serveral places mostly after $PGDATA and it
fails to load. w/out -i it works fine???
I just want to use JDBC and it says it needs to have the TCP/IP support.
Should I just give up and use MYSQL???
PS I have no clue what the password for the user postgres is?
I also tried to add -i to my postmaster.opts file but that seems to
overwritten on each startup??
Joe Moraca
On Wednesday 06 June 2001 09:48 am, Nabil Sayegh wrote:
> On 06 Jun 2001 09:32:21 -0400, Joe Moraca wrote:
> > I am using Mandrake 8.0 and have upgraded to postrgess 7.1 and need to
> > have the script that auto starts postgress use the -i so I can connect
> > with jdbc but it seems I am not able to find the correct spot to put the
> > -i as I never seem to get it to work....
>
> This should really be a FAQ:
>
> If you want to hardcode it into the rc script:
>
> su -l postgres -c "PGDATESTYLE=GERMAN LANG=de_DE LANGUAGE=
> LC_COLLATE=POSIX LC_CTYPE= LC_MESSAGES= LC_MONETARY= LC_NUMERIC=
> LC_TIME= /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o \"-D
> /usr/local/pgsql/data -i\" start >/dev/null 2>&1"
>
> Adjust paths etc. to your needs.
>
> P.S.: Don't forget the \ characters
>
> --
> Nabil Sayegh
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
From | Date | Subject | |
---|---|---|---|
Next Message | Williams, Travis L, NPONS | 2001-06-09 22:25:32 | How do I see all databases and tables?? |
Previous Message | Dmitry Andrianov | 2001-06-09 18:33:18 | Index |