PSQL 9.3.1 Installtion on Debian failed

[tgs]

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

Code: Select all

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!?

psql_install.png (121.09 KiB) Viewed 5377 times

Does anybody has a solution?

Regards
Thomas

[ROCLASI]

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.

[tgs]

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

[tgs]

Hi Robert,
this is not working:

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:

Code: Select all

/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.

[ROCLASI]

Hi Thomas,

this is not working:

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.

That is the output:

Code: Select all

/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.

[tgs]

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

[ROCLASI]

Hi Thomas,

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