[FGS] postgresql server install

[Bart van den Eijnden]

Hi list,

I am trying to install the fgs package for postgresql 8.0.3, but am running into an issue (initdb will not succeed), probably because I am running as root. Can anybody advise me what's the proper way to do this (create a user postgres and install the package using that user??).

[root at gis bin]# ./fgs install postgresql-server:8.0.3 ~root/install/modules/
+ Installing postgresql-server:
  + Getting and extracting module 'postgresql-server'... ok
+ Copying all files into FGS environment... ok
+ Running postgresql-server's installation script :
*      *** PostgreSQL installation ***
+ Correct files in share/ directory
* Selecting TCP port... Example: 5433, 5433, etc...
? What TCP port do you want to use [5432] : 5432
+ Creating PostgreSQL's database directory in '/opt/fgs/apps/pgsql/data' :
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UNICODE.

fixing permissions on existing directory /opt/fgs/apps/pgsql/data ... ok
creating directory /opt/fgs/apps/pgsql/data/global ... ok
creating directory /opt/fgs/apps/pgsql/data/pg_xlog ... ok
creating directory /opt/fgs/apps/pgsql/data/pg_xlog/archive_status ... ok
creating directory /opt/fgs/apps/pgsql/data/pg_clog ... ok
creating directory /opt/fgs/apps/pgsql/data/pg_subtrans ... ok
creating directory /opt/fgs/apps/pgsql/data/base ... ok
creating directory /opt/fgs/apps/pgsql/data/base/1 ... ok
creating directory /opt/fgs/apps/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 50
creating configuration files ... ok
creating template1 database in /opt/fgs/apps/pgsql/data/base/1 ... "root" execution of the PostgreSQL server is not permitted.
The server must be started under an unprivileged user ID to prevent
possible system security compromise.  See the documentation for
more information on how to properly start the server.
child process exited with exit code 1
initdb: removing contents of data directory "/opt/fgs/apps/pgsql/data"
* To start PostgreSQL, use : fgs start pgsql
* PostgreSQL's database directory created.
+ Port selected : '5432'. Configuration wrote in /opt/fgs/etc/fgs/pkgs/postgresql-server/pgsql.conf
* You can start PostgrSQL with : fgs start pgsql
*      *** End of PostgreSQL installation ***
* Module 'postgresql-server' installed with success.

Thanks in advance.

Best regards,
Bart

Bart van den Eijnden
Syncera IT Solutions
Postbus 270
2600 AG  DELFT

tel.nr.: 015-7512436
email: BEN at Syncera-ITSolutions.nl