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
> > another mailing list for it? The mail
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 .
drwxr
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 postgresql functions. I am
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 bytes?
It holds a DSM control head
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.
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
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 th
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 ar
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
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
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 the question but it you
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 RDS:
http://www.postgr
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 the hex version of the c
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 failed
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 o
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 o
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, pgsql-general@postgresql.org
Envoyé: W
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
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 parameter is for the whol
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
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 AM, Data Cruncher 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).
Thanks
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é: Wed, 17 Feb 2016 18:51:42
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 unique.
Is there a special reas
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 /var/
Hi
We are facing issue with PostgreSQL JDBC behaviour
in Java, under autocommit false mode,
1.in between if any transaction
26 matches
Mail list logo
