Re: [GENERAL] postgres startup failure

2010-05-21 Thread Tom Lane
Matt Bartolome writes: > On Thu, May 20, 2010 at 3:36 PM, Tom Lane wrote: >> So right now I'm wondering whether you're not failing to notice >> a relevant log message(s). You've evidently managed to launch >> the syslogger --- where is it configured to write the postmaster >> log? > Gosh, you k

Re: [GENERAL] postgres startup failure

2010-05-20 Thread Matt Bartolome
On Thu, May 20, 2010 at 3:36 PM, Tom Lane wrote: > Matt Bartolome writes: > > Setting the breakpoint (b exit) got me a little farther... > > > DEBUG: invoking IpcMemoryCreate(size=32595968) > > DEBUG: max_safe_fds = 980, usable_fds = 1000, already_open = 10 > > Detaching after fork from child

Re: [GENERAL] postgres startup failure

2010-05-20 Thread Tom Lane
Matt Bartolome writes: > Setting the breakpoint (b exit) got me a little farther... > DEBUG: invoking IpcMemoryCreate(size=32595968) > DEBUG: max_safe_fds = 980, usable_fds = 1000, already_open = 10 > Detaching after fork from child process 19066. > Detaching after fork from child process 19067

Re: [GENERAL] postgres startup failure

2010-05-20 Thread Matt Bartolome
On Thu, May 20, 2010 at 2:44 PM, Tom Lane wrote: > Matt Bartolome writes: > > gdb output... > > > DEBUG: - > > DEBUG: invoking IpcMemoryCreate(size=32595968) > > DEBUG: max_safe_fds = 980, usable_fds = 1000, already_open = 10 > > Detaching after fork fr

Re: [GENERAL] postgres startup failure

2010-05-20 Thread Tom Lane
Matt Bartolome writes: > gdb output... > DEBUG: - > DEBUG: invoking IpcMemoryCreate(size=32595968) > DEBUG: max_safe_fds = 980, usable_fds = 1000, already_open = 10 > Detaching after fork from child process 18310. > Detaching after fork from child proces

Re: [GENERAL] postgres startup failure

2010-05-20 Thread Matt Bartolome
Hi Tom, On Thu, May 20, 2010 at 11:33 AM, Tom Lane wrote: > Matt Bartolome writes: > > I'm attempting to start postgres on a standby machine from a backup. Both > > the primary and standby are running postgres 8.4, fedora 12. > > 8.4.what exactly? > I'm running 8.4.2 on the primary and 8.4.4 o

Re: [GENERAL] postgres startup failure

2010-05-20 Thread Tom Lane
Matt Bartolome writes: > I'm attempting to start postgres on a standby machine from a backup. Both > the primary and standby are running postgres 8.4, fedora 12. 8.4.what exactly? > DEBUG: invoking IpcMemoryCreate(size=32595968) > DEBUG: max_safe_fds = 984, usable_fds = 1000, already_open = 6

[GENERAL] postgres startup failure

2010-05-20 Thread Matt Bartolome
Hi, I'm attempting to start postgres on a standby machine from a backup. Both the primary and standby are running postgres 8.4, fedora 12. The backup on the primary is done nightly using the following commands: # psql -d operations -U postgres -c "SELECT pg_start_backup('/data/postgres')"; # tar

Re: [GENERAL] Postgres startup processes on linux?

2009-03-30 Thread Steve Crawford
Eshelman, James wrote: We’re running PG 8.1 on CentOS 5.0. When postgres starts the following processes apparently required by the DB itself get created: postgres 23784 1 0 13:55 ? 00:00:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data postgres 23786 23784 0 13:55 ? 00:00:00 postgres:

Re: [GENERAL] Postgres startup processes on linux? - resolved.

2009-03-30 Thread Eshelman, James
NERAL] Postgres startup processes on linux? We're running PG 8.1 on CentOS 5.0. When postgres starts the following processes apparently required by the DB itself get created: postgres 23784 1 0 13:55 ?00:00:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data postgres 23786 2

[GENERAL] Postgres startup processes on linux?

2009-03-30 Thread Eshelman, James
We're running PG 8.1 on CentOS 5.0. When postgres starts the following processes apparently required by the DB itself get created: postgres 23784 1 0 13:55 ?00:00:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data postgres 23786 23784 0 13:55 ?00:00:00 postgres: logger

Re: [GENERAL] postgres startup method for ubuntu

2008-01-31 Thread Daniel Verite
T.J. Adami wrote: > The source comes with a startup script that can be installed by > running: > # cp contrib/start-scripts/linux /etc/init.d/postgresql > # update-rc.d postgresql defaults > (update-rc.d is to debian-based systems what chkconfig is to > Redhat-based systems). > > -- > D

Re: [GENERAL] postgres startup method for ubuntu

2008-01-31 Thread T.J. Adami
On 31 jan, 12:24, [EMAIL PROTECTED] ("Daniel Verite") wrote: > T.J. Adami wrote: > > > I am also searching for a more 'professional' way to startup and > > shutdown postgresql on ubuntu and debian systems. > > The source comes with a startup script that can be installed by > running: > # cp

Re: [GENERAL] postgres startup method for ubuntu

2008-01-31 Thread Daniel Verite
T.J. Adami wrote: I am also searching for a more 'professional' way to startup and shutdown postgresql on ubuntu and debian systems. The source comes with a startup script that can be installed by running: # cp contrib/start-scripts/linux /etc/init.d/postgresql # update-rc.d postgres

Re: [GENERAL] postgres startup method for ubuntu

2008-01-31 Thread Karsten Hilbert
On Thu, Jan 31, 2008 at 02:35:01AM -0800, T.J. Adami wrote: > Everytime I deploy a PostgreSQL server in a ubuntu or debian based > server, I create some scripts called pg_start, pg_stop and pg_reload, > save them on default postgresql home dir. Then I create symbolic links > on /usr/bin, and so on

Re: [GENERAL] postgres startup method for ubuntu

2008-01-31 Thread T.J. Adami
On 30 jan, 04:14, Jon Hancock <[EMAIL PROTECTED]> wrote: > I have compiled postgres 8.3rc2 on ubuntu 7.04 and seem to a have > working install. > To start postgres, I do the following: > > > su postgres > > /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data & > > ok, that works for dev mode. B

[GENERAL] postgres startup

2001-02-13 Thread mike
what would be the best way to start up postgres? I used to use a modified version of the init script provided in the rpms, but since I've begun to use the 7.1 betas it doesn't always seem to want to start up. Is there an easier way or does 7.1 require a difernt type of init script?   Mike