Message-ID: <3A3BD21D.268C4B96@northwestern.edu>
Date: Sat, 16 Dec 2000 14:35:41 -0600
From: "Mac Q. Flores IV"
Subject: PostgreSQL installation
I had trouble installing PostgreSQL on a SuSE 7.0 i386 box . . . SuSE's
support page states that they split the package to "faciliate" updates.
The support page instruction is to install the pg_data rpm. However,
there is no such rpm anymore in 7.0 (unless I did not look hard
enough). I tried installing the pg_data package from 6.4 (of course it
would not work, dummy) and of course it does not work.
To make it work, this is what I did:
1. Reinstall Postgres packages (11 rpms . . . what the heck);
2. As root, invoke "passwd postgres" to assign password to account;
3. Login as "postgres";
4. Invoke "initdb -D /var/lib/pgsql" . This I believe is the most
important part . . .
5. After the databases are created and initialized, create your users;
6. "createuser joeblow" and answer the y/n questions . . .
7. Login as joeblow and invoke "psql template1". This should take you
to the template1 database prompt . . .
8. SQL away . . . . !
--
+----------------------+
/ Mac Q. Flores IV /
/ Linux-pmac-2.2.17 /
+----------------------+