Re: [GENERAL] 9.6 beta2 win-x64 download links still point to beta1

On Fri, Jun 24, 2016 at 07:44:17AM +0200, Thomas Kellerer wrote: > Hello, > > the Beta2 downloads on > > http://www.enterprisedb.com/products-services-training/pgdownload > http://www.enterprisedb.com/products-services-training/pgbindownload > > still lead to Beta1 for the Windows 64bit

Re: [GENERAL] questions about how to implement a gist index

On Tue, Jun 28, 2016 at 12:44 AM, Riccardo Vianello wrote: > Hi all, > > I'm trying to contribute some improvements to the implementation of a gist > index that is part of an open source project and it would be really nice if > anyone could help me answer some

[GENERAL] questions about how to implement a gist index

Hi all, I'm trying to contribute some improvements to the implementation of a gist index that is part of an open source project and it would be really nice if anyone could help me answer some questions. I would like to use different data structures to represent the internal and leaf entries. I

Re: [GENERAL] Transaction serialization

Thank you Thomas, this was exactly what I was looking for. On 24.6.2016 0:57, Thomas Munro wrote: On Fri, Jun 24, 2016 at 4:13 AM, Dusan Milanov wrote: Hi, A question about transactions: does postgres report serialization errors before a transaction is committed?

[GENERAL] Different query plans using different roles

I have a situation where the same query generates two different plans depending on which user executes it. Two of the tables do have row-level security enabled, the policy is roughly POLICY "policy_qai_U0002_7900_0" FOR SELECT TO qai_U0002 USING (true) Here is the plan when the

[GENERAL] Válasz: [GENERAL] dblink authentication failed

Yes, I missed that. Thank you, it solved the problem. And I had to edit the /etc/hosts file too, to make it sure to find the right host.  Eredeti üzenet Feladó: Adrian Klaver Dátum:2016.06.27. 15:28 (GMT+01:00) Címzett: Attila Kiss Másolatot kap:

Re: [GENERAL] Corrupted Dabatabase

hello again to cancel the execution of the \di i used cntl+c, the output for the cat /proc/mounts returns /dev/mapper/ddf1_4c534920202020201055471147111e78p1 /home ext3 rw,data=ordered 0 0 i when i say i was indexing a table, i mean that i was executing a "create index"

Re: [GENERAL] Corrupted Dabatabase

On 06/27/2016 07:23 AM, Pau Marc Muñoz Torres wrote: Please reply to list also. Ccing list i did a cancel + c i suppose this is the problem I routinely do that with no problems. Also elaborate on what you mean by 'indexing the database'? p Pau Marc Muñoz Torres skype: pau_marc

Re: [GENERAL] Corrupted Dabatabase

You probably have a HDD problem. Try a "cat /proc/mounts" and see if partition is mounted read only. -- Original Message -- From: "Pau Marc Muñoz Torres" To: "pgsql general" Sent: 27/6/2016 4:28:35 PM Subject: [GENERAL] Corrupted

Re: [GENERAL] Corrupted Dabatabase

On 06/27/2016 06:52 AM, Pau Marc Muñoz Torres wrote: hi thank you for your quick answer, I am working with linux. here you have the output of uname --all Linux XXX at 2.6.18-274.3.1.el5 #1 SMP Tue Sep 6 20:13:52 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux And the filesystem is ext3 i was

Re: [GENERAL] Corrupted Dabatabase

On 2016-06-27 08:52, Pau Marc Muñoz Torres wrote: > hi > > thank you for your quick answer, > > I am working with linux. here you have the output of uname --all > > Linux XXX at 2.6.18-274.3.1.el5 #1 SMP Tue Sep 6 20:13:52 EDT 2011 x86_64 > x86_64 x86_64 GNU/Linux > > And the filesystem

Re: [GENERAL] Corrupted Dabatabase

hi thank you for your quick answer, I am working with linux. here you have the output of uname --all Linux XXX at 2.6.18-274.3.1.el5 #1 SMP Tue Sep 6 20:13:52 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux And the filesystem is ext3 i was able to work with the database until last week when i

Re: [GENERAL] Corrupted Dabatabase

On 27.06.2016 16:28, Pau Marc Muñoz Torres wrote: Hello Everydody, My database is corrupted, each time i try to list all the tables in the database i have got the following message hla2db=> \d ERROR: could not open relation 1663/16385/1255: Read-only file system I read that my best

Re: [GENERAL] Corrupted Dabatabase

The issue sounds more like your server than just Postgres - search the net for "read only file system" for your OS. Tim Clarke On 27/06/16 14:28, Pau Marc Muñoz Torres wrote: > Hello Everydody, > > My database is corrupted, each time i try to list all the tables in > the database i have got

[GENERAL] Corrupted Dabatabase

Hello Everydody, My database is corrupted, each time i try to list all the tables in the database i have got the following message hla2db=> \d ERROR: could not open relation 1663/16385/1255: Read-only file system I read that my best option is to use my backup. Before using my backup i would

Re: [GENERAL] dblink authentication failed

On 06/27/2016 03:58 AM, Attila Kiss wrote: I've got some additional info about the problem. After several times trying to connect to the remote database, I tried to connect to the local database with dblink. I edit the .pgpass file like this: 127.0.0.1:5432:*:postgres:password

Re: [GENERAL] Updated RUM?

På mandag 27. juni 2016 kl. 13:20:03, skrev Oleg Bartunov >:     On Fri, Jun 24, 2016 at 2:36 PM, Andreas Joseph Krogh > wrote: Hi.   @PostgresPro; Will there be any updates to the rum git-repo any

Re: [GENERAL] Updated RUM?

On Fri, Jun 24, 2016 at 2:36 PM, Andreas Joseph Krogh wrote: > Hi. > > @PostgresPro; Will there be any updates to the rum git-repo any time soon? > Sure. > > I understand you're working hard on this, care to share some > vision/roadmap? I'm specifically interested in if

Re: [GENERAL] dblink authentication failed

I've got some additional info about the problem. After several times trying to connect to the remote database, I tried to connect to the local database with dblink. I edit the .pgpass file like this: 127.0.0.1:5432:*:postgres:password 192.168.1.40:5432:*:myusername:mypassword   Then I tried

Re: [GENERAL] dblink authentication failed

I just wrote '#' to show it is command line, but actually I ran the psql as user postgres, just like the SQL server process is running. So if it was deceptive, I am sorry.        -eredeti Üzenet- Feladó:Francisco Olarte Elküldött:Hétfő 2016.06.27 11:23 Tárgy:Re:

Re: [GENERAL] dblink authentication failed

Hello: On Mon, Jun 27, 2016 at 9:38 AM, Kiss Attila wrote: I'm not expert on dblink but, even supposing it uses libpq and its files: > # psql –h 192.168.1.40 –U myuser –w remote_db_name ... > # ls –la ./.pgpass > -rw--- 1 postgres postgres 193 jún 24 13:54

Re: [GENERAL] dblink authentication failed

> On Jun 27, 2016, at 03:38, Kiss Attila wrote: > > Hello, > I have some problem with using dblink_connect_u() in my function. > When I provide the password in the connection string, there is no problem, > but when I don’t, it says: > ERROR: could not establish

[GENERAL] dblink authentication failed

Hello, I have some problem with using dblink_connect_u() in my function. When I provide the password in the connection string, there is no problem, but when I don't, it says: ERROR: could not establish connection DETAIL: fe_sendauth: no password supplied However the .pgpass file in the path