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 /etc/init.d/p
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*
Se
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 .
&g
Hi All,
I am using pgbackrest on my production workloads and it is working as
expected.
However our DB is growing more and more .
We have currently two disks and each one is 4 TB size. However 3.8TB size
data got loaded into DB currently and our /pgback mount point size is 4TB.
So if the DB size
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
/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
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 f
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
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
>
> ------
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 sof
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
to suggest 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
>
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:
Hi All,
Please suggest Schema/Data conversion opensource tools from MySQL to
PostgreSQL.
Thanks,
Chiranjeevi
Greetings,
Please respond to my PgBackrest questions,if any one tested.
On Wed, Mar 14, 2018 at 10:54 PM, chiru r wrote:
> Hi Stephen,
>
> Thank you very much for your quick reply.
>
>
> On Wed, Mar 14, 2018 at 6:17 PM, Stephen Frost wrote:
>
>> Greetings,
>>
Hi Stephen,
Thank you very much for your quick reply.
On Wed, Mar 14, 2018 at 6:17 PM, Stephen Frost wrote:
> Greetings,
>
> * chiru r (chir...@gmail.com) wrote:
> > I am testing Pgbackrest and I have few questions.
>
> Great!
>
> > 1. I used postures user to per
Hi,
I am testing Pgbackrest and I have few questions.
please help if any one has tested these cases.
1. I used postures user to perform backups and restores with Pgbackrest
tool.
The Trust authentication in pg_hba.conf file is working without issues.
If I use md5 authentication in pg_hba_conf f
Thank you.
On Tue, Feb 13, 2018 at 3:31 AM, Laurenz Albe
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)
> oracle_fdw on all DB servers,we want to
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
a
Thank you very much David and Stephen for your quick reply.
On Fri, Dec 29, 2017 at 1:55 PM, David Steele wrote:
> On 12/29/17 1:53 PM, Stephen Frost wrote:
> > Greetings,
> >
> > * David Steele (da...@pgmasters.net) wrote:
> >> On 12/28/17 6:15 PM, chiru r wrote:
Can you please help on below pgbackrest restoration issue.
On Thu, Dec 28, 2017 at 6:15 PM, chiru r wrote:
>
> I am unable to copy the complete backup.manifest file due to security
> reasons . please find the below contents.
>
> [backup:db]
> db-catalog-version=201510051
&g
--+-++---
-
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|
db3 |
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 and suggest me,if any one has the
me know if anything missing in my test case ?
*Note *: if I restore the db2, whicich is associated with pg_default
tablespace it is working.
pgbackrest --stanza=online_backups --delta --db-include=db2 restore
Thanks,
Chiru
On Mon, Dec 18, 2017 at 9:20 AM, David Steele wrote:
> On 12
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
Please help me on below recovery scenario, if any one is using pgBackRest.
On Fri, Dec 15, 2017 at 4:36 PM, chiru r wrote:
> Hi All,
>
> Thanks,I am thinking about a specific recovery case.
>
> Lets assume Heavy transactional system we configured.
> It is generating WAL 200
pgbackrest keeps track of transactions since the last backup? Where it
stores transaction information for recovery ?.
Thanks,
Chiru
On Wed, Dec 13, 2017 at 5:45 PM, Stephen Frost wrote:
> Greetings,
>
> * chiru r (chir...@gmail.com) wrote:
> > The pgbackrest.conf configurati
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
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 locati
29 matches
Mail list logo
