Re: Two Postgres master process are showing - one is on and off

Thank you Adrian. Is the on/off on a regular interval? > My guess is a script(cron possibly) is trying to start the server. > > Yes, It is regular interval. No Con-jobs scheduled on server or even remotely. > > > We did not find any references in logs. > > The information: > > sudo

Two Postgres master process are showing - one is on and off

Hi All, I have observed one of our PostgreSQL DB instance showing two postgres process on Linux server as highlighted. The second postgres process is on and off. We did not find any references in logs. Please provide your advice and help on this issue. DB version : PostgreSQL *9.5.10*

Re: PGbackrest capacity related question

Thank you David. On Mon, Jul 22, 2019 at 6:44 PM David Steele wrote: > On 7/22/19 5:08 PM, chiru r wrote: > > Hi All, > > > > I am using pgbackrest on my production workloads and it is working as > > expected. > > However our DB is growing more and more

Re: Pgbackrest Comparability issue

On Thu, Feb 28, 2019 at 1:28 PM Adrian Klaver wrote: > On 2/28/19 10:06 AM, chiru r wrote: > > > > We are suing pgBackRest 1.24 version . > > > > Installing using rpms > > > > yum -y install perl-parent > > yum -y install perl-Time-HiRes > &g

Re: Pgbackrest Comparability issue

/28/19 6:59 AM, chiru r wrote: > > Hi All, > > > > I am using Pgbackrest and have an issue while upgrading our PostgreSQL > > 9.5.10 to PostgreSQL 10.4 version on same Physical linux server. > > As part of testing I have stop the PostgreSQL 9.5 database on server and &g

Pgbackrest Comparability issue

Hi All, I am using Pgbackrest and have an issue while upgrading our PostgreSQL 9.5.10 to PostgreSQL 10.4 version on same Physical linux server. As part of testing I have stop the PostgreSQL 9.5 database on server and PostgreSQL 10 is up and running and trying to configure and execute the backups

Re: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL

ble* [root@server1dev:/root/PG11]# Thanks, Chiranjeevi On Wed, Jan 2, 2019 at 1:25 PM Kevin Brannen wrote: > From: chiru r > > > I have installed Community PostgreSQL RPMs and are going into " > /usr/pgsql-11/" by default. > > Please let us know how to get th

Re: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL

upgrades to work as they expect, > without changing default paths or config files. > > Much as described here: > > https://help.cloud66.com/rails/how-to-guides/databases/shells/change-psql-directory.html > > > > Cheers, > > Brent Wood > > ------

Relocatable Binaries (RPMs) : custom installation path for PostgreSQL

Hi All, I wanted to install the PostgreSQL-11 Software with Custom installation/binary paths. Currently I am using EDB one click installer software with option file like below to achieve, However EDB stopped and no longer provides one click installer for Linux. *Example:* PostgreSQL install

custom installation path for PostgreSQL RPMs ( Relocatable Binaries )

Hi All, I wanted to install the PostgreSQL-11 Software with Custom installation and data directory path. Currently I am using EDB one click installer software with option file like below to achieve, However EDB stopped and no longer provides one click installer for Linux. *Example:* PostgreSQL

Re: Schema/Data conversion opensource tools from MySQL to PostgreSQL

a tool without knowing > exactly what is needed. > > Regards > Thomas > > > Le mar. 26 juin 2018 à 08:25, Arnaud L. a > écrit : > >> Le 25-06-18 à 18:47, chiru r a écrit : >> > Please suggest Schema/Data conversion opensource tools from MySQL to >> >

Re: Schema/Data conversion opensource tools from MySQL to PostgreSQL

Thank you All. On Mon, Jun 25, 2018 at 3:40 PM, Adrian Klaver wrote: > On 06/25/2018 09:47 AM, chiru r wrote: > >> Hi All, >> >> >> Please suggest Schema/Data conversion opensource tools from MySQL to >> PostgreSQL. >> >> > To add to the list:

Schema/Data conversion opensource tools from MySQL to PostgreSQL

Hi All, Please suggest Schema/Data conversion opensource tools from MySQL to PostgreSQL. Thanks, Chiranjeevi

Re: PgBackrest questions

Greetings, Please respond to my PgBackrest questions,if any one tested. On Wed, Mar 14, 2018 at 10:54 PM, chiru r <chir...@gmail.com> wrote: > Hi Stephen, > > Thank you very much for your quick reply. > > > On Wed, Mar 14, 2018 at 6:17 PM, Stephen Frost &l

Re: PgBackrest questions

Hi Stephen, Thank you very much for your quick reply. On Wed, Mar 14, 2018 at 6:17 PM, Stephen Frost <sfr...@snowman.net> wrote: > Greetings, > > * chiru r (chir...@gmail.com) wrote: > > I am testing Pgbackrest and I have few questions. > > Great! > > >

Re: oracle_fdw Question

Thank you. On Tue, Feb 13, 2018 at 3:31 AM, Laurenz Albe <laurenz.a...@cybertec.at> wrote: > chiru r wrote: > > I am trying to install and configure the oracle_fdw on PostgreSQL DB > servers. > > What we are trying is, inorder to install (make, make install) > orac

oracle_fdw Question

Hi, I am trying to install and configure the oracle_fdw on PostgreSQL DB servers. What we are trying is, inorder to install (make, make install) oracle_fdw on all DB servers,we want to compile on one server and want build a package/tar file to copy the library files and required SQL scripts into

Re: PgBackRest question?

Thank you very much David and Stephen for your quick reply. On Fri, Dec 29, 2017 at 1:55 PM, David Steele <da...@pgmasters.net> wrote: > On 12/29/17 1:53 PM, Stephen Frost wrote: > > Greetings, > > > > * David Steele (da...@pgmasters.net) wrote: > >> On 12/2

Re: PgBackRest question?

Can you please help on below pgbackrest restoration issue. On Thu, Dec 28, 2017 at 6:15 PM, chiru r <chir...@gmail.com> wrote: > > I am unable to copy the complete backup.manifest file due to security > reasons . please find the below contents. > > [backup:db] > db-catalo

Re: PgBackRest question?

--+-++--- - db1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | 7280 kB | report1| db2 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | 7280 kB | report1 | d

Re: PgBackRest question?

<da...@pgmasters.net> wrote: > On 12/28/17 3:38 PM, chiru r wrote: > >> Thank you for the details David and Stephen.. >> >> I am unable to recover the database which associated with user table >> space . >> >> Please see the below test case an

Re: PgBackRest question?

Thanks David for the replay. we are not interested to use replication/Standby configuration at this moment with pgbackrest. We are looking to restore the QA backups on Dev systems . Please help us if any blogs/documentations for remote databases recovery scenarios?. Thanks, Chiru

PgBackRest question?

Hi All, I am trying to understand the PgBackRest functionality for WAL files. The pgbackrest.conf configuration file has the option *repo-path* to mention the mount point to store the backups and wal archive files. We are looking for an option, Can we store online backups and wal archive files

Secured ldap connectivity between PostgreSQL and LDAPs server

Hi All, We are using LDAP authentication for authenticating users in PostgreSQL on Linux server and we are able to authenticate successfully. However we want to configure secured LDAP (LDAPS) by using Certificates. Please help me i have couple of questions to configuring LDAPS. 1. Which