Re: Question about password character in ECPG's connection string
Hello Yusuke, Il giorno mar, 27/08/2019 alle 07.29 +, Egashira, Yusuke ha scritto: [...] > I referred the below documents. > - CONNECT of ecpg: > https://www.postgresql.org/docs/9.5/ecpg-sql-connect.html > - Connection string of libpq: > https://www.postgresql.org/docs/9.5/libpq-connect.html#LIBPQ-CONNSTRING [...] It seems to me that ECPG documentation does not allow specifying username and/or password in the connection string. The correct syntax should be: EXEC SQL CONNECT TO "unix:postgresql://localhost/connectdb" USER "myuser" IDENTIFIED BY "pass&word" Bye, Giuseppe
Re: Strange connection limit problem
Hi Frank, Il giorno ven, 07/06/2019 alle 13.58 +0200, Ict Security ha scritto: > Dear guys, > > i have two identical Postgresql 9.6.1 and i need, to test an > application, to reach connection above 1024. > > I setup 2400 as max_connections > I raised file-max kernel limit to 65535 > I increased shared_buffers > I also increased the value in semaphores in both > And i added this in limits.conf: > * - nofile 99 [...] Is postgresql ran via systemd? If this is the case, limits.conf is ignored and you should put the limits in the systemd unit file. Bye, Giuseppe
