What could be the possible impacts of leap second on June 30 2105 (which will
make the one second longer time) at PostgreSQL database ?
Regards
-- Forwarded message -
From: amihay gonen
Date: Tue, 24 Feb 2015 09:07
Subject: Re: [GENERAL] : Getting error while starting the server
To: Raghavendra
Check postgresql conf file where the socket file is created.
On Tue, 24 Feb 2015 08:42 Raghavendra
wrote:
> return Datab
> return Database.connect(**conn_params)
> File "/usr/local/lib/python3.4/dist-packages/psycopg2/__init__.py", line
> 164, in connect
> conn = _connect(dsn, connection_factory=connection_factory,
> async=async)
> django.db.utils.OperationalError: could not translate host name
> "localhost
Hi
2015-02-19 21:42 GMT+01:00 Juan Pablo L. :
> Hello, i have created a function (in C) that receives an array that
> contains tuples of ID's and values.
>
> The function is to execute updates on each ID assigning the value, but if
> one of these operation fails (does not meet certain criteria)
>
Hello, i have created a function (in C) that receives an array that contains
tuples of ID's and values.
The function is to execute updates on each ID assigning the value, but if one
of these operation fails (does not meet certain criteria)
inside the function i would like to rollback and leave
I tried dumping the largest table that is having problem using –j1 flag in
parallel dump. This time I got error on the console “File size limit exceeded”
but the system allows
Unlimited file size. Also the pg_dump without –j flag goes through fine. Do you
guys know what’s going on with parallel
* David G. Johnston (david.g.johns...@gmail.com) wrote:
> On Mon, Feb 23, 2015 at 6:01 PM, Stephen Frost wrote:
>
> > * David G Johnston (david.g.johns...@gmail.com) wrote:
> > > My quick take-away from RLS compared to traditional multi-tenant security
> > > policies is that with RLS you move the
On Mon, Feb 23, 2015 at 6:01 PM, Stephen Frost wrote:
> * David G Johnston (david.g.johns...@gmail.com) wrote:
> > My quick take-away from RLS compared to traditional multi-tenant security
> > policies is that with RLS you move the security logic into the database
> and
> > leverage the native da
* David G Johnston (david.g.johns...@gmail.com) wrote:
> My quick take-away from RLS compared to traditional multi-tenant security
> policies is that with RLS you move the security logic into the database and
> leverage the native database roles. Your model likely makes use of a single
> user asso
Darin Gordon wrote
> I'm trying to understand the extent that row level security in postgresql
> 9.5 may replace, or augment, application-level access control.
>
> I have a fully implemented application-level access control policy. It's
> not clear to me how I will integrate or replace it with RL
Darin,
* Darin Gordon (dar...@gmail.com) wrote:
> I'm trying to understand the extent that row level security in postgresql
> 9.5 may replace, or augment, application-level access control.
Neat!
> I have a fully implemented application-level access control policy. It's
> not clear to me how I w
On 23 February 2015 at 16:31, Tom Lane wrote:
> Dave Cramer writes:
> > Everytime you get a connection the driver will issue set timezone ...
> > It does not change the default time zone for the server (AFAICS)
>
> Hmm ... depending on exactly how you issue it, it might become the default
> for
Dave Cramer writes:
> Everytime you get a connection the driver will issue set timezone ...
> It does not change the default time zone for the server (AFAICS)
Hmm ... depending on exactly how you issue it, it might become the default
for the session, I think. I seem to recall that parameter sett
Thanks,
I'm going to try this solution and report back also to the bug tracker
I opened time ago:
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=196053
Luca
On Sat, Jan 24, 2015 at 8:53 AM, Keith Fiske wrote:
> Just wanted to thank Lacey for the assistance. I set up my first BSD server
> rece
George,
Everytime you get a connection the driver will issue set timezone ...
It does not change the default time zone for the server (AFAICS)
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 15:29, Adrian Klaver
wrote:
> On 02/23/2015 12:15 PM, George
On 02/23/2015 12:15 PM, George Woodring wrote:
This is what I was looking for, however the JDBC does something to make
its timezone the default.
My cluster is set to GMT, I have a DB that is set to US/Pacific, when I
get the connection from JDBC it is US/Eastern. The reset command does
not aff
This is what I was looking for, however the JDBC does something to make its
timezone the default.
My cluster is set to GMT, I have a DB that is set to US/Pacific, when I
get the connection from JDBC it is US/Eastern. The reset command does not
affect it. I can set timezone in the code to 'US/Pa
On 02/23/2015 10:08 AM, Guillaume Drolet wrote:
Hello,
I moved all my tables and indexes from one tablespace to pg_default using
ALTER TABLE ... SET TABLESPACE pg_default;
ALTER INDEX ... SET TABLESPACE pg_default;
Some 2500 files were moved to pg_default but 461 files remain in the
tablespace
On 02/23/2015 10:08 AM, Guillaume Drolet wrote:
Hello,
I moved all my tables and indexes from one tablespace to pg_default using
ALTER TABLE ... SET TABLESPACE pg_default;
ALTER INDEX ... SET TABLESPACE pg_default;
Some 2500 files were moved to pg_default but 461 files remain in the
tablespace
On 02/23/2015 10:08 AM, Guillaume Drolet wrote:
Hello,
I moved all my tables and indexes from one tablespace to pg_default using
ALTER TABLE ... SET TABLESPACE pg_default;
ALTER INDEX ... SET TABLESPACE pg_default;
Some 2500 files were moved to pg_default but 461 files remain in the
tablespace
Hello,
I moved all my tables and indexes from one tablespace to pg_default using
ALTER TABLE ... SET TABLESPACE pg_default;
ALTER INDEX ... SET TABLESPACE pg_default;
Some 2500 files were moved to pg_default but 461 files remain in the
tablespace and so I cannot drop it.
When I query, for examp
For posterity please be aware this will very likely break any timestamps
transfer using JDBC and binary transfer.
This is not recommended for general consumption
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 10:49, Tom Lane wrote:
> George Woodring
Adrian Klaver wrote:
> On 02/23/2015 08:32 AM, Igor Stassiy wrote:
> >unsubscribe
>
> Follow link below to unsubscribe:
>
> http://www.postgresql.org/mailpref/pgsql-general
I already unsubscribed him.
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Sup
On 02/23/2015 08:32 AM, Igor Stassiy wrote:
unsubscribe
Follow link below to unsubscribe:
http://www.postgresql.org/mailpref/pgsql-general
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
h
I'm trying to understand the extent that row level security in postgresql
9.5 may replace, or augment, application-level access control.
I have a fully implemented application-level access control policy. It's
not clear to me how I will integrate or replace it with RLS.
Craig Ringer mentioned in
unsubscribe
I did setup the keepalive option for ssh but still the pg_dump fails on the
table of size 48GB. It was able to dump table of size 34Gb(dump file size 2Gb)
but fails on table of size
48Gb(partial dump file size 3.9Gb). Is there any limit on the size of the dump
file in parallel load?
Thanks
sha
On 02/23/2015 01:14 AM, VENKTESH GUTTEDAR wrote:
i am facing this issue after inatalling php and mysql on my system.
is it because of that.?
Should not be. I have Postgres and MySQL installed on a 14.04 machine
with no issues.
The caveat is, how did you install Postgres initially and PHP/My
On 02/23/2015 01:04 AM, VENKTESH GUTTEDAR wrote:
CCing list.
Hello,
I have ubuntu 14.04, and i am trying it on my local machine.
when i tried "psql", i am getting the following error :
- psql: could not connect to server: No such file or directory
Is the server running
George Woodring writes:
> Yes, that is where we think we are heading, the issue is that the code does
> not know what it needs to be set back to. We have 90 databases with 5
> different time zones. I was just hoping for a more elegant solution than
> writing a lookup table that says if you are c
On Sat, Feb 21, 2015 at 4:58 PM, Eric Hanson wrote:
> Hi,
>
> I'm trying to use a composite type in a WHERE clause, as described here:
>
> http://www.postgresql.org/docs/9.4/static/rowtypes.html
>
> Just pasting in the examples I get:
>
> CREATE TYPE complex AS (
> r double precision,
>
Timestamps have always been a bit of a pain since JDBC does not support
both with and without timezones. It really only supports timestamps with
timezone.
We have made decisions in the driver which are not optimal for everyone.
The reason it does this is for binary transfers of data. We need to co
Yes, that is where we think we are heading, the issue is that the code does
not know what it needs to be set back to. We have 90 databases with 5
different time zones. I was just hoping for a more elegant solution than
writing a lookup table that says if you are connecting to db x then set to
tim
Well you could always just put it back to whatever you want when you open
the connection ie "set timezone "
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 08:40, George Woodring
wrote:
> Anyone have a suggestion for setting the timezone back to
Anyone have a suggestion for setting the timezone back to the Postgres db
default on a connection. JDBC now sets the timezone to be the client which
is my web server and ignores the default timezone that I have set in the
DB. There are large parts of my code that I have never worried about
timezo
Hello,
Has anybody used online backup feature of postgreSQL? In fact precise
postgreSQL term is called: "Point-in-time Recovery" (PITR)
This means enabling following additional options in config:
---
archive_command = on
archive_command = 'cp %p /usr/local/pgsql/pgDataPITR/wals/%f' # This is only
Il giorno dom, 22/02/2015 alle 14.53 -0500, Tom Lane ha scritto:
[...]
> That's because the above claim is nonsense. pg_largeobject is not shared
> across databases of a cluster.
>
> You could well have collisions against large objects in the same database,
> though, if you're adding more large o
On 02/22/2015 11:02 PM, VENKTESH GUTTEDAR wrote:
Hello,
i have Postgresql 9.3.5 installed and django 1.7 and till now it
was working fine.
But now i am getting the following error while starting the server
to run my app :
Unhandled exception in thread started by .wrapper at 0xb2da80
38 matches
Mail list logo
