Point in time recovery

Hello Team, I want to know the best way to ensure/verify that the Point in time recovery has done successfully after the crash and the restore. Thanks,

core. files inside base directory

Hello, I have the core. Files inside the base directory of my postgres 10 setup . Would you please let me know the importance of these files . When they generate . Can we delete them ? /base/ du -sh * 24M base 8.1Gcore.26166 1.5Gcore.26258 8.1Gcore.27849 12M core.27951 4.3G

RE: Real application clustering in postgres.

switchover method for Dataguard. How we can do in Postgres. Thanks, -Original Message- From: Laurenz Albe Sent: Thursday, March 5, 2020 5:37 PM To: Daulat Ram ; pgsql-general@lists.postgresql.org Subject: Re: Real application clustering in postgres. On Thu, 2020-03-05 at 07:45 +

Real application clustering in postgres.

Hi team, Is there any possibility/options to setup a real application clustering in Postgres as in Oracle we have a RAC feature. What about multi-master replication in Postgres. would you please suggest how it is useful and how can setup it. Thanks.

how to find a tablespace for the table?

Hi team, how to find a tablespace for the table? See my comments below: I have created a database with default tablespace like below: edb=# CREATE DATABASE conndb WITH TABLESPACE = conn_s_tables; After that I have created a table CREATE TABLE COMPANY_new( ID INT PRIMARY KEY NOT NULL, N

RE: Can we have multiple tablespaces with in a database.

: Daulat Ram Cc: amul sul ; pgsql-general@lists.postgresql.org Subject: Re: Can we have multiple tablespaces with in a database. > On Feb 20, 2020, at 22:34, Daulat Ram wrote: > > You mean we can have only single default tablespace for a database but the > database objects can b

RE: Can we have multiple tablespaces with in a database.

You mean we can have only single default tablespace for a database but the database objects can be created on different-2 tablespaces? From: amul sul Sent: Friday, February 21, 2020 11:48 AM To: Daulat Ram Cc: pgsql-general@lists.postgresql.org; pgsql-performa...@lists.postgresql.org Subject

RE: Can we have multiple tablespaces with in a database.

, February 21, 2020 11:57 AM To: Daulat Ram Cc: amul sul ; pgsql-general@lists.postgresql.org Subject: Re: Can we have multiple tablespaces with in a database. > On Feb 20, 2020, at 22:23, Daulat Ram wrote: > > That will be great if you share any doc where it’s mentioned that we can

RE: Can we have multiple tablespaces with in a database.

, February 21, 2020 11:48 AM To: Daulat Ram Cc: pgsql-general@lists.postgresql.org; pgsql-performa...@lists.postgresql.org Subject: Re: Can we have multiple tablespaces with in a database. On Fri, Feb 21, 2020 at 11:31 AM Daulat Ram mailto:daulat@exponential.com>> wrote: Hi Amul , Please sha

RE: Can we have multiple tablespaces with in a database.

abase test tablespace ‘conn_tbs'; Can we have multiple tablespaces with in a database in postgres? Yes. From: amul sul Sent: Friday, February 21, 2020 11:16 AM To: Daulat Ram Cc: pgsql-general@lists.postgresql.org; pgsql-performa...@lists.postgresql.org Subject: Re: Can we have multi

Can we have multiple tablespaces with in a database.

Hi Team, Can we have multiple tablespaces with in a database in postgres? Can we have a table on different tablespace same as Oracle? Thanks,

Setting up an environment of EDB Advance server

Hi team, We would need your help in setting up an environment of EDB Advance Server 11 on Dev CentOS 7 VM. 1. We need to create three database with separate table spaces : Test1 Test2 Test3 What would be the good strategy for the setup with regards to the tablespaces? Can we create a separ

Postgres streaming replication

Hello team, I have to implement the streaming replication for our prod environment. Can you please share the list of parameters to setup the PostgreSQL 11 streaming replication with continuous archiving and give clarity on the below. * Do we need to enable the archive_mode and archive_comma

Re: pg_basebackup

thanks Adrian, what about the postmaster.opts file, this file was also skipped in backup. We have single cluster running on the VM. Thanks. On 22-Dec-2019 11:19 PM, Adrian Klaver wrote: On 12/22/19 1:56 AM, Daulat Ram wrote: > Hello, > > I am taking pg_basebackup of primary d

pg_basebackup

Hello, I am taking pg_basebackup of primary db (docker container env.) using the below command : pg_basebackup -x -h vmzti -U replication -D /etc/postgresql/9.5/main/pg_basebkp/basekp1224 -Ft -z -P Password: WARNING: skipping special file "./postgresql.conf" WARNING: skipping special file "./

Access privileges

Hello, Can you please describe the " =Tc/postgres + postgres=CTc/postgres +confluence=CTc/postgres". I want to give the same permissions to the different user on a new database. List of databases Name| Owner | Encoding | Collate | Ctype |Access

How to Change collate & ctype for an existing database?

Hi, How we can change the Collate & Ctype from "c" to "C.UTF-8" on existing production database. SELECT datcollate FROM pg_database WHERE datname='wwkidbt'; datcollate C postgres=# select version(); version ---

RE: Postgres Point in time Recovery (PITR),

=== Password: Thanks, -Original Message- From: Andreas Kretschmer Sent: Friday, October 18, 2019 12:38 PM To: pgsql-general@lists.postgresql.org; Daulat Ram ; pgsql-general@lists.postgresql.org Subject: Re: Postgres Point in time Recovery (PITR), On

RE: Barman

Thanks Tomas for your inputs. Suppose, if we have database in TB's with OLTP applications then what will be suitable backup strategy. -Original Message- From: Tomas Vondra Sent: Friday, November 1, 2019 12:27 AM To: Daulat Ram Cc: pgsql-general@lists.postgresql.org; pgsql-per

Barman

Hi All, We have configured postgres 11.2 in streaming replication (primary & Standby) on docker and I am looking to initiate the Postgres backup using barman. As I know there are few options for taking backup using barman. RSYNC backup Incremental Backups Streaming Backup with continuous WAL s

RE: Postgres Point in time Recovery (PITR),

Kumar Sent: Friday, October 18, 2019 5:28 PM To: David Steele Cc: Luca Ferrari ; Andreas Joseph Krogh ; Daulat Ram ; pgsql-general@lists.postgresql.org Subject: Re: Postgres Point in time Recovery (PITR), Hi Daulat, PITR entirely depends on what type of backups you choose. Sometimes, to reduce

Postgres Point in time Recovery (PITR),

Hello All, Can you please share some ideas and scenarios how we can do the PITR in case of disaster. Thanks,

RE: Monitor Postgres database status on Docker

res: count --- 7 Give me suggestions. Thanks, From: Daulat Ram Sent: Tuesday, September 24, 2019 3:35 PM To: Fan Liu ; pgsql-general@lists.postgresql.org Subject: RE: Monitor Postgres database status on Docker Thanks but how we can use it for docker container. Regards, Daulat Fro

RE: Monitor Postgres database status on Docker

Thanks but how we can use it for docker container. Regards, Daulat From: Fan Liu Sent: Tuesday, September 24, 2019 3:02 PM To: Daulat Ram ; pgsql-general@lists.postgresql.org Subject: RE: Monitor Postgres database status on Docker Hi, I am not from PostgreSQL team. Just let you know that when

Monitor Postgres database status on Docker

Hi team, We want to check the postgres database status on docker container just like we monitor Postgres (up / down) via /etc/init.d/postgresql status But I am not sure how we can do that with docker. Thanks, Daulat

Exporting and importing table having blob datatype.

Hello Team, We have a large table having blob data type. Anyone please suggest how we can export it from Oracle DB in parts via ora2pg and then import it into postgres. Thanks, Daulat

RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg

Oracle NLS_NCHAR WE8MSWIN1252 Oracle NLS_TIMESTAMP_FORMAT -MM-DD HH24:MI:SS.FF6 Oracle NLS_DATE_FORMAT -MM-DD HH24:MI:SS PostgreSQL CLIENT_ENCODING WIN1252 bash-4.2$ thanks -Original Message- From: Adrian Klaver Sent: Tuesday, August 13, 2019 11:27 PM To:

RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg

ESTAMP(6) FLOAT CLOB NUMBER CHAR DATE VARCHAR2 BLOB SQL> We are getting the same issue for tables which are having blob, clob and char data types. Thanks, Daulat -Original Message- From: Luca Ferrari Sent: Tuesday, August 13, 2019 8:32 PM To: Daulat Ram Cc: pgsql-performa...@lists.pos

ORA-24345: A Truncation or null fetch error occurred -ora2pg

Hi team , I am getting the below error while fetching the data from Oracle 12c using ora2pg. DBD::Oracle::st fetchall_arrayref failed: ORA-24345: A Truncation or null fetch error occurred (DBD SUCCESS_WITH_INFO: OCIStmtFetch, LongReadLen too small and/or LongTruncOk not set)ERROR no statement e

Oracle to postgres migration via ora2pg (blob data)

Hello team, We have to migrate a schema from oracle to postgres but there is one table that is having following large lob segments. This table is taking time to export. What parameters we have to set in ora2pg.conf to speed up the data export by ora2pg. Table:CLIENT_DB_AUDIT_LOG LOBSEGME

RE: Memory settings

214501 | 99.34 kbbm | 1944006 | 157383222 | 98.78 Thanks, Daulat From: Hans Schou mailto:hans.sc...@gmail.com>> Sent: Sunday, June 30, 2019 11:35 AM To: Daulat Ram mailto:daulat@exponential.com>> Cc: pgsql-general@lists.postgresql.org<mailto:pgsql-general@list

Memory settings

Hi team, Can you please suggest what will be the suitable memory settings for Postgresql11 if we have 80gb RAM, 16 CPU's and OS Linux. If we set 25 % of total RAM then shared_buffers value will be 20GB. Will it be useful or we can set it any random vale like 8g or 12gb. According to https://

Memory settings

Can you please suggest what will be the suitable memory settings for Postgresql11 if we have 80gb RAM, 16 CPU's and OS Linux. If we set 25 % of total RAM then shared_buffers value will be 20GB. Will it be useful or we can set it any random vale like 8g or 12gb. According to https://pgtune.leo

Max_connections limit

Hello team, We have migrated our database from Oracle 12c to Postgres 11. I need your suggestions , we have sessions limit in Oracle = 3024 . Do we need to set the same connection limit in Postgres as well. How we can decide the max_connections limit for postgres. Are there any differences in

How can generate alter sequence and drop constraints statements via ora2pg

Hi All, Any one can give me an idea how we can generate the alter sequence and drop constraints scripts /statements for a schema tables using ora2pg.conf Regards, Daulat

How to connect to toad Edge with postgresql running with docker container?

Hello team, Please suggest how to connect to toad Edge with postgresql running with docker container. Regards, Daulat

Cause: org.postgresql.util.PSQLException: ERROR: could not resize shared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No space left on device

Hello team, I'm getting below error while accessing postgres11 database. Please suggest the solution for this issue. Cause: org.postgresql.util.PSQLException: ERROR: could not resize shared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No space left on device at com.caucho.el

no matching entries in passwd file

Hello team, I have database & users created inside the docker but we are getting connection issue while trying to connect to database using user created in postgres. docker exec -it -u test b8e7ejb1e31d bash unable to find user test: no matching entries in passwd file Regards, Daulat

FATAL: SMgrRelation hashtable corrupted

Hello team I need your help on this issue. My Postgres 11.2 container is not started due to the below error message. It is in streaming replication environment. 2019-05-17 06:41:08.989 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2019-05-17 06:41:09.093 UTC [11] L

bigint out of range

Hello team , We are getting ERROR: bigint out of range. Please help on this. ERROR: bigint out of range kbdb=# INSERT INTO kb_dar_ran_url_check (url_hash,stat_date,topic_id,site_id,url,status,user_comments,review_comments) VALUES (72894677781133866997924561390146294513,E'19-04-2019',32793,

RE: CREATE EXTENSION to load the language into the database

Daulat -Original Message- From: Adrian Klaver Sent: Friday, May 3, 2019 10:21 PM To: Daulat Ram ; pgsql-general@lists.postgresql.org Subject: Re: CREATE EXTENSION to load the language into the database On 5/3/19 8:56 AM, Daulat Ram wrote: > Hello team, > > We are getting below

CREATE EXTENSION to load the language into the database

Hello team, We are getting below issue while creating a function in Potsgres 11.2 nagios=# create or replace function diskf (filesystem text, warn int, err int) returns text as $BODY$ nagios$# use warnings; nagios$# use strict; nagios$# my $fs = $_[0]; nagios$# my $w = $_[1]; nagios$# my $e = $

ERROR: operator does not exist: timestamp without time zone + integer

Hi team, We are getting an ERROR: "operator does not exist: timestamp without time zone + integer " while creating table in postgres. The same script is working fine in Oracle, I know there are some changes in postgres but I am unable to identify . Please suggest how we can create it successfu

How to execute .sql file inside a postgres schema

Hello team, I have a database name "kbdb" that is having a schema "kb" and I want to execute the test.sql file inside this schema, Please help how we can do that. Regards, Daulat

Streaming Replication

Hello Team, I am setting a streaming replication by using two different host there is no output of select * from pg_stat_replication; I have set the parameters on both side. Host names are : (10.29.15.244) (10.29.15.25) postgres=# select * from pg_stat_replication; pid | usesysid | usename |

Backup and Restore (pg_dump & pg_restore)

Hello Team, We are getting below error while migrating pg_dump from Postgresql 9.6 to Postgresql 11.2 via pg_restore in docker environment. 90d4c9f363c8:~$ pg_restore -d kbcn "/var/lib/kbcn_backup19" pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from T