[GENERAL] Extending the KD Tree index in Postgresql 9.2.1

Hi there Postgressors, I have a 15-element/dimension vector (floats) data type. I also have about 10 million of these and given a query vector I would like to search these to find a number of nearest neighbours. For this I intend to extend the current implementation of kd tree in postgresql-9.2.

[GENERAL] Synchronous Commit, WAL archiving and statement_timeout

Hello, I noticed something strange and I would like to understand what's happening. I have the following environment: - 2 PostgreSQL instance running in hot-standby with synchronous commit activated. (further called Master & Slave) - The archiving of the WAL files is activated on the master runn

Re: [GENERAL] Synchronous Commit, WAL archiving and statement_timeout

Original Message Subject: Re: [GENERAL] Synchronous Commit, WAL archiving and statement_timeout Local Time: 3 février 2017 1:15 AM UTC Time: 3 février 2017 00:15 From: adrian.kla...@aklaver.com To: JP Jacoupy , pgsql-general@postgresql.org On 02/02/2017 09:15 AM, JP Jacoupy

[GENERAL] Service configuration file and password security

Hello, This might seem a pretty novice question but I can't find an answer. Can the password be stored in an encrypted way inside a service configuration file? -- Jacoupy Jean-Philippe Sent from [ProtonMail](https://protonmail.ch), encrypted email based in Switzerland.

Re: [GENERAL] Handling psql lost connections

Not a response to OP but this also occurs with libpq connections. The only thing I found at the moment is to lower the net.ipv4.tcp_retries2 value to 8 (instead of 15). This will lower the TCP timeout from kernel to around 100 seconds instead of 15 minutes. Sent from ProtonMail mobile ---

Re: [GENERAL] Unable to upload backups

Hi, Seems to me your role "ronb" doesn't have the rights to create schema on your database. Please refer to the GRANT command in the documentation. https://www.postgresql.org/docs/9.0/static/sql-grant.html Sent from [ProtonMail](https://protonmail.ch), encrypted email based in Switzerland. -

[GENERAL] auditing pg_hba.conf

table/view that stores pg_hba rules. I'm curious to know if anyone has any suggestions, or has solved a similar problem. Best Regards, JP -- JP Fletcher Database Administrator Afilias Canada voice: 416.646.3304 ext. 4123 fax: 416.646.3305 mobile: 416.561.4763 jpfle...@ca.afilias.info

[GENERAL] postgresql and LDAP

stmaster | grep ldap libldap_r-2.4.so.2 => /usr/lib/libldap_r-2.4.so.2 (0xb7fd5000) This is on ubuntu linux, and the only configure option besides prefix was '--with-ldap' -- JP Fletcher Database Administrator Afilias Canada voice: 416.646.3304 ext. 4123 fax: 416.64

Re: [GENERAL] postgresql and LDAP

FYI, I did see the message returned to my client, and did look in the server logs. Trouble was, the message in the log was no more helpful than the one returned to my client, with the exception of pointing me to the line number in pg_hba.conf. Gregory Stark wrote: Tom Lane writes: JP

[GENERAL] prepared statements and DBD::Pg

to a prepared statement my $prepare_sql =< INSERT INTO foo(1, 1); INSERT INTO foo(2, 2); SQL my $sth = $dbh->prepare($prepare_sql); Is this the expected behaviour? -- JP Fletcher Database Administrator Afilias Canada voice: 416.646.3304 ext. 4123 fax:

Re: [GENERAL] prepared statements and DBD::Pg

y with PG, an error in server-side prepare aborts the current transaction, so that any subsequent command will fail until a rollback is issued. Falling back to client-side prepare once in this state would probably not help much. Best regards, -- JP Fletcher Database Administrator Af

[GENERAL] ERROR: could not convert UTF8 character to ISO8859-1

t the character in the database? I am not sure how to search for a raw unicode character through psql or pgadmin... Thanks for any help! JP ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-n

Re: [GENERAL] ERROR: could not convert UTF8 character to ISO8859-1

back up failed about the time that I switched to the newer version. Is there a fix for this? Is this a bug? Is there a workaround? Thanks for any help. JP JP Glutting wrote: I have seen several people with this same error. I get mine when trying to backup using pg_dump, causing my backups to

Re: [GENERAL] ERROR: could not convert UTF8 character to ISO8859-1

think I am going to try to go back to 8.0. Is it a very bad idea to shut down Postgres and try to replace the data directory for 8.0 withe the data directory for 8.1? Any help or suggestions appreciated. JP JP Glutting wrote: To answer my own mail, I shut down the 8.1 database, and started u

Bug? was: Re: [GENERAL] ERROR: could not convert UTF8 character to ISO8859-1

? Is this a known bug? JP JP Glutting wrote: More information. I backed up a database (one that failed to backup in 8.1) from the old 8.0 system, and re-imported it into the 8.0 system without any problem. Then I imported it into the 8.1 system without errors, and tried to do a backup again. It

[GENERAL] Error backing up database (Unicode)

t;, "1999", "2000", "2001", "2002", codi_udl_centre, "2003", "2004", "2005") TO stdout; pg_dump: *** aborted because of error Process returned exit code 1. I have posted a copy of the backup file

Re: Bug? was: Re: [GENERAL] ERROR: could not convert UTF8 character

works now (not sure whay it was not working a month or so ago). Cheers, JP Tom Lane wrote: JP Glutting <[EMAIL PROTECTED]> writes: This is reproducible, and I think it is a bug, because I have the problem not only with data backed up from Postgres 8.0 and restored to Postgres 8.1, bu

Re: [GENERAL] unknown symbol 'lo_unlink'

"Unknown symbol lo_unlink". It might be helpful if you let me know the options you pass to the configure script, then I could try with those options. TIA -JP