PSQL 9.3.1 Installtion on Debian failed

Classic Servoy
1

Hi,
I have installed “postgresql-9.3.1-1-linux-x64.run” on Debian 7 64 bit, but I get the Warning:

Problem running post-install step. Installation may not complete 
correctly
The database cluster initialisation failed.

Ok thought, try vers. 9.2.5, but always the same!?
[attachment=0]psql_install.png[/attachment]
Does anybody has a solution?

Regards
Thomas

psql_install.png
psql_install.png691×855 73.1 KB

2

How did you run this process?
The cluster initialization always wants to be executed under the Postgres user.
Under which user did you run this installer ? Did you sudo the installer process?

In any case, if you failed the init process you can do it yourself by using:
sudo - su postgres /opt/PostgreSQL/9.2/bin/initdb --username=yourUserName -W --encoding=UTF8 -D /opt/PostgreSQL/9.2/data/

See initdb --help for all options

Hope this helps.

3

Hi Robert,

thank you for your help!

And, yes I did the installer process as sudoer, because the “postgres” user will be created during the install process not before.
I will try again.

Regards
Thomas

4

Hi Robert,
this is not working:

ROCLASI:
sudo - su postgres /opt/PostgreSQL/9.2/bin/initdb --username=yourUserName -W --encoding=UTF8 -D /opt/PostgreSQL/9.2/data/

I have set the PostgreSQL username as “yourUserName”. Is it right?

That is the output:

/opt/PostgreSQL/9.3/bin/postgres: error while loading shared libraries: libsasl2.so.2: cannot open shared object file: No such file or directory
no data was returned by command ""/opt/PostgreSQL/9.3/bin/postgres" -V"
The program "postgres" is needed by initdb but was not found in the
same directory as "/opt/PostgreSQL/9.3/bin/initdb".
Check your installation.
5

Hi Thomas,

tgs:
this is not working:

ROCLASI:
sudo - su postgres /opt/PostgreSQL/9.2/bin/initdb --username=yourUserName -W --encoding=UTF8 -D /opt/PostgreSQL/9.2/data/

I have set the PostgreSQL username as “yourUserName”. Is it right?]

No, that was actually a placeholder for your real username. Usually it’s postgres although Servoy uses dba as superuser in the bundled version. But you can pick your own when you create the cluster.

tgs:
That is the output:

/opt/PostgreSQL/9.3/bin/postgres: error while loading shared libraries: libsasl2.so.2: cannot open shared object file: No such file or directory

no data was returned by command “”/opt/PostgreSQL/9.3/bin/postgres" -V"
The program “postgres” is needed by initdb but was not found in the
same directory as “/opt/PostgreSQL/9.3/bin/initdb”.
Check your installation.

Looks like not all dependencies are installed.
I guess for Debian you better use the debian packages. See http://www.postgresql.org/download/linux/debian/. Or install the required dependencies yourself.

Hope this helps.

6

Hello Robert,
your hint for better using the psql debian packages was the goal!
I could successful install and run the psql v. 9.3 on the Debian 7 Server.

Thank you once more
Thomas

7

Hi Thomas,

Glad I could help :)
Also please check out the latest update(s) of PostgreSQL. They fix some nasty issues.