Forums PostgreSQL.fr

Installed PostgreSQL 10 on RHEL 6 system by running the following commands:

rpm -Uvh --force --nodeps postgresql10-libs-10.0-1PGDG.rhel6.x86_64.rpm
rpm -Uvh --force --nodeps postgresql10-10.0-1PGDG.rhel6.x86_64.rpm
rpm -Uvh --force --nodeps postgresql10-server-10.0-1PGDG.rhel6.x86_64.rpm
rpm -Uvh --force --nodeps postgresql10-contrib-10.0-1PGDG.rhel6.x86_64.rpm

The tried to run initdb:

./initdb --locale=C --encoding=UTF-8 -D /opt/postgresql -U postgres

Getting the following error:

/usr/pgsql-10/bin/postgres: error while loading shared libraries: libicui18n.so.42: cannot open shared object file: No such file or directory
no data was returned by command ""/usr/pgsql-10/bin/postgres" -V"
The program "postgres" is needed by initdb but was not found in the
same directory as "/usr/pgsql-10/bin/initdb".
Check your installation.

Can someone please help resolve the problem here?

Thanks

I am trying to uninstall PostgreSQL 9.3 from a Windows 2012 server using the uninstall-postgresql.exe . During the uninstall, I get an error:

The uninstall-postgresql.dat file cannot be found and is required to uninstall the application, aborting. Uninstallation did not complete successfully

The uninstall-postgresql.dat exists. Not sure if its corrupt or something.

Is there anyway to get rid of this error message and still use the uninstall-postgresql.exe to uninstall the DB from the Windows system?

Thanks

Hi again,

I have a Stored Proc in PostgreSQL which now has more than 100 args. When I try to create this STP, I get an error "ERROR: functions cannot have more than 100 arguments".

I see that there is a Preset Option called "max_function_args" whose value is set to 100 by default.

Can someone tell me how to change the value of this "max_function_args" parameter (if possible) so that I can create the stored proc OR any other way to do the same?

Thanks.

Greetings,

I understand that this is a french blog but I this is the only place where I get answers so posting my question here:

I just started using PostgreSQL 9.5 and facing some problem with starting the DB service on RHEL6. I get the following error while trying to start the PostgreSQL service:

could not create lock file "/var/run/postgresql/.s.PGSQL.5432.lock": Permission denied

I am not allowed to change any permissions under /var folder, so I wanted the lock file to be created under the /tmp directory instead. So I changed my Dbstart script and in postgresql.conf file, I changed:

#unix_socket_directories = '/var/run/postgresql, /tmp'

to

unix_socket_directories = '/tmp'

after initdb. Now the PostgreSQL service starts without any error however when i try to connect to the DB and create a DB or run any query, it gives me an error: psql:
could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

I thought I already changed the unix_socket_directories to /tmp but it is still trying to create a lock file under /var/run/postgres .
Can someone please suggest how to create the socket and the PG locks under /tmp dir and not /var/run ?

Thanks.