[GENERAL] JDBC behaviour

Hi We are facing issue with PostgreSQL JDBC behaviour in Java, under autocommit false mode, 1.in between if any transaction

Re: [GENERAL] Pgsql troubleshooting & Iscsi

On Wed, Feb 17, 2016 at 06:07:29PM +0100, p...@free.fr wrote: > Hi everybody, > > I installed a postgresql database on Redhat 7.1 and I decided to move the > database on an ISCSI device (LUN) inside a logical volume, mounted at > starting of the machine (xfs formatted). The mounting point is

Re: [GENERAL] BRIN Usage

On 18/02/2016 9:34 am, "Tom Smith" wrote: > > Hi: > > I feel it is a stupid question. > > Can BRIN index enforce uniqueness? > My issue is > the column I'd like to apply BRIN index also needs to be unique > (think of timestamp as primary key). Only btree supports

[GENERAL] Pgsql troubleshooting & Iscsi

I already mount with the netdev option. The network service is started before postgresql but not lvm for. I tried to start lvm service as dependency but no changes. - Mail d'origine - De: Jeroen van Iddekinge À: p...@free.fr, pgsql-general@postgresql.org Envoyé:

[GENERAL] BRIN Usage

Hi: I feel it is a stupid question. Can BRIN index enforce uniqueness? My issue is the column I'd like to apply BRIN index also needs to be unique (think of timestamp as primary key). Thanks

Re: [GENERAL] Multiple databases and shared_buffers

I think this begs the question "Why do you think you need to separate the shared_buffers"? What version of PostgreSQL are you using? What is your O/S? How many CPU's on your server? How much memory? On Wed, Feb 17, 2016 at 5:21 PM, John R Pierce wrote: > On 2/17/2016 6:54

Re: [GENERAL] Multiple databases and shared_buffers

On 2/17/2016 6:54 AM, Data Cruncher wrote: We will be creating multiple databases in a cluster (instance). Is there any way to separate shared_buffers for each database? Looks like not since PG does not allow user created shared buffers. you would need to run multiple instances if you feel

Re: [GENERAL] Multiple databases and shared_buffers

On Thu, Feb 18, 2016 at 1:54 AM, Data Cruncher wrote: > We will be creating multiple databases in a cluster (instance). Is there > any way to separate shared_buffers for each database? Looks like not since > PG does not allow user created shared buffers. shared_buffers

Re: Re : Re: [GENERAL] Pgsql troubleshooting & Iscsi

On 02/17/2016 10:30 AM, p...@free.fr wrote: I already try to change the dependencies with postgresql.service (adding as a prerequesite lvm scan, iscsi) . The mounting began before postgresql but the mount was successfull after the failure. Exactly, the drive was not mounted when the Postgres

Re : Re: [GENERAL] Pgsql troubleshooting & Iscsi

I already try to change the dependencies with postgresql.service (adding as a prerequesite lvm scan, iscsi) . The mounting began before postgresql but the mount was successfull after the failure. - Mail d'origine - De: Adrian Klaver À: p...@free.fr,

Re: [GENERAL] Pgsql troubleshooting & Iscsi

On 02/17/2016 06:07 PM, p...@free.fr wrote: Hi everybody, I installed a postgresql database on Redhat 7.1 and I decided to move the database on an ISCSI device (LUN) inside a logical volume, mounted at starting of the machine (xfs formatted). The mounting point is /var/lib/pgsql At the boot

Re: [GENERAL] Pgsql troubleshooting & Iscsi

On 02/17/2016 09:07 AM, p...@free.fr wrote: Hi everybody, I installed a postgresql database on Redhat 7.1 and I decided to move the database on an ISCSI device (LUN) inside a logical volume, mounted at starting of the machine (xfs formatted). The mounting point is /var/lib/pgsql At the boot

[GENERAL] Pgsql troubleshooting & Iscsi

Hi everybody, I installed a postgresql database on Redhat 7.1 and I decided to move the database on an ISCSI device (LUN) inside a logical volume, mounted at starting of the machine (xfs formatted). The mounting point is /var/lib/pgsql At the boot of the server, postgresql.service is in

Re: [GENERAL] Replaying xlogs from beginning

otheus uibk writes: > I came up with an answer to the _second_ question (how do I do this from a > new instance?). > In the new instance directory: > 1. Hack the system ID in the global/pg_control file to that of the original > instance. >1a. Use pg_controlinfo to get

Re: [GENERAL] Log Monitoring with PG Admin

On Wed, Feb 17, 2016 at 9:05 AM, Alex Magnum wrote: > Hi, > i am running and RDS instance on AWS but monitoring logs is a bit > cumbersome. > Is there a way to do the through pgadmin3 ? Like tailing the logfile? > ​Only if you are capable of doing something like this on

Re: [GENERAL] Replaying xlogs from beginning

On Wed, Feb 17, 2016 at 9:16 AM, otheus uibk wrote: > I came up with an answer to the _second_ question (how do I do this from a > new instance?). > ​[...] > Again, this worked for me. What I want to be sure of is: does this really > work? > ​I cannot definitively answer

Re: [GENERAL] Replaying xlogs from beginning

I came up with an answer to the _second_ question (how do I do this from a new instance?). In the new instance directory: 1. Hack the system ID in the global/pg_control file to that of the original instance. 1a. Use pg_controlinfo to get the hex version of the control id: $ pg_controldata

[GENERAL] Log Monitoring with PG Admin

Hi, i am running and RDS instance on AWS but monitoring logs is a bit cumbersome. Is there a way to do the through pgadmin3 ? Like tailing the logfile? Does anyone know when 9.5 will be available on aws? Thanks Alex

[GENERAL] Appending key-value to JSONB tree

I have a "user" document with a key "tokens" and I would like to write a stored procedure for adding new token key-value pairs to the "tokens" part of the tree without removing the old values. I have figured out how to replace the existing value in the "tokens", but I cannot seem to wrap my head

[GENERAL] Replaying xlogs from beginning

I'm looking for answers to this question, but so far haven't turned up a usable answer. Perhaps I'm asking it the wrong way. I want to replay the xlogs from the beginning of time up until a particular time. The problem is, the time is before the first base backup. But I have all the xlogs since

[GENERAL] Charlotte Postgres User Group

If you live near or around Charlotte, please join us for the inaugural meeting of the Charlotte PUG on March 1, followed by a second meeting on April 11 featuring Bruce Momjian. More information about the two events can be found here: http://www.meetup.com/Charlotte-PostgreSQL-User-Group Also if

[GENERAL] Multiple databases and shared_buffers

We will be creating multiple databases in a cluster (instance). Is there any way to separate shared_buffers for each database? Looks like not since PG does not allow user created shared buffers. thanks.

Re: [GENERAL] Question on memory management sysv/posix on Linux

Daniel Westermann writes: > ls -la /dev/shm > total 4 > drwxrwxrwt 2 root root 60 Feb 17 11:19 . > drwxr-xr-x 18 root root 3100 Feb 17 09:36 .. > -rw--- 1 postgres postgres 2316 Feb 17 11:19 PostgreSQL.1804289383 > Question: Why is this file only 2316

Re: [GENERAL] Custom conflict handlers

Can someone help with bdr conflict handlers? What is ch_proc ..? On 13-Feb-2016 8:11 pm, "Nikhil" wrote: > This is for system that use BDR (Bi-Directional Replication). BDR > documentation > http://bdr-project.org/docs/next/functions-conflict-handlers.html talks > about

[GENERAL] Question on memory management sysv/posix on Linux

Hi I have a question about memory management in PostgreSQL. I understand the default on Linux usually is "posix" which creates files in /dev/shm. With the default settings of 128MB for shared_buffers this is the result: ls -la /dev/shm total 4 drwxrwxrwt 2 root root 60 Feb 17 11:19 .

Re: [GENERAL] pgDay Asia / talks / lightning talks

It's pity I miss this conference, since I learned about it too late. On Wed, Feb 17, 2016 at 8:46 AM, Satoshi Nagayasu wrote: > Hi Dan, > > 2016-02-16 20:43 GMT+09:00 Daniel Pocock : > > Is this the place to ask questions about pgDay Asia[1] or is there > >