[SGVLUG] PostgreSQL setup on Fedora 9

[Arthur Baldwin]

Ok,

After installing F9 with the GUI version installer, I used "System", "Admininstration", "Add/Remove Software" to install postgresql-server and postgresql version 8.3.1.  I then went to "System", "Administration", "Services" and enabled and started the service labelled "postgresqld".  After "starting", I noticed that the "status" remained "unknown".  In F8 and the previous versions of PostGreSQL this was working before.

So then, I figured that postgres programmers probably wanted to make things more "secure" and that I would have to do some typical "setup" by hand.  The first instructions that I found in an article said to use "/sbin/chkconfig postgresql on" after logging in as user "postgres".  This I did and it gave me four "file exists" errors, which I expected to happen since the services GUI program had already done the same thing.

Then it said to use "/sbin/service postgresql start" while logged in as user postgres and when I did, it said "please initialize the database with "service postgresql initdb"".  So I did that and I saw some stuff "fly by" on the command line and then the script crashed with a final line of "g database".

The same thing happened on two different machines on which I installed F9 and pg 8.3.1, so I don't think this is hardware related or F9 installation related.

I wish that there was some GUI tool I could install that would allow me to setup pg without any headaches.

Arthur


----- Original Message ----
From: Christopher Smith <x at xman.org>
To: SGVLUG Discussion List. <sgvlug at sgvlug.net>
Sent: Thursday, May 15, 2008 6:05:58 PM
Subject: Re: [SGVLUG] PostgreSQL setup on Fedora 9

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

Arthur Baldwin wrote:
> Can anyone point me to a good link for "how to" setup PostgreSQL on
> Fedora 9?  I have tried following the directions for previous versions
> of Fedora and PG to no avail.

There's nothing special about the Fedora 9 config of PostgreSQL AFAIK.
The generic PostgreSQL docs should help. If you could describe the
symptoms and how you got there, perhaps I can help.

- --Chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFILN32OagjPOywMBARAhGvAKDaMK2mIMg+4bCUgIIgSITq1ou6rACgqTeO
Hz5Lu9b0MAw7un9cNlnqRvk=
=MB4J
-----END PGP SIGNATURE-----



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.sgvlug.net/pipermail/sgvlug/attachments/20080516/efdbb7be/attachment.html