[GENERAL] tzdata timezone boundaries

Hello, Is there a way to have access to the tzdata boundaries from within postgres ? the zdump linux command gives something like -- zdump -v /usr/share/zoneinfo/America/Los_Angeles | grep 2017 Sun Mar 12 09:59:59 2017 UTC = Sun Mar 12 01:59:59 2017 PST isdst=0 gmtoff=-28800 Sun Mar 12

Re: [GENERAL] tzdata version

Thank you for your answer. When compiled with "--with-system-tzdata", does postgres need a restart after the system is updated with the new tzdata ? regards, jérôme wagner On Fri, Jul 28, 2017 at 4:06 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Jerome Wagner <jerome.wag.

[GENERAL] tzdata version

Hello, As i understand it, the tzdata on which the timezone information is based is updated regularly (semi-manually) in https://github.com/postgres/postgres/tree/master/src/timezone Am i correct in stating that there is currently no way to update the tzdata database except by recompiling

[GENERAL] tzdata version

Hello, As i understand it, the tzdata on which the timezone information is based is updated regularly (semi-manually) in https://github.com/ postgres/postgres/tree/master/src/timezone Am i correct in stating that there is currently no way to update the tzdata database except by recompiling

Re: [GENERAL] Storing files: 2.3TBytes, 17M file count

2 other options that you may want to look at : - cephfs This has nothing to do with postgres but is a distributed filesystem handling very large amount of files (thinks next generation NFS) I haven't tried it myself yet but they reached a "stable" milestone regarding the distributed fs. cf

Re: [GENERAL] Converting a TimestampTz into a C# DateTime

Hello, seeing you answer I have a question for which I found no answer a few weeks ago : is there a way to know at runtime which internal representation timestamps have ? I am trying to deal with the COPY binary protocol with only SQL access to the remote server and would like to find a way to

Re: [GENERAL] Multi tenancy : schema vs databases

you could also use a hybrid approach : - have a systematic tenant_id field in your tables, allowing for 1 db / 1 schema multi-tenants - give your application the ability to set the schema path for a tenant, so it will locate the tenant schema if it has a decidated schema - maybe go to the

[GENERAL] question on error during COPY FROM

Hello, in the documentation I read https://www.postgresql.org/docs/current/static/sql-copy.html COPY stops operation at the first error. This should not lead to problems in the event of a COPY TO, but the target table will already have received earlier rows in a COPY FROM. These rows will not

[GENERAL] question on parsing postgres sql queries

Hello, I am doing some research on postgres sql query parsing. I have found the https://github.com/lfittl/libpg_query project which manages to re-use the native postgres server parser. For using this, you need to accept an external dependency on a lib compiled out of the postgres source. I was

Re: [GENERAL] question on parsing postgres sql queries

uld lead to warnings or help uncover unexpected corner cases not mentioned in the documentation. Thanks for your answers Jerome On Tue, Jul 26, 2016 at 9:52 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, Jul 26, 2016 at 3:20 PM, Jerome Wagner <jerome.wag...@lapos

[GENERAL] question on parsing postgres sql queries

Hello, I am doing some research on postgres sql query parsing. I have found the https://github.com/lfittl/libpg_query project which manages to re-use the native postgres server parser. For using this, you need to accept an external dependency on a lib compiled out of the postgres source. I was

Re: [GENERAL] pg_largeobject

I am not saying that this will solve your problem (I never tried id even though I keep it in my radar), but this project seems to implement something close to what Daniel is describing: https://github.com/andreasbaumann/pgfuse + it gives you a FUSE wrapper so the client can use fs calls. the

Re: [GENERAL] Let's Do the CoC Right

Hello, I do not intervene much on the list and am not an english native speaker, but here are some thoughts : It seems to me that it is very hard to find good words (which should find their way in other languages) to summarize what is a decent conduct in an open source project. Don't we all (or

[GENERAL] FDW wrapper for clustered app management

Hello, I am considering (postgres 9.3+) the idea of opening a R/W access into a clustered application by creating one fdw server from a central database to each server a cluster. That would imply opening a port on each server inside the application, listening for incoming connections from the

Re: [GENERAL] FDW wrapper for clustered app management

On Fri, Oct 17, 2014 at 11:57 AM, John R Pierce pie...@hogranch.com wrote: On 10/17/2014 2:35 AM, Jerome Wagner wrote: Hello, I am considering (postgres 9.3+) the idea of opening a R/W access into a clustered application by creating one fdw server from a central database to each server a cluster

Re: [GENERAL] FDW wrapper for clustered app management

as general control mechanism for the cluster : the cluster and the data would be on the same SQL data plane :-) Thanks, Jerome On Fri, Oct 17, 2014 at 12:00 PM, Albe Laurenz laurenz.a...@wien.gv.at wrote: Jerome Wagner wrote: I am considering (postgres 9.3+) the idea of opening a R/W access