I am having problems getting Postgres working at all. Can you give me some help in getting it installed? I am trying to figure it out using the files in /usr/doc/packages/postgres/, but haven't had much luck getting things working. Thanks, Aaron zentara wrote:

Ola Andersson wrote:

...

Hi

How do I start postgreSQL.

I read the docs but I couldent even log in to the postgres account (usink the KDE login app) and start the demon.

I don't know about the KDE interface. First, you must start the postgres demon. In YAST , under the "edit configuration file", there is a line to START POSTGRES, set it to yes. Then you must login to the postgres database "jolly", which is a default database. It is in the postgres postscript docs. For some reason, postgres won't start unless it has a default database to begin with. Once you have gotten "jolly", you can issuse a "createdb" of your database and forget about jolly. You then can logon to your db.

Example: pgsql jolly

that will get you going, then

createdb mydb;

Then you can start postgres with pgsql mydb

then create your tables, etc. - To get out of this list, please send email to majordomo@suse.com with this text in its body: unsubscribe suse-linux-e

-- _________________________________________________ <A HREF="mailto:verdesoft@verdesoft.net">mailto:verdesoft@verdesoft.net</A> VerdeSoft Internet Services <A HREF="http://www.verdesoft.net/"><A HREF="http://www.verdesoft.net/</A">http://www.verdesoft.net/</A</A>> - To get out of this list, please send email to majordomo@suse.com with this text in its body: unsubscribe suse-linux-e Check out the SuSE-FAQ at <A HREF="http://www.suse.com/Support/Doku/FAQ/"><A HREF="http://www.suse.com/Support/Doku/FAQ/</A">http://www.suse.com/Support/Doku/FAQ/</A</A>> and the archiv at <A HREF="http://www.suse.com/Mailinglists/suse-linux-e/index.html"><A HREF="http://www.suse.com/Mailinglists/suse-linux-e/index.html</A">http://www.suse.com/Mailinglists/suse-linux-e/index.html</A</A>>