pg_dump backup verification

Hi Team, Please suggest how I can ensure pg_dump backup has completed successfully ? I don't think there is any view like Oracle which helps with dba_datampump_jobs etc. Thanks,

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

Thanks Patrick , From: Patrick FICHE Sent: Friday, February 21, 2020 9:54 PM To: Daulat Ram ; amul sul Cc: pgsql-performance@lists.postgresql.org Subject: RE: Can we have multiple tablespaces with in a database. Hi, You can create more than one tablespace and assign different objects on

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-gene...@lists.postgresql.org; pgsql-performance@lists.postgresql.org Subject

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

, February 21, 2020 11:48 AM To: Daulat Ram Cc: pgsql-gene...@lists.postgresql.org; pgsql-performance@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-gene...@lists.postgresql.org; pgsql-performance@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,

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-gene...@lists.postgresql.org;

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: 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-gene...@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: 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-performance@lists.pos

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

thought this was the cause. But, I have set LongReadLen, on the db handle, equal to 9000. Thanks, Daulat

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

Max_connections limit

mit integer 0 license_max_sessions integer 0 license_sessions_warning integer 0 sessions integer 3024 shared_server_sessions integer SQL> Regards, Daulat

Backup and Restore (pg_dump & pg_restore)

Error from TOC entry 3; 2615 2200 SCHEMA public postgres pg_restore: [archiver (db)] could not execute query: ERROR: schema "public" already exists Command was: CREATE SCHEMA public; Please advise. Regards, Daulat

Postgres backup & restore

:/$ pg_restore -h 10.29.50.21 -p 5432 -d kb_rep -v /var/lib/kb_rep_backup16 pg_restore: connecting to database for restore Password: pg_restore: [archiver (db)] connection to database "kb_rep" failed: FATAL: database "kb_rep" does not exist postgres@b06a42b503e9:/$ Please help on this issue. Regards, Daulat

PostgreSQL upgrade.

Hello team. We have two node postgresql database version 9.6 with streaming replication which is running on docker environment, os Linux (Ubuntu) and we have to migrate on PostgresQL11. I need your suggestions & steps to compete the upgrade process successfully. Regards, Daulat

Oracle to postgres migration

Hi team, Please confirm ! Can we migrate Oracle 12c database (12.1.0.1.0) running on Solaris to PostgreSQL 11.2 on Linux (Ubuntu). Also, please suggest the tools and pre-requisites. Regards, Daulat

Shared_buffers

Hi team, I want to know about the working and importance of shared_buffers in Postgresql? is it similar to the oracle database buffer cache? Regards, Daulat

No matching tables have ever been vacuumed

: 10.26.12.89 State: UNKNOWN Info: POSTGRES_LAST_VACUUM UNKNOWN: DB postgres (host:vmshowcasedb2.vpc.prod.scl1.us.tribalfusion.net) No matching tables have ever been vacuumed Kindly suggest how we can overcome on this. Regards, Daulat

psql: fe_sendauth: no password supplied

/check_postgres_disk_space.sh -H vikbcn-db2.vpc.prod.scl1.us.tribalfusion.net -f /var/spool/icinga/.pgpass_stby -w '60' -c '70' Connection to vikbcn-db2.vpc.prod.scl1.us.tribalfusion.net 5432 port [tcp/postgres] succeeded! psql: fe_sendauth: no password supplied Regards, Daulat

Please help

/CHDIR Mar 05 23:57:24 vipgadmin systemd[1]: pgadmin4.service: Unit entered failed state. Mar 05 23:57:24 vipgadmin systemd[1]: pgadmin4.service: Failed with result 'exit-code'. Regards, Daulat

check_postgres via Nagios

lt;http://check_postgres.pl/> via Nagios. Regards, Daulat

Please help

ards, Daulat

Performance

also we have to find the cost of each query. Regards, Daulat

RE: Re: Re: Re: Issue with postgres login

plication postgres::1/128 ident Plz suggest Regards, Daulat From: Bob Strecansky [mailto:b...@mailchimp.com] Sent: 24 November, 2017 9:56 AM To: Daulat Ram Cc: pgsql-performa...@postgresql.org Subject: [EXTERNAL]Re: Re: Re: Issue with postgres login It appears our file permission

RE: Re: Re: Issue with postgres login

'/tmp' unix_socket_group = '' unix_socket_permissions = 0777 Regards, Daulat From: Bob Strecansky [mailto:b...@mailchimp.com] Sent: 24 November, 2017 9:37 AM To: Daulat Ram Cc: pgsql-performa...@postgresql.org Subject: [EXTERNAL]Re: Re: Issue with postgres login It appears the p

RE: Re: Issue with postgres login

< 2017-11-24 04:00:40.780 UTC >DETAIL: Permissions should be u=rwx (0700). For more details please refer to trail mail Regards, Daulat From: Bob Strecansky [mailto:b...@mailchimp.com] Sent: 24 November, 2017 9:07 AM To: Daulat Ram Cc: pgsql-performa...@postgresql.org Subject: [EXTERNAL]R

Issue with postgres login

locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? -bash-4.2$ OS: Centos AWS environment Regards, Daulat DISCLAIMER: This email message is for the sole use of the intended recipient(s) and may contain confidential and