Re: [GENERAL] Export binary data - PostgreSQL 9.2

ould be to export the binary data for a table? >>> >>> I was unable to find it... >>> >>> Thanks >>> >> >> > > Have just used the COPY WITH Binary > > Thank you. > -- Thanks & Regards, Abdul Sayeed PostgreSQL DBA Postgres Professional Certified EnterpriseDB Corp Skype: abdul.sayeed24

Re: [GENERAL] PostgreSQL DB Replication

postgres=# If the above workaround does not work, please share what error you are getting. Hope this helps…. Thanks & Regards, Abdul Sayeed PostgreSQL DBA Postgres Professional Certified EnterpriseDB Corp Skype: abdul.sayeed24 On Tue, Aug 26, 2014 at 11:29 AM, K P Manoj wrote: > Hi Rajesh,

Re: [GENERAL] Postgresql not getting assigned memory

t; that postgresql could reach until 2GB of server memory as total, correct? > Thanks beforehand. > > Cheers... > > > > > 2014-06-20 13:54 GMT+01:00 Abdul Sayeed : > > Hi, >> >> Can you please check the output of below command: >> >> postgres=# sh

Re: [GENERAL] Postgresql not getting assigned memory

Hi, Can you please check the output of below command: postgres=# show shared_buffers ; Thanks & Regards, Abdul Sayeed System Engineer The Postgres Database Company Are you updated: Latest version of Postgres Plus Advanced Server are 8.4.19.42, 9.0.16.34, 9.1.12.20, 9.2.8.19 and 9.3.

Re: [GENERAL] Exact Patch Version

Hi Bruce, Thank you for the information. Best Regards, Abdul Sayeed DBA - EnterpriseDB Skype: abdul.sayeed24 On Sat, Jan 25, 2014 at 9:44 AM, Bruce Momjian wrote: > On Sat, Jan 25, 2014 at 05:02:23AM +0530, Abdul Sayeed wrote: > > Hi All, > > > > Could any one pleas

[GENERAL] Exact Patch Version

Hi All, Could any one please confirm me in which community version "Fix multiple bugs in index page locking during hot-standby WAL replay" has been fixed. Your response in appreciated. Warm Regards, Abdul Sayeed DBA - EnterpriseDB Skype: abdul.sayeed24

Re: [GENERAL] How to list and describe tables in psql???

abdul | test | table | postgres | 16 kB | (1 row) Hope this helps. Thanks & Regards, Abdul Sayeed System Engineer The Postgres Database Company Are you updated: Latest version of Postgres Plus Advanced Server are 8.4.19.42, 9.0.15.33, 9.1.11.19, 9.2.6.16, 9.3.2.5. To reach Support Call:

Re: [GENERAL] How to find out unused indexes?

Hi, Below query can be handy to find unused indexes. select indexrelname from pg_stat_user_indexes where idx_scan = 0 and idx_tup_read = 0 and idx_tup_fetch = 0 ; Hope it helps. Thanks & Regards, Abdul Sayeed EnterpriseDB Corporation - RDBA Team The Postgres Database Company Office: +1

Re: [GENERAL] You cannot do PITR with streaming replication - true?

Thanks Magnus for the really fast response. Your inputs have helped removed my doubts. I now went back and checked my slave server and the WALs files are being shipped and the streaming replication is also working. I will try a PITR test this weekend... I have set wal_keep_segments to 3 but mayb

[GENERAL] You cannot do PITR with streaming replication - true?

pping) instead of streaming replication because streaming replication is like RAID as Bruce Momjian says. Is that a correct conclusion? Or is it that I am missing something here? Is it an issue with walmgr3 rather than PostgreSQL? Thanks in advance. Regards, sayeed -- View this messa