pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shane Ambler <pgsql@Sheeky.Biz>
To: Christoph Heibl <christoph.heibl@gmx.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: deinstallation - reinstallation on Mac OS 10.4
Date: Tue, 31 Jul 2007 18:49:30 +0930
Message-ID: <46AEFEA2.7030500@Sheeky.Biz> (raw)
In-Reply-To: <DB30B605-F1CB-4B4C-9063-9940E989FFA7@gmx.net>
References: <34182537-265F-4A46-BDEA-9876AF401A99@gmx.net>
	<bd6a35510707201940q33f8be6et9b48a0e96343beb8@mail.gmail.com>
	<194E8AE5-C0E4-40A7-95BD-1365B048FEB7@gmx.net>
	<46A62D5A.4030907@productivitymedia.com>
	<DB30B605-F1CB-4B4C-9063-9940E989FFA7@gmx.net>

Christoph Heibl wrote:
> 
>> run this in the command line
>>
>> locate postmaster.pid
>> or
>> find / -name "postmaster.pid" -print
>>
>> that should locate any postmaster files and then remove whatever looks 
>> like the postmaster.pif file
> 
> Thank you! I found postmaster.pid in usr/local/pgsql/data. I deleted the 
> whole pgsql directory and installed postgres again using the following 
> commands:
> 
>     ./configure
>     make
>     sudo make install
>     sudo mkdir /usr/local/pgsql/data
>     sudo chown postgres /usr/local/pgsql/data
>     su postgres
>     /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
> 
> When I then try to start the PosrgreSQL-server via
> 
>     /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
> 
> the terminal gets "stuck" (i.e. no prompt appears ) after six lines of 
> output:
> 
> LOG:  database system was shut down at 2007-07-25 09:38:00 CEST
> LOG:  checkpoint record is at 0/42C258
> LOG:  redo record is at 0/42C258; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction ID: 0/593; next OID: 10820
> LOG:  next MultiXactId: 1; next MultiXactOffset: 0
> LOG:  database system is ready
> 
> There is no explicit error message. What can be wrong?
> What directory do I have to cd to in order to execute 
> "/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data"?
> Did I omit an important step?
> 
> Thanks for your ideas!
> Christoph
> 

The last line there is what you are interested in - it's ready.
You may be mislead by the first line - that comes from initdb which 
basically starts the server to setup the system catalogs etc. then stops it.

In the Terminal when you give a command you don't get your cursor back 
until the command has finished running.
As you want the server to continue running you can add & after the 
command which will allow the command to run in the background.
(that would include a space and then the & after the last character in 
the command)

If you have a startupitems folder to start postgresql on startup then 
you can also use that to start/stop postgresql manually with -
sudo /Library/StartupItems/PostgreSQL/PostgreSQL start


-- 

Shane Ambler
pgSQL@Sheeky.Biz

Get Sheeky @ http://Sheeky.Biz



view thread (9+ messages)

Message-ID: <46AEFEA2.7030500@Sheeky.Biz>
Permalink:  ../46AEFEA2.7030500@Sheeky.Biz/
Also on:    postgresql.org/message-id/46AEFEA2.7030500@Sheeky.Biz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: pgsql@Sheeky.Biz, christoph.heibl@gmx.net
  Subject: Re: deinstallation - reinstallation on Mac OS 10.4
  In-Reply-To: <46AEFEA2.7030500@Sheeky.Biz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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