About saurabhs

saurabhs

Question Can a cluster be deployed in private subnets within a VPC? Answer Yes. There are different offerings available as cloud solutions by EnterpriseDB. A Managed DBaaS deployment will allow you to use a private subnet within a VPC.

saurabhs

Question Is it possible to migrate data online to CDS? Answer Yes. It’s possible to migrate your data online from an on-prem or existing cloud database to CDS directly using logical replication or by using EDB Postgres Replication Server(EPRS) .

saurabhs

Question How do I request a new region? Answer CDS support is available for the listed region consoles in CDS. If you are looking for a new region to run your workloads please send an email to cds-help@enterprisedb.com with your use case and we will make every effort to deliver on your request.

saurabhs

Question How do I retain long term backups? Answer A user can retain a backup forever. Cloud Database Service (CDS) takes automatic backups of your cluster depending upon the retention period you have set for the cluster. However, you can always take a manual snapshot of the cluster and it will be retained for as long as you want. Retention policies do not apply to manually created backups and the backups will never be deleted even when a user terminates the cluster. To retain a cluster backup for long term please follow the steps below. A. Login to CDS console where the cluster is running, select the cluster name and click on ‘Backup’ icon. B. Provide a unique name as a tag and click ‘Backup’ icon. C. Once the backup is successfully completed, you will be able to see the backup under the Backups tab.

saurabhs

Hi seandon4, Thank you for raising the concerns with us. To proceed further could you please confirm on below points. 1. Query execution is on Partition Table or Plain Table? 2. Could you please share the Explain Plan for the reported query. (i.e with and without hardcoded values)

saurabhs · ‎07-21-2019

Hi mitchelcarlsen, Thank you for raising the concern with us. Please share the logs so we can analyze the issue further. Log Location: POSTGRES_HOME\.enterprisedb\xdb\x.x\mtk.log Note: POSTGRES_HOME is the home directory of the "Postgres" operating system account OR "enterprisedb" for EDB Advanced Server Installation.

saurabhs · ‎06-13-2019

Hi jsoler, Please find an explanation for the statement. If any transaction gets aborted, the transaction clean up won't occur properly, hence it stops the mainline code from completing the functionality. So, the fixed is provided to protect again above explained scenario in cases where it ought to return to the mainline code, but allow it where there's an interruptible process happening. The timeout can cause such scenarios (statement_timeout). Also, this might also be caused by lock_timeout. Hope this clarifies the raised concerns.

saurabhs · ‎06-04-2019

Hi jwoodsford , By looking at your reported query, there might be multiple reasons which can slow down the database performance. Also, as per mentioned by "alexc168", I/O could be one of the reasons for slowness. However, we would recommend the generic area from the troubleshooting point of view. Monitor the disk I/O as mentioned by "alexc168". Execute the statements in transaction batches. (i.e BEGIN.....COMMIT) Verify there is no blocking issue with parallel UPDATE statements. wal_buffers, checkpoint, bg_writer are tuned enough. If possible replace "INSERT" with "COPY" as it increases the performance. - Refer the following link for the usage of "COPY" statement. https://www.postgresql.org/docs/10/populate.html 6. Network latency. Hope this helps.

saurabhs · ‎05-24-2019

Hi sheila1372, There are no existing statistics table or view which maintains this information on the database. Following are the ways from which you can achieve this : Logging : Setting the logging parameters which will collect the details into the database logs : i. logging_collector -- This will enable logging ii. log_line_prefix -- What all to log iii. log_statement -- Which statements to log Note: This change will cause extra logging. Please make sure adequate disk space is available. Creating Triggers : i. Create an audit table to maintain such records. ii. Create a function which will collect the user name for the respective operation and will insert it into the audit table. iii. Create a trigger on the audit table which will invoke the function created above for DML operations. Note: Please test the trigger creation method is on test environment prior to applying on production, as it might cause the slowness for complex queries.

saurabhs · ‎11-03-2018

Hi davejung, Thank you for reporting the issue with us. We are working on it and we will udpate you soon. Meanwhile, c ould you please confirm on the pgpool version.

saurabhs · ‎08-18-2018

Hi gdedeoglu, Thank you for raising the concern. We will update you soon on the reported issue.

saurabhs · ‎07-30-2018

Hi Moin, PostgreSQL Function would be wise call for your requirement. Function can have below path to drop the child partition table with respective to the provided Master table and retention policy. And then you can call the function by setting it in the crontab. 1. Function should select the child tables with respective to the provided Master table. 2. Soon after receiving child table list. Un-bound the child table depends on the retention policy. (ex. 7 days) 3. And then drop the table after validating the data if it is old enough. Note: Also, we would suggest to test this test case in your Test enviornment, before, trying it on the Prod. Hope this helps.

saurabhs · ‎07-26-2018

Hi Tom, Thank you for your time and patience. As per documentation under supported platforms, EFM-3.1 is compatible with SLES12. However, the builds are not yet available. The documentation and the release information will be updated once the builds are ready. Please let us know in case of any issues/queries.

saurabhs · ‎07-19-2018

Hi Akash, The exception you have received is due to invalid value has been provided for the parameter "SSL Mode". The valid values for the "SSL Mode" parmeter is "Require,Prefer, Disable". Also, find the below link for the reference: http://www.npgsql.org/doc/connection-string-parameters.html Can you please try it once with the above options and let us know if you face the issue again.

saurabhs · ‎07-08-2018

Hi erik , There is no such default password for user Postgres. The password needs to be set. Please find below details: 1. Login to the machine where PostgreSQL is installed. Use below command from terminal to connect to the cluster. psql -U postgres - If the PATH is not set, above command will give an error. Below is the default PATH for PostgreSQL binaries. /Applications/Postgres.app/Contents/Versions/latest/bin/ 2. After successful login use below command to set the password: ALTER ROLE postgres PASSWORD 'postgres'; Hope this helps.

saurabhs · ‎07-06-2018

Hi l gwapnitsky, Using VIP In this case will be wise decision. The VIP remains active on Master and moves on to the Slave in case of failover. Hope this helps.

About saurabhs

Can a cluster be deployed in private subnets withi...

Is it possible to migrate data online to CDS?

How to request a new region?

How do I retain long term backups?

Re: Simple Query with DBLink - Performance Questio...

Re: xDB Replication Server 6.2.5 - Lost entire su...

Re: Cause of error [SQL STATE: XX000]PANIC: stuck ...

Re: large postgresql database becomes sluggish aft...

Re: How can I make the modified by columns for obj...

Re: pgpool load balance issue black_function_list ...

Re: Integration with Oracle Business Intelligence ...

Re: Automating table partition

Re: Is EFM 3.1 supported in SuSe Linux 12?

Re: How to enable SSL for PostgreSQL running on Wi...

Re: Default password for postgres user?

Re: BART and failover