PostgreSQL database setup
Posted: Tue Nov 29, 2005 1:57 pm
Dear All,
I like the installation process of s9y. This is the first time I manage to get a software installed in under 10 minutes.
Having said that, I was wondering whether the "Fresh Installation" instruction on http://www.s9y.org/36.html or the FAQ should be strengthen for newbies like me who have only basic idea about PostgreSQL admin.
The problem that I have is after the third step, I am presented with a nice Pre Installation screen of s9y. On the second screen where I am asked about the Database Settings. There is where I got stuck initially. Finally I figured that I have to manually set my PostgreSQL (Debian Linux) to create the user and database name using
createuser userid
createdb s9ydbname
before I fed userid/s9ydbname into the lovely "Preinstallation" screen.
While I understand that most users will probably need not do this step as there is a db admin that can do it for them, it might be useful having it in the FAQ or something like that.
Another reason for having an FAQ entry or the sort is that in "createdb s9ydbname" for example, there was an uncertainty on whether I should load a database template after this step because there are a lot of applications that requires the setup of the database. It is great that s9y takes care of that for me, but it would had been even better if I was told that it will. It save me some panicking.
HTH and thanks for a great software
Cinly
I like the installation process of s9y. This is the first time I manage to get a software installed in under 10 minutes.
Having said that, I was wondering whether the "Fresh Installation" instruction on http://www.s9y.org/36.html or the FAQ should be strengthen for newbies like me who have only basic idea about PostgreSQL admin.
The problem that I have is after the third step, I am presented with a nice Pre Installation screen of s9y. On the second screen where I am asked about the Database Settings. There is where I got stuck initially. Finally I figured that I have to manually set my PostgreSQL (Debian Linux) to create the user and database name using
createuser userid
createdb s9ydbname
before I fed userid/s9ydbname into the lovely "Preinstallation" screen.
While I understand that most users will probably need not do this step as there is a db admin that can do it for them, it might be useful having it in the FAQ or something like that.
Another reason for having an FAQ entry or the sort is that in "createdb s9ydbname" for example, there was an uncertainty on whether I should load a database template after this step because there are a lot of applications that requires the setup of the database. It is great that s9y takes care of that for me, but it would had been even better if I was told that it will. It save me some panicking.
HTH and thanks for a great software
Cinly