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.

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

We encounter one problem that PostgreSQL walsender process doesn't exist after "pg_ctl stop -m fast". Uses PostgreSQL 9.6.2 Steps: 1)active postgres server is up; 2)standby postgres intance take pg_basebackup 3)usin command "pg_ctl stop -W -m fast -D /mnt/db/DBTestPostgres/db_data" to stop active

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

[GENERAL] Postgresql and github

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

[GENERAL] PostgreSQL 9.5 showing unexpected behavior when installed with different locale other than default

Hi, On Windows 7, I am trying to install PostgreSQL 9.5 ( *postgresql-9.5.2-1-windows-x64.exe*) with different locales, but it is getting installed with default locale only, which is, `*English_United States.1252*`. I tried both the methods, GUI and unattended/silent, but the results are same. I

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

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

Hi, 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. for the meantime I have started postgresql as below - /usr/pgsql-9.3/bin/

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

[GENERAL] Postgresql CDC tool recommendations ?

Guys Any recommendation on a good CDC tool that can be used to push postgresql changes to Kafka in json format ? Thanks Avi

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

resql.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 "COPY" statement be

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

[GENERAL] PostgreSQL COPY Statement Error On Linux

Hi All, 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 installed in a WINDOWS environment (Windows 7), but fails

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

[GENERAL] Postgresql init and cleanup module functions

High! 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." Regards, Yan

[GENERAL] PostgreSQL used in our network engine (SLikeNet)

Hi, I'd just like to quickly reach out to let you know that we released a new (open source) network engine in which we also utilize PostgreSQL and want to thank you for the work you put into the project. PostgreSQL is utilized for two parts in the network engine: - as an option for a backend db

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

G. Johnston Sent: August 6, 2017 3:47 AM To: Dan Cooperstock at Software4Nonprofits Cc: Forums postgresql Subject: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials) On Saturday, August 5, 2017, Dan Cooperstock at Software4Nonprofits > wrote: As I have mentioned in several

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

On Saturday, August 5, 2017, Dan Cooperstock at Software4Nonprofits < i...@software4nonprofits.com > wrote: > > As I have mentioned in several replies, I have tested all of this code > directly in SQL statements and they work perfectly. It's only the > interaction with PowerBuilder that isn't worki

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

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

I'm trying to get a Postgres DB version of an application I write in PowerBuilder working. The thing I'm stuck on is Identity keys - what you set up with the SERIAL attribute or SEQUENCEs / GENERATORs in Postgres. I have the sequence set up and clearly working. And in PowerBuilder, I have added

[GENERAL] PostgreSQL 9.3 Uninstall error - Windows 2012

Hi, I am trying to uninstall PostgreSQL 9.3 from a Windows 2012 server using the *uninstall-postgresql.exe*. During the uninstall, I get an error: *The uninstall-postgresql.dat file cannot be found and is required to uninstall the application, aborting. Uninstallation did not complete successfull

[GENERAL] PostgreSQL and Data Warehouse optimizations

Recently, I've been doing a research about data warehouse optimizations and techniques. For example, Oracle uses parallel queries, materialized views with different refresh modes, star transformations in queries, etc. Since I've never worked with PostgreSQL in an OLAP environment, I thought maybe t

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

[GENERAL] Postgresql - commercial version

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. Thanks in Advance.

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

[GENERAL] PostGreSQL Timeout, auto shutdown and Pkey errors

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 On the 6/22/17 at 10:51am we had ERROR [08001] timeout expired at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, Re

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

[GENERAL] PostgreSQL Cookbook Testing

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/postgresql-master/.kitchen.yml as YAML. Please run `kitche

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

[GENERAL] PostgreSQL Source Control Integration

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? Best Regards, -- Gunce Kaya Linkedin - Twitter - Blog

[GENERAL] PostgreSQL RPMs for PPC64LE are released

The PostgreSQL YUM Repository Project is happy to announce RPMs of PostgreSQL 9.6 and related software for Power8 Little Endian (PPC64LE) platforms on RHEL 7 and CentOS 7. We want to thank IBM and EnterpriseDB for sponsoring hardware and manpower for this project. These packages follow the same u

[GENERAL] PostgreSQL Portable for Linux

Good morning / afternoon / night, I already updated the PostgreSQL Portable for Linux Debian and him flawors. Tested on Debian Jessie and Ubuntu 17.4. Its a 7z file.https://sourceforge.net/projects/pgsqlportable/files/9.6/pgsql%209.6x64.7z/download Please look the description of the project to r

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

[GENERAL] PostgreSQL Required Monitoring

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,software running, connection available on the co

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

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

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 to patch to the latest minor release) - Minor

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

[GENERAL] PostgreSQL and Kubernetes

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-cluster-f353cde

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

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

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.org/message-id/839805.58072.qm%40web23603.mail.ird.y

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

  1   2   3   4   5   6   7   8   9   10   >