pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedstart
4+ messages / 4 participants
[nested] [flat]
* start
@ 2004-05-03 19:36 H.J. Sanders <hjs@worldonline.nl>
0 siblings, 3 replies; 4+ messages in thread
From: H.J. Sanders @ 2004-05-03 19:36 UTC (permalink / raw)
To: pgsql-sql
Hello list.
I have difficulties starting the postmaster automatically at boot time
(everything I tried is done by 'root').
Can someone give me an example for LINUX (SUSE 8).
Many thanks.
Henk Sanders
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: start
@ 2004-05-03 19:56 Peter Eisentraut <peter_e@gmx.net>
parent: H.J. Sanders <hjs@worldonline.nl>
2 siblings, 0 replies; 4+ messages in thread
From: Peter Eisentraut @ 2004-05-03 19:56 UTC (permalink / raw)
To: H.J. Sanders <hjs@worldonline.nl>; pgsql-sql
H.J. Sanders wrote:
> I have difficulties starting the postmaster automatically at boot
> time (everything I tried is done by 'root').
>
> Can someone give me an example for LINUX (SUSE 8).
Maybe you would rather want to download the binary packages, which take
care of that. RPMs for SuSE are available on the PostgreSQL mirrors in
the directory "binary".
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: start
@ 2004-05-03 20:16 scott.marlowe <scott.marlowe@ihs.com>
parent: H.J. Sanders <hjs@worldonline.nl>
2 siblings, 0 replies; 4+ messages in thread
From: scott.marlowe @ 2004-05-03 20:16 UTC (permalink / raw)
To: H.J. Sanders <hjs@worldonline.nl>; +Cc: pgsql-sql
On Mon, 3 May 2004, H.J. Sanders wrote:
>
> Hello list.
>
>
> I have difficulties starting the postmaster automatically at boot time
> (everything I tried is done by 'root').
>
> Can someone give me an example for LINUX (SUSE 8).
Just FYI, this probably belongs on admin, but no biggie.
I start my postgresql database with this line:
su - postgres -c 'pg_ctl start | rotatelogs $PGDATA/pglog 86400 2>1&'
If you have apache rotatelogs in the postgres user's path, you can start
the database as postgresql AND set the logs to be rotated every 24 hours
with this line. If not, and you don't need to log the database's
notices and such, then just enter this:
su - postgres -c 'pg_ctl start 2>1&'
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: start
@ 2004-05-04 14:20 Andrei Bintintan <klodoma@ar-sd.net>
parent: H.J. Sanders <hjs@worldonline.nl>
2 siblings, 0 replies; 4+ messages in thread
From: Andrei Bintintan @ 2004-05-04 14:20 UTC (permalink / raw)
To: pgsql-sql
You say that you're running Suse 8.
You can also start the process with that Yast.
Start Yast2 -> System -> Runlevel Editor-> and then you can select the
runlevel when you want that postgre starts. I start it at runlevel 3.
If you installed postgre it manually you have a little work to do, probably
you will have to make your own start script.
In my situation(also manual installation) I just copied the script which
came with suse and edited it for my configuration... it worked for me.
Good luck!
----- Original Message -----
From: "H.J. Sanders" <hjs@worldonline.nl>
To: <pgsql-sql@postgresql.org>
Sent: Monday, May 03, 2004 10:36 PM
Subject: [SQL] start
>
> Hello list.
>
>
> I have difficulties starting the postmaster automatically at boot time
> (everything I tried is done by 'root').
>
> Can someone give me an example for LINUX (SUSE 8).
>
> Many thanks.
>
>
> Henk Sanders
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-05-04 14:20 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-03 19:36 start H.J. Sanders <hjs@worldonline.nl>
2004-05-03 19:56 ` Peter Eisentraut <peter_e@gmx.net>
2004-05-03 20:16 ` scott.marlowe <scott.marlowe@ihs.com>
2004-05-04 14:20 ` Andrei Bintintan <klodoma@ar-sd.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox