Re: [GENERAL] PostgreSQL walsender process doesn't exist after "pg_ctl stop -m fast"

On Tue, Nov 14, 2017 at 12:05 AM, Tom Lane wrote: > y39chen writes: >> We encounter one problem that PostgreSQL walsender process doesn't exist >> after "pg_ctl stop -m fast". >> Uses PostgreSQL 9.6.2 > > There was a fix in 9.6.4 that's at least related to this problem. > It would be interesting

Re: [GENERAL] PostgreSQL walsender process doesn't exist after "pg_ctl stop -m fast"

y39chen writes: > We encounter one problem that PostgreSQL walsender process doesn't exist > after "pg_ctl stop -m fast". > Uses PostgreSQL 9.6.2 There was a fix in 9.6.4 that's at least related to this problem. It would be interesting to see if you can still reproduce it on current 9.6.

Re: [GENERAL] Postgresql and github

Hi Poul, and thanks for using PostgreSQL! I've also been a very heavy user of Oracle and now a heavy user of PostgreSQL. I remember the days before Oracle acquired the RMAN software and bundled it with their database. Not so long ago, doing backups on Oracle wasn't so different from PostgreSQL;

Re: [GENERAL] Postgresql and github

Dear friends, The reason I posted this: For the last 6 months I have noticed the enormous numbers of github's raising on the Internet. For the last 10 years I have worked with Oracle(yes expensive)and Postgresql(from version 8.4!) and I am familiar conserning the _big_ difference between the to d

Re: [GENERAL] Postgresql and github

> On Nov 9, 2017, at 9:37 AM, Poul Kristensen wrote: > > No it isn't. > > What I want to do is: > > ansible-playbook somepostgresql.yml > > and postgresql is then changed on some server > the way things are done by e.g. > github.com/oravirt/ansible-oracle You're looking for help with an

Re: [GENERAL] Postgresql and github

On Thu, 2017-11-09 at 12:27 +0100, Poul Kristensen wrote: > Hi! > > How come that Postgresql is not present in a github with latest > release? > > It would be very convenient to deploy PG using Ansible. > > Oracle(latest release) is available through github. > > TIA > > Poul > How can you sa

Re: [GENERAL] Postgresql and github

No it isn't. What I want to do is: ansible-playbook somepostgresql.yml and postgresql is then changed on some server the way things are done by e.g. github.com/oravirt/ansible-oracle Thanks Poul 2017-11-09 17:18 GMT+01:00 Igal @ Lucee.org : > On 11/9/2017 3:27 AM, Poul Kristensen wrote: >

Re: [GENERAL] Postgresql and github

On 11/9/2017 3:27 AM, Poul Kristensen wrote: How come that Postgresql is not present in a github with latest release? What do you mean?  Is this not what you're referring to:     https://github.com/postgres/postgres/releases ? Igal Sapir Lucee Core Developer Lucee.org

Re: [GENERAL] Postgresql and github

On Thu, Nov 9, 2017 at 8:27 PM, Poul Kristensen wrote: > How come that Postgresql is not present in a github with latest release? > > It would be very convenient to deploy PG using Ansible. > > Oracle(latest release) is available through github. You are looking for that, which is a mirror of the

Re: [GENERAL] Postgresql 9.3 service doesn't start on RedHat Linux 6.8

On 11/6/2017 5:28 AM, Vikas Sharma wrote: I am having issues in starting up postgresql service on RHEL 6.8, It was all working fine yesterday but now it doesn't start and throws error - same kind of error that is received connecting to remote postgres database. what /exact/ error is it throwi

Re: [GENERAL] Postgresql CDC tool recommendations ?

On Thu, Oct 05, 2017 at 10:28:31AM -0700, avi Singh wrote: > Any recommendation on a good CDC tool that can be used to push > postgresql changes to Kafka in json format ? There are quite a few WAL->JSON type tools out there. E.g., https://github.com/eulerto/wal2json I expect this to imp

Re: [GENERAL] Postgresql CDC tool recommendations ?

> On Oct 5, 2017, at 10:28 AM, avi Singh wrote: > > Guys > Any recommendation on a good CDC tool that can be used to push > postgresql changes to Kafka in json format ? Not sure whether json is a constraint, but I'd look at http://debezium.io and (maybe) the no longer supported http

Re: [GENERAL] PostgreSQL COPY Statement Error On Linux

George: On Tue, Sep 12, 2017 at 6:40 PM, George Neuner wrote: > Francisco already pointed out that Linux doesn't understand the > backslashes in the file path, however it should be noted that Windows > *does* understand forward slashes and that [modulo disk names in > Windows] you can use forward

Re: [GENERAL] PostgreSQL COPY Statement Error On Linux

On Tue, 12 Sep 2017 11:30:02 +0100, Osahon Oduware wrote: >I am trying to utilize the "COPY" statement below to copy a .CSV file to a >table in a PostgreSQL database.: >*COPY .() FROM >'\\shared\network\path\to\csv\test.csv' DELIMITER ',' CSV HEADER;* > >This works with a PostgreSQL database

Re: [GENERAL] PostgreSQL COPY Statement Error On Linux

Hi Francisco, Thanks for your response. I would try this out and give you feedback. On Tue, Sep 12, 2017 at 12:00 PM, Francisco Olarte wrote: > On Tue, Sep 12, 2017 at 12:30 PM, Osahon Oduware > wrote: > > I am trying to utilize the "COPY" statement below to copy a .CSV file to > a > > table i

Re: [GENERAL] PostgreSQL COPY Statement Error On Linux

Hi Charles, Thanks for your response. I would try this out and give you feedback. On Tue, Sep 12, 2017 at 12:01 PM, Charles Clavadetscher < clavadetsc...@swisspug.org> wrote: > Hello > > > > *From:* pgsql-general-ow...@postgresql.org [mailto:pgsql-general-owner@ > postgresql.org] *On Behalf Of *

Re: [GENERAL] PostgreSQL COPY Statement Error On Linux

On Tue, Sep 12, 2017 at 12:30 PM, Osahon Oduware wrote: > I am trying to utilize the "COPY" statement below to copy a .CSV file to a > table in a PostgreSQL database.: > COPY .() FROM > '\\shared\network\path\to\csv\test.csv' DELIMITER ',' CSV HEADER; > > This works with a PostgreSQL database

Re: [GENERAL] PostgreSQL COPY Statement Error On Linux

Hello From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Osahon Oduware Sent: Dienstag, 12. September 2017 12:30 To: pgsql-general@postgresql.org Subject: [GENERAL] PostgreSQL COPY Statement Error On Linux Hi All, I am trying to utilize the "

Re: [GENERAL] Postgresql init and cleanup module functions

Sorry, replied only to direct sender, duplicating to both sender and mailing list *---* *MSG1:* Thanks you, that is what I was looking for! I was testing sample module and found it's behavior odd: 1. functions have few permissions, they even were not able to create file in "/tmp" directory. At lea

Re: [GENERAL] Postgresql init and cleanup module functions

On 2017-09-05 20:15:57 +0300, Yan Pas wrote: > I'm writing C postgresql module with some psql-functions and global state. > Do module API provide any init and cleanup functions? If yes then it would > be fine to see them in "35.9. C-Language Functions" help page." The relevant doc page is at https

Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

Thanks, David, this was actually the most helpful suggestion. Using logging of SQL statements in Postgres, I was able to first determine that the style of quoting I was using in the PowerBuilder INI file wasn’t working, and then that the &TableName variable wasn’t being expanded by PowerBuilder

Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

Hi, Dan, On Sat, Aug 5, 2017 at 8:52 PM, Dan Cooperstock at Software4Nonprofits wrote: > No, Carl, when I created the sequence, I didn't put its name in double > quotes, so therefore its name wasn't being forced to stay upper case. So in > the nextval() command, putting it only in single quotes w

Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

No, Carl, when I created the sequence, I didn't put its name in double quotes, so therefore its name wasn't being forced to stay upper case. So in the nextval() command, putting it only in single quotes works - Postgres converts both the original creation and the reference to it to lower case. As

Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

> Select currval('GEN_&TableName') > >From the above, I am assuming you did something like: CREATE SEQUENCE "GEN_&TableName" ...; and are trying to access this sequence? If so, you actually have to include the SQL quoted identifier syntax within the text argument to currval() or nextval()

Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

On 8/5/2017 6:06 PM, Dan Cooperstock at Software4Nonprofits wrote: (I wish Postgres had a web-based community board, rather than just this mailing list with no history available!) I will post it to Appeon as an actual bug if I get stuck. Have you looked here? https://www.postgresql.org/list/

Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

Cc: Dan Cooperstock at Software4Nonprofits ; Rob Sargent ; Forums postgresql Subject: Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials) On Sat, Aug 5, 2017 at 6:26 PM, Igor Korot mailto:ikoro...@gmail.com> > wrote: Hi, Did you try bringing it to SAP? Thank you. On

Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

;UNSUBSCRIBE", and we will immediately remove you from our mailing list, if > you are on it. > > > > > > -Original Message- > > From: Rob Sargent [mailto:robjsarg...@gmail.com] > > Sent: August 5, 2017 5:30 PM > > To: Dan Cooperstock at Software4Nonprofi

Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

ceive any further emails from Software4Nonprofits, > please reply to this email with the subject line "UNSUBSCRIBE", and we will > immediately remove you from our mailing list, if you are on it. > > > -Original Message----- > From: Rob Sargent [mailto:robjsarg...@gm

Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

[mailto:robjsarg...@gmail.com] Sent: August 5, 2017 5:30 PM To: Dan Cooperstock at Software4Nonprofits Cc: Forums postgresql Subject: Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials) > On Aug 5, 2017, at 3:12 PM, Dan Cooperstock at Software4Nonprofits > wrote: > &g

Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

t to receive any further emails from Software4Nonprofits, > please reply to this email with the subject line "UNSUBSCRIBE", and we will > immediately remove you from our mailing list, if you are on it. > > > From: Melvin Davidson [mailto:melvin6...@gmail.com] &

Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

we will immediately remove you from our mailing list, if you are on it. From: Melvin Davidson [mailto:melvin6...@gmail.com] Sent: August 5, 2017 4:46 PM To: Dan Cooperstock at Software4Nonprofits Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity

Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

>GetIdentity="Select currval('GEN_&TableName')" *FYI, it would be helpful to specify the PostgreSQL version & O/S, but generically speaking, in PostgreSQL, when you generate a sequence * *by specifying serial as data type, the name takews the form of tablename_columnname_seq, so in your cas

Re: [GENERAL] Postgresql - commercial version

On 7/7/2017 8:22 AM, Terry Schmitt wrote: You have the open source version installed. Now where it was installed from is a different story. if its a redhat/centos/fedora type system, try... rpm -qa |grep ^postgres if it was installed from rpm's, the full names of the rpms will clue you i

Re: [GENERAL] Postgresql - commercial version

You have the open source version installed. Now where it was installed from is a different story. EnterpriseDB Advanced Server will look like: EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit T On Fri, Jul 7, 2017 at 7:04 AM, Krithika

Re: [GENERAL] Postgresql - commercial version

On Fri, Jul 7, 2017 at 9:04 AM, Krithika Venkatesh < krithikavenkates...@gmail.com> wrote: > select version () gives me output something like this > > PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 > 20080704 (Red hat 4.1.2-55), 64 bit. > > Is there any other way to find > >

Re: [GENERAL] Postgresql - commercial version

On 07/07/2017 07:04 AM, Krithika Venkatesh wrote: select version () gives me output something like this PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red hat 4.1.2-55), 64 bit. Is there any other way to find It depends on what you are trying to determine:

Re: [GENERAL] Postgresql - commercial version

On Fri, Jul 7, 2017 at 7:04 AM, Krithika Venkatesh < krithikavenkates...@gmail.com> wrote: > select version () gives me output something like this > > PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 > 20080704 (Red hat 4.1.2-55), 64 bit. > > Is there any other way to find >

Re: [GENERAL] Postgresql - commercial version

select version () gives me output something like this PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red hat 4.1.2-55), 64 bit. Is there any other way to find On 07-Jul-2017 7:28 PM, "Adrian Klaver" wrote: > On 07/07/2017 06:52 AM, Krithika Venkatesh wrote: > >

Re: [GENERAL] Postgresql - commercial version

On 07/07/2017 06:52 AM, Krithika Venkatesh wrote: Hi, I have postgreSQL 9.5 installed in the server. Is it possible to find whether the installed postgresql is enterprise db or an open source version through a query. Not sure, but I would try: select version(); Thanks in Advance. -- A

Re: [GENERAL] PostGreSQL Timeout, auto shutdown and Pkey errors

On 06/30/2017 11:35 AM, Niel Smith wrote: Please reply to list also. Ccing list. Also to help with replies in the future could you change your posting style to something like: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style Thanks. What version of Postgres and where did you ge

Re: [GENERAL] PostGreSQL Timeout, auto shutdown and Pkey errors

On 06/28/2017 11:32 AM, Niel Smith wrote: Hi, So I have a few problems with my PostGreSQL and was hoping you could help me out. one is I'm getting random timeouts and the errors I'm seeing in the logs are What version of Postgres and where did you get it? OS and version? Which logs? On th

Re: [GENERAL] PostGreSQL Timeout, auto shutdown and Pkey errors

On 06/28/2017 11:32 AM, Niel Smith wrote: Hi, So I have a few problems with my PostGreSQL and was hoping you could help me out. one is I'm getting random timeouts and the errors I'm seeing in the logs are What version of Postgres and where did you get it? OS and version? What is the source f

Re: [GENERAL] PostgreSQL Cookbook Testing

On 06/23/2017 05:27 AM, PAWAN SHARMA wrote: Hi All, Please help to configure kitchen.yml to test the PostgreSQL cookbook testing. #-> kitchen converge -> Starting Kitchen (v1.16.0) >> --Exception--- >> Class: Kitchen::UserError >> Message: Error parsing /tmp/postgre

Re: [GENERAL] PostgreSQL Cookbook Testing

On Fri, Jun 23, 2017 at 06:33:56PM +0530, PAWAN SHARMA wrote: > > On Fri, Jun 23, 2017 at 05:57:44PM +0530, PAWAN SHARMA wrote: > > > > > Please help to configure kitchen.yml to test the PostgreSQL cookbook > > > testing. > > > > > > #-> kitchen converge > > > -> Starting Kitchen (v1.16.0) > >

Re: [GENERAL] PostgreSQL Cookbook Testing

On Fri, Jun 23, 2017 at 6:10 PM, Karsten Hilbert wrote: > On Fri, Jun 23, 2017 at 05:57:44PM +0530, PAWAN SHARMA wrote: > > > Please help to configure kitchen.yml to test the PostgreSQL cookbook > > testing. > > > > #-> kitchen converge > > -> Starting Kitchen (v1.16.0) > > >> --Excep

Re: [GENERAL] PostgreSQL Cookbook Testing

On Fri, Jun 23, 2017 at 05:57:44PM +0530, PAWAN SHARMA wrote: > Please help to configure kitchen.yml to test the PostgreSQL cookbook > testing. > > #-> kitchen converge > -> Starting Kitchen (v1.16.0) > >> --Exception--- > >> Class: Kitchen::UserError > >> Message: Error p

Re: [GENERAL] PostgreSQL Source Control Integration

Hello Adrian, Thank you for your suggest, I'll examine and decide to use it. Regards, Gunce On Wed, Jun 21, 2017 at 3:45 PM, Adrian Klaver wrote: > On 06/21/2017 05:08 AM, Günce Kaya wrote: > >> Hi, >> >> I work on PostgreSQL 9.6 and I'm looking for a source code control tool. >> Is there any

Re: [GENERAL] PostgreSQL Source Control Integration

On 06/21/2017 05:08 AM, Günce Kaya wrote: Hi, I work on PostgreSQL 9.6 and I'm looking for a source code control tool. Is there anyone who give a suggest about that? http://sqitch.org/ Best Regards, -- Gunce Kaya -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general m

Re: [GENERAL] PostgreSQL Required Monitoring

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Andrew Kerber Sent: Friday, April 28, 2017 12:58 PM To: Scott Marlowe Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] PostgreSQL Required Monitoring Attention: This email was sent from

Re: [GENERAL] PostgreSQL Required Monitoring

Yes, that was the first item on my list (disk space)... On Fri, Apr 28, 2017 at 11:56 AM, Scott Marlowe wrote: > On Fri, Apr 28, 2017 at 8:39 AM, Andrew Kerber > wrote: > > I am a fairly experienced Oracle DBA, and we are starting to move in to > the > > PostgreSQL world. I would expect the st

Re: [GENERAL] PostgreSQL Required Monitoring

On Fri, Apr 28, 2017 at 8:39 AM, Andrew Kerber wrote: > I am a fairly experienced Oracle DBA, and we are starting to move in to the > PostgreSQL world. I would expect the standard monitoring items are required > for mission critical postgres apps, Ie, disk space, wal log space, log > monitoring,

Re: [GENERAL] PostgreSQL Required Monitoring

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Andrew Kerber Sent: Friday, April 28, 2017 12:22 PM To: John R Pierce Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] PostgreSQL Required Monitoring Attention: This email was sent from

Re: [GENERAL] PostgreSQL Required Monitoring

yes, replication monitoring is high on the oracle list also, just forgot to mention it. I ran into a similar transaction issue in Oracle when they were running queries across database links and not committing. Its a little known fact that any oracle query that runs across a database link starts a

Re: [GENERAL] PostgreSQL Required Monitoring

On 4/28/2017 7:39 AM, Andrew Kerber wrote: I am a fairly experienced Oracle DBA, and we are starting to move in to the PostgreSQL world. I would expect the standard monitoring items are required for mission critical postgres apps, Ie, disk space, wal log space, log monitoring, process counts,s

Re: [GENERAL] PostgreSQL Required Monitoring

On Fri, Apr 28, 2017 at 4:39 PM, Andrew Kerber wrote: > I am a fairly experienced Oracle DBA, and we are starting to move in to > the PostgreSQL world. I would expect the standard monitoring items are > required for mission critical postgres apps, Ie, disk space, wal log space, > log monitoring,

Re: [GENERAL] PostgreSQL Required Monitoring

On Fri, Apr 28, 2017 at 10:46 AM, Joshua D. Drake wrote: > On 04/28/2017 07:39 AM, Andrew Kerber wrote: > >> I am a fairly experienced Oracle DBA, and we are starting to move in to >> the PostgreSQL world. I would expect the standard monitoring items are >> required for mission critical postgres

Re: [GENERAL] PostgreSQL Required Monitoring

On 04/28/2017 07:39 AM, Andrew Kerber wrote: I am a fairly experienced Oracle DBA, and we are starting to move in to the PostgreSQL world. I would expect the standard monitoring items are required for mission critical postgres apps, Ie, disk space, wal log space, log monitoring, process counts,s

Re: [GENERAL] PostgreSQL upgrade best practices, please share your thoughts

On 04/27/2017 08:41 AM, Daniel Westermann wrote: Hi all, currently I am preparing my session (PostgreSQL upgrade best practices) for the Swiss PGDay 2017 (http://www.pgday.ch/2017/). What I plan to come up with is: - Support policy - Release notes - Why it is important to upgrade (or at least t

Re: [GENERAL] postgresql-plperl-9.4 : Depends: libperl5.18 (>= 5.18.2) but it is not installable

Subject: Re: [GENERAL] postgresql-plperl-9.4 : Depends: libperl5.18 (>= 5.18.2) but it is not installable On 04/11/2017 07:23 PM, Muhammad Hanif Abdul Hamid wrote: > Dear Admin, > > > > I would like to install “postgresql-plperl-9.4” package, however it > failed du

Re: [GENERAL] postgresql-plperl-9.4 : Depends: libperl5.18 (>= 5.18.2) but it is not installable

On 04/11/2017 07:23 PM, Muhammad Hanif Abdul Hamid wrote: Dear Admin, I would like to install “postgresql-plperl-9.4” package, however it failed due to the “libperl5.18” dependency is lower than “libperl5.22” installed as below:- Obviously some Debian derived distribution, but what one and v

Re: [GENERAL] postgresql-plperl-9.4 : Depends: libperl5.18 (>= 5.18.2) but it is not installable

Dear Admin, I would like to install “postgresql-plperl-9.4” package, however it failed due to the “libperl5.18” dependency is lower than “libperl5.22” installed as below:- root@db:/home/prod# apt-get install postgresql-plperl-9.4 Reading package lists... Done Building dependency tree Read

Re: [GENERAL] PostgreSQL and Kubernetes

Il 03/04/2017 22:32, Alex Kliukin ha scritto: as it makes little sense to build an aircraft carrier to carry a single Cessna. :-) A bit extreme, but it makes the idea ... Thanks Moreno.-   Kind

Re: [GENERAL] PostgreSQL and Kubernetes

Il 03/04/2017 18:10, Joe Conway ha scritto: On 03/31/2017 01:58 AM, Moreno Andreo wrote: Il 30/03/2017 14:38, Vick Khera ha scritto: On Thu, Mar 30, 2017 at 6:10 AM, Moreno Andreo mailto:moreno.and...@evolu-s.it>> wrote: Since I'm on Google Cloud Platform, I thought it would be a good

Re: [GENERAL] PostgreSQL and Kubernetes

> On 30. Mar 2017, at 12:10, Moreno Andreo wrote: > as databases aren't built for type of dynamic scheduling that something like > kubernetes (or any other container management solution), due to how they > interact with the filesystem, network stack, and more. > Further more, he suggests that

Re: [GENERAL] PostgreSQL and Kubernetes

On 03/31/2017 01:58 AM, Moreno Andreo wrote: > Il 30/03/2017 14:38, Vick Khera ha scritto: >> >> On Thu, Mar 30, 2017 at 6:10 AM, Moreno Andreo >> mailto:moreno.and...@evolu-s.it>> wrote: >> >> Since I'm on Google Cloud Platform, I thought it would be a good >> idea to see what it offers.

Re: [GENERAL] PostgreSQL and Kubernetes

Il 30/03/2017 14:38, Vick Khera ha scritto: On Thu, Mar 30, 2017 at 6:10 AM, Moreno Andreo wrote: Since I'm on Google Cloud Platform, I thought it would be a good

Re: [GENERAL] PostgreSQL and Kubernetes

Il 30/03/2017 15:27, Adrian Klaver ha scritto: On 03/30/2017 03:10 AM, Moreno Andreo wrote: Hi everyone, I was googling around while searching stuff to finish my cluster solution (already running in production in single-server mode) with barman and pgbouncer, when I ran into this https://h

Re: [GENERAL] PostgreSQL and Kubernetes

On 03/30/2017 03:10 AM, Moreno Andreo wrote: Hi everyone, I was googling around while searching stuff to finish my cluster solution (already running in production in single-server mode) with barman and pgbouncer, when I ran into this https://hackernoon.com/postgresql-cluster-into-kubernetes

Re: [GENERAL] PostgreSQL and Kubernetes

On Thu, Mar 30, 2017 at 6:10 AM, Moreno Andreo wrote: > Since I'm on Google Cloud Platform, I thought it would be a good idea to > see what it offers. They currently have in beta a Postgres flavor of their cloudsql. I haven't used it yet, but I plan to test it sometime in the next couple of mon

Re: [GENERAL] PostgreSQL general discussions list - 2010 Thread: Wikipedia entry - AmigaOS port - error?

On Tue, Mar 14, 2017 at 6:40 PM, Rakesh Kumar wrote: >>More to the point, whatever "MorphOS" is, it isn't AmigaOS. It was pretty >>clearly stated in the original thread that AmigaOS had no support for >>fork(), without which there was no chance of running Postgres. > > Just curious, if PG is comp

Re: [GENERAL] PostgreSQL general discussions list - 2010 Thread: Wikipedia entry - AmigaOS port - error?

>More to the point, whatever "MorphOS" is, it isn't AmigaOS. It was pretty >clearly stated in the original thread that AmigaOS had no support for >fork(), without which there was no chance of running Postgres. Just curious, if PG is completely dependent on fork(), how was it ported to Windows w

Re: [GENERAL] PostgreSQL general discussions list - 2010 Thread: Wikipedia entry - AmigaOS port - error?

On Mon, Mar 13, 2017 at 11:15 PM, John R Pierce wrote: > On 3/13/2017 10:06 PM, Scott Marlowe wrote: > > I am pretty sure it is: > > https://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems#Operating_system_support > > PostgreSQL Yes Yes Yes Yes Yes

Re: [GENERAL] PostgreSQL general discussions list - 2010 Thread: Wikipedia entry - AmigaOS port - error?

On 3/13/2017 10:06 PM, Scott Marlowe wrote: I am pretty sure it is: https://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems#Operating_system_support PostgreSQL Yes Yes Yes Yes Yes Yes (MorphOS)[24] Oh man, 2005's versuin 6.3.2. It's more of

Re: [GENERAL] PostgreSQL general discussions list - 2010 Thread: Wikipedia entry - AmigaOS port - error?

Scott Marlowe writes: > On Mon, Mar 13, 2017 at 10:41 PM, Adrian Klaver > wrote: >> I am pretty sure it is: >> https://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems#Operating_system_support >> PostgreSQL Yes Yes Yes Yes Yes Yes (MorphOS)[24]

Re: [GENERAL] PostgreSQL general discussions list - 2010 Thread: Wikipedia entry - AmigaOS port - error?

On Mon, Mar 13, 2017 at 10:41 PM, Adrian Klaver wrote: > On 03/13/2017 02:13 AM, Raffaele Irlanda wrote: >> http://aminet.net/package/dev/gg/postgresql632-mos-bin >> >> In 2010 it has been sure completely outdated but sure you can see proof >> it exists, and that Amiga had full dignity of being p

Re: [GENERAL] PostgreSQL general discussions list - 2010 Thread: Wikipedia entry - AmigaOS port - error?

On 03/13/2017 02:13 AM, Raffaele Irlanda wrote: Hello People of PostgreSQL, Unfortunately only nowadays (March 2017), and only by chance I spotted this 2010 discussion during a Google search. Name of discussion: Wikipedia entry - AmigaOS port - error? id of message: https://www.postgresql.or

Re: [GENERAL] postgresql how to duplicate rows in result.

Merlin Moncure writes: > On Thu, Feb 16, 2017 at 10:27 AM, David G. Johnston > wrote: >> If it wasn't lateral the reference to number in "generate_series(1, number)" >> would fail. > huh -- I didn't know that! Testing it out, all JOIN types imply > LATERAL if the function call is tlist SRF styl

Re: [GENERAL] postgresql how to duplicate rows in result.

On Thu, Feb 16, 2017 at 10:27 AM, David G. Johnston wrote: > If it wasn't lateral the reference to number in "generate_series(1, number)" > would fail. huh -- I didn't know that! Testing it out, all JOIN types imply LATERAL if the function call is tlist SRF style (which is pretty werid IMO) I t

Re: [GENERAL] PostgreSQL on eMMC - Corrupt file system

Am 10.02.2017 um 09:16 schrieb Mark Morgan Lloyd: > On 09/02/17 23:00, Christoph Moench-Tegeder wrote: >> ## Thomas Güttler (guettl...@thomas-guettler.de): >> >>> Is running linux with postgres on eMMC a bad idea in general? >> >> I'd say that running anything with a read-write load on eMMC will >

Re: [GENERAL] PostgreSQL mirroring from RPM install to RPM install-revisited

Hi again Adrian, Facepalm... The master server was not installed by me. I was assured by the installer guy that it was version 9.4.1 and 64 bit. Facepalm... I managed to get enough access to that server to discover they had installed the 32 bit version of PostgreSQL. Who knows why? This expla

Re: [GENERAL] PostgreSQL mirroring from RPM install to RPM install-revisited

On 02/17/2017 12:34 PM, Richard Brosnahan wrote: Thanks for the response Adrian, Both servers are pretty much identical. uname -a master Linux devtmbm178 2.6.32-642.6.2.el6.x86_64 #1 SMP Tue Oct 25 13:37:48 PDT 2016 x86_64 x86_64 x86_64 GNU/Linux slave Linux devtmbm176 2.6.32-642.11.1.el6.x86_

[GENERAL] Re: [GENERAL] PostgreSQL mirroring from RPM install to RPM install-revisited

Thanks for the response Adrian, Both servers are pretty much identical.  uname -a master Linux devtmbm178 2.6.32-642.6.2.el6.x86_64 #1 SMP Tue Oct 25 13:37:48 PDT 2016 x86_64 x86_64 x86_64 GNU/Linux slave Linux devtmbm176 2.6.32-642.11.1.el6.x86_64 #1 SMP Tue Nov 15 09:40:59 PST 2016 x86_64 x

Re: [GENERAL] PostgreSQL mirroring from RPM install to RPM install-revisited

On 02/16/2017 04:39 PM, Richard Brosnahan wrote: Hi all, Way back in December I posted a question about mirroring from an RPM installed PostgreSQL (binary) to a source built PostgreSQL, with the same version (9.4.1 --> 9.4.1). Both servers are running OEL6. I went back to the previous threads

Re: [GENERAL] PostgreSQL corruption

On 2/16/2017 6:48 PM, James Sewell wrote: Sadly this is for a customer who has 3000 of these in the field, the raid controller is on the motherboard. if thats the usual Intel "Matrix" raid, thats not actually a raid controller. its intel sata in fake raid mode, the raid is entirely done in

Re: [GENERAL] PostgreSQL corruption

Sadly this is for a customer who has 3000 of these in the field, the raid controller is on the motherboard. At least they know where to point the finger now! Cheers, James Sewell, PostgreSQL Team Lead / Solutions Architect Suite 112, Jones Bay Wharf, 26-32 Pirrama Road, Pyrmont NSW 2009 *P *(

Re: [GENERAL] postgresql how to duplicate rows in result.

On Thu, Feb 16, 2017 at 9:16 AM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > For my enlightenment, why use LATERAL here? I get the same result with a > simple CROSS JOIN (though overall I like the clever solution). > > ​To be explicit, I think. CROSS JOIN function() implies lateral

Re: [GENERAL] postgresql how to duplicate rows in result.

For my enlightenment, why use LATERAL here? I get the same result with a simple CROSS JOIN (though overall I like the clever solution). Cheers, Steve On Thu, Feb 16, 2017 at 12:11 AM, Alessandro Baggi < alessandro.ba...@gmail.com> wrote: > Il 15/02/2017 19:11, Alessandro Baggi ha scritto: > >>

Re: [GENERAL] PostgreSQL corruption

On Tue, Feb 14, 2017 at 7:23 PM, James Sewell wrote: > OK, > > So with some help from the IRC channel (thanks macdice and JanniCash) > it's come to light that my RAID1 comprised of 2 * 7200RPM disks is > reporting ~500 ops/sec in pg_test_fsync. > > This is higher than the ~120 ops/sec which you

Re: [GENERAL] postgresql how to duplicate rows in result.

Il 15/02/2017 19:11, Alessandro Baggi ha scritto: Il 14/02/2017 21:51, Merlin Moncure ha scritto: On Tue, Feb 14, 2017 at 12:36 PM, Merlin Moncure wrote: On Tue, Feb 14, 2017 at 12:04 PM, Alessandro Baggi wrote: Hi list, sorry for my english, I will try to example as well. I've a query that

Re: [GENERAL] postgresql how to duplicate rows in result.

Il 14/02/2017 21:51, Merlin Moncure ha scritto: On Tue, Feb 14, 2017 at 12:36 PM, Merlin Moncure wrote: On Tue, Feb 14, 2017 at 12:04 PM, Alessandro Baggi wrote: Hi list, sorry for my english, I will try to example as well. I've a query that joins multiple tables and return a result like: id

Re: [GENERAL] PostgreSQL corruption

OK, So with some help from the IRC channel (thanks macdice and JanniCash) it's come to light that my RAID1 comprised of 2 * 7200RPM disks is reporting ~500 ops/sec in pg_test_fsync. This is higher than the ~120 ops/sec which you would expect from 720RPM disks - therefore something is lying. Bre

Re: [GENERAL] PostgreSQL corruption

That's the plan, but it's essentially a client managed embedded database so small steps needed. If I can prove it's the hardware first that would be preferable. It looks like diskcheck.pl doesn't work on Windows (no IO::Handle::sync) - does anybody know of an alternative testkit. A C one would be

Re: [GENERAL] postgresql how to duplicate rows in result.

On Tue, Feb 14, 2017 at 2:50 PM, Merlin Moncure wrote: > ​ > > > IMO, lateral join (available as of 9.3) is faster and simpler. > ​And, nicely, I've learned something new. I've never used a LATERAL join before. Interesting.​ > > merlin > -- "Irrigation of the land with sewater desalinated

Re: [GENERAL] postgresql how to duplicate rows in result.

On Tue, Feb 14, 2017 at 12:36 PM, Merlin Moncure wrote: > On Tue, Feb 14, 2017 at 12:04 PM, Alessandro Baggi > wrote: >> Hi list, >> sorry for my english, I will try to example as well. I've a query that joins >> multiple tables and return a result like: >> >> id,customers,phone,code,number >> 1

Re: [GENERAL] postgresql how to duplicate rows in result.

On Tue, Feb 14, 2017 at 12:42 PM, John McKown wrote: > On Tue, Feb 14, 2017 at 12:04 PM, Alessandro Baggi > wrote: >> >> Hi list, >> sorry for my english, I will try to example as well. I've a query that >> joins multiple tables and return a result like: >> >> >> id,customers,phone,code,number >>

Re: [GENERAL] postgresql how to duplicate rows in result.

On Tue, Feb 14, 2017 at 12:04 PM, Alessandro Baggi < alessandro.ba...@gmail.com> wrote: > Hi list, > sorry for my english, I will try to example as well. I've a query that > joins multiple tables and return a result like: > > > ​​ > id,customers,phone,code,number > 1 , ,3,123 , 2 > 2 ,

Re: [GENERAL] postgresql how to duplicate rows in result.

On Tue, Feb 14, 2017 at 12:04 PM, Alessandro Baggi wrote: > Hi list, > sorry for my english, I will try to example as well. I've a query that joins > multiple tables and return a result like: > > id,customers,phone,code,number > 1 , ,3,123 , 2 > 2 , aassdsds,33322,211 , 1 > 3 , ooo

Re: [GENERAL] postgresql how to duplicate rows in result.

On Tue, Feb 14, 2017 at 1:04 PM, Alessandro Baggi < alessandro.ba...@gmail.com> wrote: > Hi list, > sorry for my english, I will try to example as well. I've a query that > joins multiple tables and return a result like: > > > id,customers,phone,code,number > 1 , ,3,123 , 2 > 2 , aassd

Re: [GENERAL] PostgreSQL corruption

On Tue, Feb 14, 2017 at 5:21 AM, James Sewell wrote: > Hello All, > > I am working with a client who is facing issues with database corruption > after a physical hard power off (the machines are at remote sites, this > could be a power outage or user error). > > They have an environment made up o

Re: [GENERAL] PostgreSQL corruption

On Mon, Feb 13, 2017 at 9:41 PM, Scott Marlowe wrote: > On Mon, Feb 13, 2017 at 9:21 PM, James Sewell > wrote: >> >> Hello All, >> >> I am working with a client who is facing issues with database corruption >> after a physical hard power off (the machines are at remote sites, this >> could be

  1   2   3   4   5   6   7   8   9   10   >