Re: pgbackrest restore to new location?

Greetings, * Ron (ronljohnso...@gmail.com) wrote: > On 9/17/19 6:48 AM, David Steele wrote: > >On 9/17/19 7:23 AM, Luca Ferrari wrote: > >>On Tue, Sep 17, 2019 at 12:00 PM Ron wrote: > >>>The real problem is that after doing that, "pg_ctl start -D > >>>/path/to/new/data" fails with "PANIC: could

Re: PostgreSQL License

> On Sep 17, 2019, at 4:18 PM, Andreas Joseph Krogh wrote: > > På tirsdag 17. september 2019 kl. 22:55:02, skrev Peter J. Holzer > mailto:hjp-pg...@hjp.at>>: > On 2019-09-17 14:56:30 +0300, Ashkar Dev wrote: > > but it is saying (without fee) > > if I create a database with it to work with

Re: PostgreSQL License

På tirsdag 17. september 2019 kl. 22:55:02, skrev Peter J. Holzer < hjp-pg...@hjp.at >: On 2019-09-17 14:56:30 +0300, Ashkar Dev wrote: > but it is saying (without fee) > if I create a database with it to work with Web Application if want to sell it > so the buyer

Re: install pgcrypto module to existing postgreSQL

Ron, yes, Installed with source code. here is my postgres configuration BINDIR = /pgbin/11.2/bin DOCDIR = /pgbin/11.2/share/doc/postgresql HTMLDIR = /pgbin/11.2/share/doc/postgresql INCLUDEDIR = /pgbin/11.2/include PKGINCLUDEDIR = /pgbin/11.2/include/postgresql INCLUDEDIR-SERVER =

Re: install pgcrypto module to existing postgreSQL

IOW, you installed it from source instead of a package. On 9/17/19 4:18 PM, Pavan Kumar wrote: Hello Adrian, i have used configure command install postgres   $ ./configure --prefix=/pgbin/11.2 --with-segsize=32 --with-pgport=5432 once configure is done, used make and make install to install

Re: install pgcrypto module to existing postgreSQL

Hello Adrian, i have used configure command install postgres $ ./configure --prefix=/pgbin/11.2 --with-segsize=32 --with-pgport=5432 once configure is done, used make and make install to install postgres. On Tue, Sep 17, 2019 at 4:06 PM Adrian Klaver wrote: > On 9/17/19 1:25 PM, Pavan

Re: install pgcrypto module to existing postgreSQL

On 9/17/19 1:25 PM, Pavan Kumar wrote: hello experts, i have Installed and created postgres 11.2 and created couple of How did you install? database.  Now i got new requirement to encrypt data on  few tables. to perform this application team is asking us to install pgcrypto module on

Re: PostgreSQL License

On 2019-09-17 14:56:30 +0300, Ashkar Dev wrote: > but it is saying (without fee) > if I create a database with it to work with Web Application if want to sell it > so the buyer must have the PostgreSQL installed in his device to work offline > right? > "Permission to use, copy, modify, and

install pgcrypto module to existing postgreSQL

hello experts, i have Installed and created postgres 11.2 and created couple of database. Now i got new requirement to encrypt data on few tables. to perform this application team is asking us to install pgcrypto module on postgres cluster. what is the way to install pgcrypt library ? please

pg_rewind: invalid record length

Hi, We're encountering an issue when running pg_rewind, and are looking for advice on how to proceed. We have a set of 3 Postgres instances which are being restored from the same physical disk snapshot (which was taken from a standby on a production system), in order to test a disaster recovery

Re: pldbgapi extension

On 9/17/19 9:20 AM, Rob Sargent wrote: On 9/17/19 10:16 AM, Adrian Klaver wrote: On 9/17/19 7:44 AM, Prakash Ramakrishnan wrote: I installed devel and contrib also but not worked here. Yeah, --contrib won't help as pldbpgapi is not one of the contrib modules as found here:

Re: pldbgapi extension

On 9/17/19 10:16 AM, Adrian Klaver wrote: On 9/17/19 7:44 AM, Prakash Ramakrishnan wrote: I installed devel and contrib also but not worked here. Yeah, --contrib won't help as pldbpgapi is not one of the contrib modules as found here: https://www.postgresql.org/docs/11/contrib.html The

Re: pldbgapi extension

On 9/17/19 7:44 AM, Prakash Ramakrishnan wrote: I installed devel and contrib also but not worked here. Yeah, --contrib won't help as pldbpgapi is not one of the contrib modules as found here: https://www.postgresql.org/docs/11/contrib.html The basic issue is you are using two install

Re: pldbgapi extension

I installed devel and contrib also but not worked here. Regards, Prakash.R On Tue, Sep 17, 2019, 19:58 Adrian Klaver wrote: > On 9/17/19 7:20 AM, Prakash Ramakrishnan wrote: > > Hi Adrian, > > > > I did it yum installation postgresql 11 from repo file.but I don't know > > why it's giving

Re: pldbgapi extension

On 9/17/19 7:20 AM, Prakash Ramakrishnan wrote: Hi Adrian, I did it yum installation postgresql 11 from repo file.but I don't know why it's giving wrong path and symbolic link how to create it please advise. Looks like it is installing to source built extension directory, not the package

Re: pldbgapi extension

Hi Adrian, I did it yum installation postgresql 11 from repo file.but I don't know why it's giving wrong path and symbolic link how to create it please advise. Regards, Prakash.R On Tue, Sep 17, 2019, 19:10 Adrian Klaver wrote: > On 9/16/19 11:51 PM, Prakash Ramakrishnan wrote: > > Hi Team,

Re: max_connections parameter: too_many_connections error

> On Sep 17, 2019, at 8:43 AM, Shital A wrote: > > Hello, > > We are working on a payments systems which uses postgreSql 9.6 as backend DB > and blockchain technology. The database is setup in HA in master-standby mode > using pacemaker on Linux 7.6. > > We are new to postgres and need

Re: pgbackrest restore to new location?

On 9/17/19 6:48 AM, David Steele wrote: On 9/17/19 7:23 AM, Luca Ferrari wrote: On Tue, Sep 17, 2019 at 12:00 PM Ron wrote: The real problem is that after doing that, "pg_ctl start -D /path/to/new/data" fails with "PANIC: could not locate a valid checkpoint record". Sounds like backup_label

Re: pldbgapi extension

Prakash Ramakrishnan writes: > Not able to create the extension pldbgapi in cluster and if i run make and > make install it will going .sql file in /usr/share/pgsql/extension this > path but actually i need to create these files into below path, If you're building from source with intention to

Re: FW: Re: FW: Re: Shouldn;t this trigger be called?

On 9/17/19 2:31 AM, stan wrote: I am not certain what you mean by the check. As you can see, there is nor specific check clause. I was referring to the built in check of data being entered versus the legal values for the user defined type. Make sense? To be clear you are seeing an error

RE: max_connections parameter: too_many_connections error

1. How can we decide on optimal value for max_connections for a given setup/server? I checked many posts saying that even 1000 is considered as a very high value but we are hitting the error too_many_connections due to Max_connections value limit. I have one set at 1000 but I usually top out

max_connections parameter: too_many_connections error

*Hello*, We are working on a payments systems which uses postgreSql 9.6 as backend DB and blockchain technology. The database is setup in HA in master-standby mode using pacemaker on Linux 7.6. *We are new to postgres and ne*ed help in deciding how to set value for max_connections on DB. 1. How

Re: PostgreSQL License

Thank you all, but it is saying (without fee) if I create a database with it to work with Web Application if want to sell it so the buyer must have the PostgreSQL installed in his device to work offline right? "Permission to use, copy, modify, and distribute this software and its documentation for

Re: pgbackrest restore to new location?

On 9/17/19 7:23 AM, Luca Ferrari wrote: > On Tue, Sep 17, 2019 at 12:00 PM Ron wrote: >> The real problem is that after doing that, "pg_ctl start -D >> /path/to/new/data" fails with "PANIC: could not locate a valid checkpoint >> record". Sounds like backup_label is missing or has been deleted.

Re: pgbackrest restore to new location?

On Tue, Sep 17, 2019 at 12:00 PM Ron wrote: > The real problem is that after doing that, "pg_ctl start -D > /path/to/new/data" fails with "PANIC: could not locate a valid checkpoint > record". Hard to say what's going wrong without logs/configs. Do you have any other backup to try to restore

Re: pgbackrest restore to new location?

On 9/17/19 4:29 AM, Luca Ferrari wrote: On Tue, Sep 17, 2019 at 3:09 AM Ron wrote: Hi, In order to do this, do I create a new stanza in config file which has pg1-path point to the new/empty directory structure while still pointing to the existing backup directory, and restore that stanza?

Re: FW: Re: FW: Re: Shouldn;t this trigger be called?

On Mon, Sep 16, 2019 at 03:19:27PM -0700, Adrian Klaver wrote: > On 9/16/19 12:55 PM, stan wrote: > > > > On Mon, Sep 16, 2019 at 12:44:49PM -0700, Adrian Klaver wrote: > > > On 9/16/19 11:53 AM, stan wrote: > > > > On Sun, Sep 15, 2019 at 09:16:35PM -0700, Adrian Klaver wrote: > > > > > On

Re: pgbackrest restore to new location?

On Tue, Sep 17, 2019 at 3:09 AM Ron wrote: > > Hi, > > In order to do this, do I create a new stanza in config file which has > pg1-path point to the new/empty directory structure while still pointing to > the existing backup directory, and restore that stanza? No, I would do this: 1) execute

pldbgapi extension

Hi Team, Not able to create the extension pldbgapi in cluster and if i run make and make install it will going .sql file in /usr/share/pgsql/extension this path but actually i need to create these files into below path, How to create this one please advise ==> psql psql (11.5) Type "help" for