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 bui
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 questions.
>
> I would like to use di
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 th
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? Obviously, it does on commit
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 own
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: pgsql-general@postgresql.
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" comman
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
http:/
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 Dabatabase
Hello Everydody,
My database is corrupted,
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
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
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 w
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 optio
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 th
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 l
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
192.168.1.40:543
På mandag 27. juni 2016 kl. 13:20:03, skrev Oleg Bartunov mailto:obartu...@gmail.com>>:
On Fri, Jun 24, 2016 at 2:36 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: Hi.
@PostgresPro; Will there be any updates to the rum git-repo any time soon?
Sure.
I understand you're work
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 RUM will support the sa
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 to
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: [GENERAL] dblink authent
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 ./.pgpass
This '#' seems to indi
> 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 connection
> DETAIL: fe_senda
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 /v
23 matches
Mail list logo