On 2/23/2016 11:29 PM, David Grelaud wrote:
We would like to deploy a modified version of PostgreSQL on our servers.
It would be easier if we could build our own apt package for Ubuntu 14.04.
I work mostly on RPM based linux (but also Solaris, BSD, AIX), and
frankly, if I need to deploy my o
Hello,
We would like to deploy a modified version of PostgreSQL on our servers.
It would be easier if we could build our own apt package for Ubuntu 14.04.
We've found this project :
http://git.postgresql.org/gitweb/?p=pgapt.git;a=summary
Is it the right tool? How to use it (without jenkins if po
On 24/02/2016 09:20, John R Pierce wrote:
On 2/23/2016 10:57 PM, Achilleas Mantzios wrote:
Of course it is. You can install PostgreSQL via packages, via ports or manually. I prefer the manual way and have been doing so for many years. FreeBSD peculiarities will start to bite (maybe,
maybe not) o
On 2/23/2016 10:57 PM, Achilleas Mantzios wrote:
Of course it is. You can install PostgreSQL via packages, via ports or
manually. I prefer the manual way and have been doing so for many
years. FreeBSD peculiarities will start to bite (maybe, maybe not)
once you start entering territories like t
On 2/23/2016 11:17 PM, Achilleas Mantzios wrote:
Quite off-topic, but did you ever manage to run postgres on identical
jails, i.e. same user, same port? Was FreeBSD IPC ever jailified? Or
did the recent switch to mmap resolve this?
no, I haven't tried that, just have the one postgres instan
On 23/02/2016 23:02, John R Pierce wrote:
On 2/23/2016 12:45 PM, Larry Rosenman wrote:
The ports tree has postgresql:
...
I'm running 9.5.1 on both 11-CURRENT, and 10.x
and I might add, postgres behaves very nicely in a FreeBSD Jail.
Quite off-topic, but did you ever manage to run postgre
On 23/02/2016 11:47, MEERA wrote:
Hi all,
Any information regarding PostgreSQL support on FreeBSD platform?
Of course it is. You can install PostgreSQL via packages, via ports or manually. I prefer the manual way and have been doing so for many years. FreeBSD peculiarities will start to bite (
On 02/23/2016 05:49 PM, Magnus Hagander wrote:
It's Postgres Plus, not PostgreSQL plus.
And AFAIK, it was also retired some time ago and doesn't actually exist
anymore.
And, I just looked. You are correct.
Wow...
Sad.
JD
--
Command Prompt, Inc. http://the.postgres.company
On Tue, Feb 23, 2016 at 1:04 PM, Josh berkus wrote:
> On 02/23/2016 07:51 AM, Sherrie Kubis wrote:
>
>> Hello, my first post to the list, thank you for this place to ask
>> questions and get help.
>>
>> Our management has tasked me with devising a plan to migrate our
>> existing databases from Or
> I had no idea PowerGres was still going.
>
> You know I threw out an entire box of PowerGres 7.3 CDs when I moved?
PowerGres 7.3! So old days...
> They were in the back of a closet.
Probably I still have a GreatBridge CDs in my house :-)
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www
On 02/23/2016 04:52 PM, Tatsuo Ishii wrote:
PowerGres: Surviving since 2003. Full compatible with PostgreSQL
except "PowerGres plus" which has the transparent database encryption
and the redundant WAL.
I had no idea PowerGres was still going.
You know I threw out an entire box of PowerGres 7.3
> On 02/23/2016 07:51 AM, Sherrie Kubis wrote:
>> Hello, my first post to the list, thank you for this place to ask
>> questions and get help.
>>
>> Our management has tasked me with devising a plan to migrate our
>> existing databases from Oracle to PostgreSQL. I$B!G(Bm researching and
>> getti
On Tue, Feb 23, 2016 at 1:54 PM, Tom Lane wrote:
> Dan S writes:
>> I have this table, data and query:
>
>> create table test
>> (
>> id int,
>> txt text,
>> txt_arr text[],
>> f float
>> );
>
>> insert into test
>> values
>> (1,'jkl','{abc,def,fgh}',3.14159),(2,'hij','{abc,def,fg
Yes I meant equivalence in the roundtrip conversion sense.
And of course the "feature complete" solution which can handle deep
structures would be really nice to have.
Best Regards
Dan S
2016-02-23 21:11 GMT+01:00 David G. Johnston :
> On Tue, Feb 23, 2016 at 12:54 PM, Tom Lane wrote:
>
>> Dan
On 2/23/2016 12:45 PM, Larry Rosenman wrote:
The ports tree has postgresql:
...
I'm running 9.5.1 on both 11-CURRENT, and 10.x
and I might add, postgres behaves very nicely in a FreeBSD Jail.
I'm running pg 9.4.6 in a FreeNAS (FreeBSD 9.3) jail without any hassle,
and very good performance,
On 2016-02-23 14:40, Alvaro Herrera wrote:
MEERA wrote:
Hi all,
Any information regarding PostgreSQL support on FreeBSD platform?
You can see the list of supported platforms here:
http://buildfarm.postgresql.org/cgi-bin/show_status.pl
We seem to have FreeBSD 9.0 on gcc 4.2 and FreeBSD 10 on c
MEERA wrote:
> Hi all,
>
> Any information regarding PostgreSQL support on FreeBSD platform?
You can see the list of supported platforms here:
http://buildfarm.postgresql.org/cgi-bin/show_status.pl
We seem to have FreeBSD 9.0 on gcc 4.2 and FreeBSD 10 on clang, both on
x86_64. If you want to see
On 02/23/2016 01:47 AM, MEERA wrote:
Hi all,
Any information regarding PostgreSQL support on FreeBSD platform?
This:
http://www.postgresql.org/download/freebsd/
leads to:
http://www.freebsd.org/cgi/ports.cgi?query=postgresql&stype=name&sektion=databases
If the above does not help, is there
Hi all,
Any information regarding PostgreSQL support on FreeBSD platform?
On Wed, Feb 17, 2016 at 12:26 PM, preeti soni
wrote:
> Hi,
>
> There is no clear information available for FreeBSD supported versions.
>
> Would you please let em know if Postgres is supported on both FreeBSD x86
> and x8
Thanks Venkata, I am able to setup replication now. Just wondering when I check
replication_delay and lag, I am getting negative number, any idea why?
receive|replay| replication_delay | lag
--+--+---+-
796/BA9D8000 | 796/BA9D7FF0 | -00:00:0
On 02/23/2016 11:57 AM, Bala Venkat wrote:
Dear All -
We are seeing lot of these statements in the log file. We have 2
functions . Submit and update . Between submit and update which will
int the process, the messages are appearning. The process is very slow.
We don't know if this the
On 2/23/2016 11:57 AM, Bala Venkat wrote:
Dear All -
We are seeing lot of these statements in the log file. We have
2 functions . Submit and update . Between submit and update which
will int the process, the messages are appearning. The process is very
slow. We don't know if this the
On Tue, Feb 23, 2016 at 12:54 PM, Tom Lane wrote:
> Dan S writes:
> > I have this table, data and query:
>
> > create table test
> > (
> > id int,
> > txt text,
> > txt_arr text[],
> > f float
> > );
>
> > insert into test
> > values
> >
> (1,'jkl','{abc,def,fgh}',3.14159),(2,'hi
Dear All -
We are seeing lot of these statements in the log file. We have 2
functions . Submit and update . Between submit and update which will int
the process, the messages are appearning. The process is very slow. We
don't know if this the main reason for the performance issue
Can you
Dan S writes:
> I have this table, data and query:
> create table test
> (
> id int,
> txt text,
> txt_arr text[],
> f float
> );
> insert into test
> values
> (1,'jkl','{abc,def,fgh}',3.14159),(2,'hij','{abc,def,fgh}',3.14159),(2,null,null,null),(3,'def',null,0);
> select j, js
On Tue, Feb 23, 2016 at 12:12 PM, Dan S wrote:
> Hi !
>
> I'm running "PostgreSQL 9.5.1 on i686-pc-linux-gnu, compiled by
> gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 32-bit"
>
> I'm trying out json functions and stumbled on a problem with
> json_populate_record.
> To try out the function I decided to
Hi !
I'm running "PostgreSQL 9.5.1 on i686-pc-linux-gnu, compiled by
gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 32-bit"
I'm trying out json functions and stumbled on a problem with
json_populate_record.
To try out the function I decided to take records from table test convert
them to json and immediate
2016-02-23 19:26 GMT+01:00 Josh berkus :
> On 02/23/2016 10:22 AM, Pavel Stehule wrote:
>
>>
>> Vertica was written from scratch in C++. Maybe gram.y was used from Pg.
>> But the client and SQL are strongly inspirited by Postgres. vsql is not
>> psql probably, because psql is better. Last three ye
On 02/23/2016 10:22 AM, Pavel Stehule wrote:
Vertica was written from scratch in C++. Maybe gram.y was used from Pg.
But the client and SQL are strongly inspirited by Postgres. vsql is not
psql probably, because psql is better. Last three years is not Vertica
protocol compatible with Postgres. I
>
> Closed Source
> -
>
> PostgreSQL Plus Advanced Server/EDB Server: EnterpriseDB's fork of
> PostgreSQL which has Oracle compatibility and some other tools (like xDB
> replication). Sometimes includes features from future versions of
> PostgreSQL
>
> CitusDB: latest/greatest big data
On 02/23/2016 07:51 AM, Sherrie Kubis wrote:
Hello, my first post to the list, thank you for this place to ask
questions and get help.
Our management has tasked me with devising a plan to migrate our
existing databases from Oracle to PostgreSQL. I’m researching and
getting familiar with Postgre
On 02/23/2016 07:51 AM, Sherrie Kubis wrote:
Hello, my first post to the list, thank you for this place to ask
questions and get help.
Our management has tasked me with devising a plan to migrate our
existing databases from Oracle to PostgreSQL. I’m researching and
getting familiar with Postgre
On Tue, 23 Feb 2016, at 17:20, Adrian Klaver wrote:
> Where did you install Postgres from and what version of OpenSSL was it
> compiled against?
I now realise that I wasn't compiling PostgreSQL against my
self-compiled openssl. After adding --with-includes and --with-libraries
to configure I have
Hello, I want to use pglogical to setup cascade replication, however, by
researching it, I find different answer.
http://2ndquadrant.com/en/resources/pglogical/faqs/Q. Does pglogical support
cascaded replication?Subscribers can be configured as publishers as well thus
cascaded replication
On 02/23/2016 05:18 AM, Frazer McLean wrote:
Hi,
I am using PostgreSQL 9.4.6 and openssl 1.0.2f. If my server or client
certificate use SHA256, I get the following error on the client:
psql: SSL error: tlsv1 alert decrypt error
And the following log message on the server:
LOG: could no
Congratulations on the decision and welcome.
As an overview, there is the PostgreSQL *project* which is run by the
PostgreSQL Global Development Group (PgDG) with contributors around the
world most of whom work for a variety of companies that either use or
support PostgreSQL. PostgreSQL is BSD-lic
On Tue, Feb 23, 2016 at 11:06 AM, Adrian Klaver
wrote:
> On 02/23/2016 07:51 AM, Sherrie Kubis wrote:
>
>> Hello, my first post to the list, thank you for this place to ask
>> questions and get help.
>>
>
> Welcome.
>
>
>> Our management has tasked me with devising a plan to migrate our
>> existi
On 02/23/2016 07:51 AM, Sherrie Kubis wrote:
Hello, my first post to the list, thank you for this place to ask
questions and get help.
Welcome.
Our management has tasked me with devising a plan to migrate our
existing databases from Oracle to PostgreSQL. I’m researching and
getting familiar
Hello, my first post to the list, thank you for this place to ask questions and
get help.
Our management has tasked me with devising a plan to migrate our existing
databases from Oracle to PostgreSQL. I'm researching and getting familiar with
PostgreSQL before getting a Linux box to start lear
On Tue, Feb 23, 2016 at 4:44 PM, Andreas Kretschmer wrote:
>
>
> > Kaushal Shriyan hat am 23. Februar 2016 um
> 11:43
> > geschrieben:
> >
> >
> > Hi,
> >
> > Is there a option of selecting tables in BDR which is a Multi Master PG
> > Replication (http://2ndquadrant.com/en/resources/bdr/).
> >
>
Hi,
I am using PostgreSQL 9.4.6 and openssl 1.0.2f. If my server or client
certificate use SHA256, I get the following error on the client:
psql: SSL error: tlsv1 alert decrypt error
And the following log message on the server:
LOG: could not accept SSL connection: unknown message digest algor
> Kaushal Shriyan hat am 23. Februar 2016 um 11:43
> geschrieben:
>
>
> Hi,
>
> Is there a option of selecting tables in BDR which is a Multi Master PG
> Replication (http://2ndquadrant.com/en/resources/bdr/).
>
> I mean if i have let's say t1,t2,t3,t4 and t5. Can i have BDR only for
> t1,t
Hi,
Is there a option of selecting tables in BDR which is a Multi Master PG
Replication (http://2ndquadrant.com/en/resources/bdr/).
I mean if i have let's say t1,t2,t3,t4 and t5. Can i have BDR only for
t1,t2 and t3 table ?
Regards,
Kaushal
Hi,
For some time I'm struggling to get my schema "optimised" for a sort of
"message exchange" (or "document circulation") system.
For every record in the table of those messages I have:
1. SENDER
2. RECEIPIENT
3. unique (sender assigned)SN
4. ... and naturally all the other stuff, like the messa
44 matches
Mail list logo