Re: [ADMIN] Establishing remote connections is slow

check traceroute/trapath utilities with the same IP maybe it will show you something strange.. Lukas > On Tue, Jan 17, 2012 at 3:41 PM, Tom Lane wrote: > >> Hm.  AFAIR postgres doesn't know anything particular about multipath >> interfaces --- it just listens where you tell it

Re: [ADMIN] Establishing remote connections is slow

check traceroute/trapath utilities with the same IP maybe it will show you something strange.. -- Lukas UAB nSoft www.nsoft.lt > On Tue, Jan 17, 2012 at 7:23 PM, Tom Lane wrote: >> <..>  Mindaugas, are you using SSL, >> and if so can you turn it off and see whether things cha

[ADMIN] Connection limit per user

Hello, is here any way to set connection limit to database per database user? For ex. if I have postgresql database user XXX I want limit it to 2 connections per database (or per all databases).. -- Lukas UAB nSoft http://www.nsoft.lt Lukas at nsoft.lt +370 655 10 655 -- This message has

Re: [ADMIN] Database in use?

Hi, try this: SELECT * FROM pg_stat_activity; Maybe it will show you who is using it.. -- Lukas UAB nSoft http://www.nsoft.lt Lukas at nsoft.lt +370 655 10 655 > Periodically, my databases will give me a message that says that > someone is using the database when it appears that no

Re: [ADMIN] Postgesql and SSL

Hello again, nope, no use of it.. Situation stays the same.. Does any one have more ideas? -- Lukas UAB nSoft http://www.nsoft.lt Lukas at nsoft.lt +370 655 10 655 > You defo have all the required openssl headers and libs and configure > succeeds? It's a longshot, but I wonder if

[ADMIN] Postgesql and SSL

uild FATAL: invalid value for parameter "ssl": 1 DEBUG: proc_exit(1) DEBUG: shmem_exit(1) DEBUG: exit(1) Where is the problem? Is here versions which does not support SSL, it would be strange.. Versions used: PostgreSQL 8.3.4 OpenSSL 0.9.8j -- Lukas UAB nSoft http://www.nsoft.lt Lu

[ADMIN] 2 problems

"padaliniu_grupes_pkey" is not an index!! and I do not want to drop it... "padaliniu_grupes_pkey" is a PK on table "padaliniu_grupes": ALTER TABLE padaliniu_grupes ADD CONSTRAINT padaliniu_grupes_pkey PRIMARY KEY(pg_id); Can anyone help us? thx Lukas -- Thi

Re: [ADMIN] Pg_dump and bytaA

05, ο/η Milen A. >> Radev έγραψε: >>> Achilleas Mantzios wrote: >>>> Στις Παρασκευή 09 Μάρτιος 2007 11:00, ο/η Lukas >>>> έγραψε: >>>>> Hello, >>>>> >>>>> pg_dump can avoid bloob fields (it can dumb without blobs), but

Re: [ADMIN] Pg_dump and bytaA

Hello, pg_dump can avoid bloob fields (it can dumb without blobs), but as I understand byteA is not bloob, so in this case what is blob? I did not found such type as blob.. Lukas > Στις Πέμπτη 08 Μάρτιος 2007 22:02, ο/η Lukas > έγραψε: >> Hello, >> >> we have one t

[ADMIN] Pg_dump and bytaA

this field? I tried to look at keys of pgdump, but found nothing... Now we are using it like this: pg_dump -f /home/backup/DB.sql -d -Fp -v DB thx Lukas -- This message has been scanned for viruses and dangerous content, and is believed to be clean. ---(end of