configuring and automatically launching postgresql91-server

[Phil Dobbin]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 03/04/2012 03:36, Puneet Kishor wrote:
> I just reinstalled postgresql91-server, and am revisiting a
> question I asked a few months ago. I am looking for the correct way
> for configuring and launching postgresql automatically when
> computer starts.
> 
> Per an email thread from Dec 20, Bradley Giesbrecht advised that I
> should copy /opt/local/share/postgresql90/postgresql.conf.sample to
> /opt/local/etc/postgresql.conf and edit it to suit my needs. Well,
> turns out there is a copy of postgresql.conf under my postgresql
> data directory as well. I init-ed a db cluster at
> /Volumes/mydisk/Data/db/postgresql91/defaultdb, and a whole bunch
> of .conf files are under this defaultdb directory.
> 
> So, which .conf file am I supposed to use? The one under defaultdb
> is owned by 'postgres' user, so I can't really edit that.
> 
> Additionally, even though I have done `sudo port load
> postgresql91-server` (as well as `sudo port load apache2`), I get
> the message that the port file is already loaded, yet the program
> doesn't really start.
> 
> Suggestions?

I use a System Pref Pane from:

<http://www.hkwebentrepreneurs.com/2011/12/postgresql-mac-preferences.html>

Very straightforward & if any problems do arise the maintainer has a
page on GitHub where he is more than happy to answer any questions &
provide assistance:

<https://github.com/mckenfra/postgresql-mac-preferences>

Cheers,

  Phil...

- -- 
But masters, remember that I am an ass.
Though it be not written down,
yet forget not that I am an ass.

	Wm. Shakespeare - Much Ado About Nothing
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: §auto-key-locate cert pka ldap hkp://keys.gnupg.net
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJPesu8AAoJEKpMeDHWT5ADJC4H/3pQlu8MMqvQs+2lqM+8cQro
h+mQ/2gMG77NbKlcV3x4WLqEnHpCMqhIQy/LRqBMGxum9mZaLGuX6Xvf5KT6rjEc
+HKLUkL0I6/Vg2Fu7eceBuly2V96134LcBOTAE8aPwY9w5eyzq7z/C4M2e4wrrp/
6k/G+9ELYKSBZSRWjbj4kMRSDq5p/KLBm82OqX0Od66clpMstOHuSkLOBcquXvu1
c/Xn4NdPYAeyxiTAqmLyK88xIqKKar5l+IlCqHxzkkfbH6di2x4/MSbC98A4nQXp
Md9T0cCwSzRRWXfH8Upj60DuaTjm0iwHcN2b2efhlACiw3whDmZEvM7q06Mmuv4=
=kn50
-----END PGP SIGNATURE-----