[SGVLUG] PostgreSQL setup on Fedora 9

[Rae Yip]

Usually with problems like this, you want the first error that shows
up in the failure output, not the last.

If you could post the rest of the errors to `service postgresql
initdb`, this might help us figure out what issue you're running into.
If the problem is  at all common, a simple web search on the right
error string may find a solution posted.

While a GUI installer for Postgres would be a boon for new users, it
wouldn't necessarily be more helpful in debugging a failure mode like
you're experiencing.

Given a choice between a GUI and a command line script that both fail
to install, I'd choose the latter. Of course, it'd be nice if those
weren't the only choices.

-Rae.

On Fri, May 16, 2008 at 9:41 AM, Arthur Baldwin <eengnerd at yahoo.com> wrote:
> 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-----
>
>