- Postgres Rocks
- :
- About sandeepkandhway
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
About sandeepkandhway
since
09-01-2017
02-27-2018
sandeepkandhway
Adventurer
15
Posts
0
Kudos
0
Solutions
02-27-2018
10:24 AM
Is SQL profiler available for Postgres 9.1. Our server is not under EDB's support. I mean to say is there sql profiler or similar software available for Postgres 9.1 Thanks, Sandeep
... View more
02-27-2018
10:22 AM
Is SQL profiler available for Postgres 9.1. Our server is not under EDB's support, but it's open-souce. Thanks, Sandeep
... View more
11-18-2017
12:37 AM
Hi Team, We're facing issues with loading data on the database. With BULK COMMIT the operation is getting terminated after 2-3 hours informing not able to connect tp database. Hence we're doing row lovel commits with 25 parallel threads (RAM=83G, CPU=14, shared_buffer=21G, work_mem = 15MB maintenance_work_mem = 4275MB effective_cache_size = 65GB) We've 1 primary and 1 synchronous standby in our system. With 25 parallel thread the dataload is happening fine for first 2 hours and we're able to see 10+ lakh records getting inserted nicely, and post that the data load activity is getting slowed down.with only 50k-1 lacs records inserting . Thanks, Sandeep Can anyone help on this.
... View more
Labels:
10-12-2017
01:22 PM
I'm getting the below error message when trying to install BART on my system: [root@edb newfolder]# yum install edb-bart20 Loaded plugins: product-id, refresh-packagekit, security, subscription-manager This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register. Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package edb-bart20.x86_64 0:2.0.0-1.rhel6 will be installed --> Processing Dependency: libboost_timer-mt.so.1.48.0()(64bit) for package: edb-bart20-2.0.0-1.rhel6.x86_64 --> Processing Dependency: libboost_thread-mt.so.1.48.0()(64bit) for package: edb-bart20-2.0.0-1.rhel6.x86_64 --> Processing Dependency: libboost_system-mt.so.1.48.0()(64bit) for package: edb-bart20-2.0.0-1.rhel6.x86_64 --> Processing Dependency: libboost_serialization-mt.so.1.48.0()(64bit) for package: edb-bart20-2.0.0-1.rhel6.x86_64 --> Processing Dependency: libboost_iostreams-mt.so.1.48.0()(64bit) for package: edb-bart20-2.0.0-1.rhel6.x86_64 --> Processing Dependency: libboost_filesystem-mt.so.1.48.0()(64bit) for package: edb-bart20-2.0.0-1.rhel6.x86_64 --> Processing Dependency: libboost_chrono-mt.so.1.48.0()(64bit) for package: edb-bart20-2.0.0-1.rhel6.x86_64 --> Finished Dependency Resolution Error: Package: edb-bart20-2.0.0-1.rhel6.x86_64 (enterprisedb-tools) Requires: libboost_timer-mt.so.1.48.0()(64bit) Error: Package: edb-bart20-2.0.0-1.rhel6.x86_64 (enterprisedb-tools) Requires: libboost_filesystem-mt.so.1.48.0()(64bit) Error: Package: edb-bart20-2.0.0-1.rhel6.x86_64 (enterprisedb-tools) Requires: libboost_system-mt.so.1.48.0()(64bit) Error: Package: edb-bart20-2.0.0-1.rhel6.x86_64 (enterprisedb-tools) Requires: libboost_thread-mt.so.1.48.0()(64bit) Error: Package: edb-bart20-2.0.0-1.rhel6.x86_64 (enterprisedb-tools) Requires: libboost_chrono-mt.so.1.48.0()(64bit) Error: Package: edb-bart20-2.0.0-1.rhel6.x86_64 (enterprisedb-tools) Requires: libboost_iostreams-mt.so.1.48.0()(64bit) Error: Package: edb-bart20-2.0.0-1.rhel6.x86_64 (enterprisedb-tools) Requires: libboost_serialization-mt.so.1.48.0()(64bit) You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest [root@edb newfolder]# Where can I get these dependent RPMs. When I'm installing one of them from google, it's again coming with another set of dependent RPMs. [edbas96] name=EnterpriseDB Advanced Server 9.6 $releasever - $basearch baseurl=http://***-us:d*****@yum.enterprisedb.com/9.6/redhat/rhel-$releasever-$basearch enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/ENTERPRISEDB-GPG-KEY [ppas95] name=Postgres Plus Advanced Server 9.5 $releasever - $basearch baseurl=http:// *** -us:d***** @yum.enterprisedb.com/9.5/redhat/rhel-$releasever-$basearch enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/ENTERPRISEDB-GPG-KEY [enterprisedb-dependencies] name=EnterpriseDB Dependencies $releasever - $basearch baseurl=http:// *** -us:d***** @yum.enterprisedb.com/dependencies/redhat/rhel-$releasever-$basearch enabled=1 gpgcheck=1. YUM is configured properly for EDB. Can you please help me here. Thanks, Sandeep
... View more
09-20-2017
06:43 AM
This is because right now the data is on default tablespace. And this needs to be moved on a different USER defined tablespace.
... View more
09-20-2017
06:14 AM
It will be on the same mount point. Any other way to do so.. Downtime is affordable right now
... View more
09-15-2017
11:34 AM
Any updates from anyone?
... View more
09-14-2017
02:58 AM
Hi, Can anyone please help on how to schedule a daily CRON backup (via BART) in our Postgres PRODUCTION server. 2 types of backup will be running. i. Daily Incremental backup. ii.Weekly Full backup. Thanks, Sandeep
... View more
Labels:
09-14-2017
02:28 AM
Hi, I want to move all the tables of that schema to a new tablespace. How can that be possible.?? Also it's a PROD server hence can you also tell the restoration mechanism if the activity fails. Thanks, Sandeep
... View more
09-12-2017
07:21 AM
Hi Team, I just checked that our application data is lying on the default tablespace it seems and I need to migrate the data to a different user-defined tablespace: edb=# select schemaname,tablename,tableowner,tablespace from pg_tables where schemaname like 'eoc' limit 20; schemaname | tablename | tableowner | tablespace ------------+----------------------------+------------+------------ eoc | cw_counter | eoc | eoc | cw_counter_definition | eoc | eoc | cwpworklistnotes | eoc | eoc | cwpworklistnotesarchive | eoc | eoc | cwcart | eoc | eoc | cwglobalprocess | eoc | eoc | cwpactivity0 | eoc | edb=# SELECT spcname FROM pg_tablespace; spcname ------------ pg_default pg_global (2 rows) edb=# show default_tablespace ; default_tablespace -------------------- (1 row) What is the best possible method available in Postgres for this migration. We should be losing any piece of data since its PROD. Thanks, Sandeep
... View more
Labels:
09-04-2017
08:27 AM
I got an issue on the PEM server: psql connection was asking for password everytime. I changed the connectivity to "TRUST" for all servers and databases in pg_hba.conf file but after that also same issue. So I did: alter role postgres password ''; and now not able to connect to psql at all.Can anyone please help on this. After this I need to add database nodes to PEM. Thanks, Sandeep
... View more
09-04-2017
08:13 AM
Sure Amit.. I'll reply by tomorrow on this explaining the things in details. One thing how to get notification in this forum when someone comments on my posts/questions? Thanks, Sandeep
... View more
09-01-2017
09:04 AM
Hi Team, I have done the PEM installation but not able to configure client on the DB server which can communicate to PEM and get monitored. Can anyone help on this. Thanks, Sandeep
... View more
Labels:
09-01-2017
08:41 AM
i. What is the minimum requirement for running Witness node. ii. Can it run on the same node on which an application server is running. Is this possibility available instead on running this on a dedicated server?
... View more
Latest Tags
No tags yet