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
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
, 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
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
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,
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;
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
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
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:
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
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
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
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
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
Hello team,
We have a postgres11.2 on docker and we are migrating a kb_rep database from
postgres 9.6 to postgres 11.2 via pg_dump/pg_restore
We have created a kb_rep schema in postgres 11.2 also but during pg_restore
there is an error "pg_restore: [archiver (db)] connection to database "kb_rep"
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
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
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
Hi team,
We have enabled the monitoring to monitor the vacuuming of tables via
check_postgres_last_vacuum plugin but we are getting the below warning message.
Notification Type: PROBLEM
Service: PostgreSQL last vacuum ()
Host Alias: vmshowcasedb2.vpc.prod.scl1.us.tribalfusion.net
Address: 10.26.
Hi team,
I need your help to resolve an issue psql: fe_sendauth: no password supplied
which we are getting by nagios plugin , we are trying to monitor the disk space
and via .pgpass for an authentication.
[root@viicinga-02 ~]#
/mnt/common/local/linux/local/bin/check_postgres/check_postgres_di
Dear Experts,
Kndly help to resolve the issue reported during startup pgadmin4 server mode on
ubuntu 16.04
dram@vipgadmin:~$ cd .pgadmin4
dram@vipgadmin:~/.pgadmin4$ chmod +x
lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
dram@vipgadmin:~/.pgadmin4$ chmod
lib/python2.7/site-packages/pg
Hello team,
I need help how & what we can monitor the Postgres database via Nagios.
I came to know about the check_postgres.pl script but we are using free ware
option of postgres. If its Ok with freeware then please let me know the steps
how I can implement in our environment.
Regards,
Daul
Hello experts,
We have the following requirements in single query or any proper solution.
Please help on this.
How many sessions are currently opened.
-and if opened then how many queries have executed on that session.
-and also we have to trace how much time each query is taking.
-and also
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
'/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
< 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
Hi team,
We are facing the below issue while logging with postgres as given below:
[centos@ip-192-90-2-208 ~]$ su - postgres
Password:
Last login: Thu Nov 23 16:15:45 UTC 2017 on pts/1
-bash-4.2$ psql
psql: could not connect to server: No such file or directory
Is the server running local
27 matches
Mail list logo
