Re: [GENERAL] Postgres 9.1 issues running data directory from VMware shared folder

My mistake, the host OS is RHEL 5.9 On August 26, 2014 at 11:09:35 PM, John R Pierce (pie...@hogranch.com) wrote: On 8/26/2014 5:51 PM, Arze, Cesar wrote: > Thanks for the info, will look into what version of Workstation I am > running (think I have 9.0) and will see i

Re: [GENERAL] Postgres 9.1 issues running data directory from VMware shared folder

On 8/26/2014 5:51 PM, Arze, Cesar wrote: Thanks for the info, will look into what version of Workstation I am running (think I have 9.0) and will see if I can’t get an upgraded copy and see if it alleviates the issue. also, there's several years of patches since RHEL 5.4 was released, I think

Re: [GENERAL] how to query against nested hstore data type

On 08/26/2014 06:50 PM, Huang, Suya wrote: -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, August 26, 2014 11:58 PM To: Huang, Suya; pgsql-general@postgresql.org I've figured out, have to apply a separate patch to query out of nested hsto

Re: [GENERAL] how to query against nested hstore data type

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, August 26, 2014 11:58 PM To: Huang, Suya; pgsql-general@postgresql.org Subject: Re: [GENERAL] how to query against nested hstore data type On 08/25/2014 06:05 PM, Huang, Suya wrote: > -Original

Re: [GENERAL] Postgres 9.1 issues running data directory from VMware shared folder

Thanks for the info, will look into what version of Workstation I am running (think I have 9.0) and will see if I can’t get an upgraded copy and see if it alleviates the issue. On August 26, 2014 at 8:36:23 PM, Steve Atkins (st...@blighty.com) wrote: On Aug 26, 2014,

Re: [GENERAL] Postgres 9.1 issues running data directory from VMware shared folder

So what is the host OS? Where is the shared directory located, which OS? What file system is the directory located on? Host OS is Redhat 5.4 The shared directory is located on the host OS of Redhat 5.4 and is located on a local drive of the desktop. The directory is on an ext3 filesystem. Wh

Re: [GENERAL] Postgres 9.1 issues running data directory from VMware shared folder

On Aug 26, 2014, at 3:08 PM, Arze, Cesar wrote: > > I probably should be posting to the VMware mailing list with this question > but I wanted to see if anyone had any insight or suggestions here. I’ve seen > many similar issues but none of the solutions proposed there worked for me. This migh

Re: [GENERAL] Postgres 9.1 issues running data directory from VMware shared folder

On 08/26/2014 03:08 PM, Arze, Cesar wrote: Hi, I’ve recently encountered an issue running Postgres (both 8.4 and 9.1) on a VMware VM running Ubuntu 10.04 LTS as the guest OS with the data directory running out of a VMware shared folder. Previously on 8.4 this had worked out for me but after upgr

[GENERAL] Postgres 9.1 issues running data directory from VMware shared folder

Hi, I’ve recently encountered an issue running Postgres (both 8.4 and 9.1) on a VMware VM running Ubuntu 10.04 LTS as the guest OS with the data directory running out of a VMware shared folder. Previously on 8.4 this had worked out for me but after upgrading VMware and re-building my VM I’ve st

Re: [GENERAL] Bloat check query

On Tue, Aug 26, 2014 at 5:44 PM, Keith Fiske wrote: > So I recently wrote this script to help us in monitoring for table/index > bloat > > https://github.com/keithf4/pg_bloat_check > > I based my query off of the one contained in check_postgres, since I > thought it seemed fairly accurate with wh

[GENERAL] Bloat check query

So I recently wrote this script to help us in monitoring for table/index bloat https://github.com/keithf4/pg_bloat_check I based my query off of the one contained in check_postgres, since I thought it seemed fairly accurate with what I was expecting to get back. https://github.com/bucardo/check_

Re: [GENERAL] POWA tool

i downloaded But where i need to unzip powa-REL_1_1.zip i'm using putty tool remote server.. -bash-4.1$ unzip powa-REL_1_1.zip -bash: unzip: command not found On Tue, Aug 26, 2014 at 12:55 AM, Raghu Ram wrote: > > On Fri, Aug 22, 2014 at 4:40 PM, Ramesh T > wrote: > >> How to include pg_sta

Re: [GENERAL] indexed range queries on jsonb?

Thank you Tom, I made the necessary changes and Explain now shows that the query will use the index. Thanks again for your help. On Tue, Aug 26, 2014 at 10:33 AM, Tom Lane wrote: > Larry White writes: > > Logically, what I want is to be able to make queries like this: > > select * from doc

Re: [GENERAL] indexed range queries on jsonb?

Larry White writes: > Logically, what I want is to be able to make queries like this: > select * from document where ((payload->'intTest')) > 5; > With casting, I came up with: > select * from document where (((payload->'intTest'))::text)::integer > 5; > But this query does not use the index accor

Re: [GENERAL] how to query against nested hstore data type

On 08/25/2014 06:05 PM, Huang, Suya wrote: -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Monday, August 25, 2014 11:42 PM To: Huang, Suya; pgsql-general@postgresql.org Subject: Re: [GENERAL] how to query against nested hstore data type On 08/24/2014 07:0

Re: [GENERAL] PostgreSQL DB Replication

Hi Rajesh, I don't know what error you are getting. Though you can use below workaround to login and change the password. Step 1: Open pg_hba.conf file and modify md5 to trust Step 2: reload the cluster (/opt/PostgreSQL/9.2/bin/pg_ctl -D ../data/ reload) Step 3: Connect to the database, it shou

Re: [GENERAL] indexed range queries on jsonb?

On 8/26/14 3:30 PM, Larry White wrote: > > Logically, what I want is to be able to make queries like this: > > select * from document where ((payload->'intTest'))> 5; > > With casting, I came up with: > > select * from document where (((payload->'intTest'))::text)::integer > > 5;

[GENERAL] indexed range queries on jsonb?

Hi, I'm trying to find a way to do a range query on json such that it will use an index. This seems possible given that jsonb supports btrees and expression indices. For example I have: create index t1 on document using btree ((payload->'intTest')); where: payload is a jsonb column and intTest

Re: [GENERAL] POWA tool

On Tue, Aug 26, 2014 at 5:43 AM, Raghu Ram wrote: > On Tue, Aug 26, 2014 at 3:11 PM, Ramesh T > wrote: > >> i downloaded But where i need to unzip powa-REL_1_1.zip i'm using putty >> tool remote server.. >> >> >> -bash-4.1$ unzip powa-REL_1_1.zip >> -bash: unzip: command not found >> >> > You ne

Re: [GENERAL] Using fmgr_hook

Hello, > Try like this: > - connect with psql > - call your custom_fmgr_hook > - attach to the backend with gdb > - set the breakpoint > - call custom_fmgr_hook again I tried to check in a different way, by just using log statements to see if customs* hook functions ever get executed. They were no

Re: [GENERAL] POWA tool

On Tue, Aug 26, 2014 at 3:11 PM, Ramesh T wrote: > i downloaded But where i need to unzip powa-REL_1_1.zip i'm using putty > tool remote server.. > > > -bash-4.1$ unzip powa-REL_1_1.zip > -bash: unzip: command not found > > You need to Install "unzip" utility. Once you installed "unzip" utility,y

Re: [GENERAL] Restart replicated slave procedure

On Sat, Aug 23, 2014 at 2:18 AM, Joseph Kregloh wrote: > > > On Fri, Aug 22, 2014 at 2:21 PM, Jerry Sievers > wrote: > >> Joseph Kregloh writes: >> >> > Hi, >> > >> > Currently I am doing asynchronous replication from master to >> > slave. Now if I restart the slave it will fall out of sync wit

Re: [GENERAL] Using fmgr_hook

Sameer Thakur wrote: >> My experience is that you cannot set breakpoints before the library >> is loaded, so you first have to call a function in the library, then >> you interrupt and set the breakpoint. > I tried to do the following > 1. Execute Postgres (now auto_explain is loaded) > 2. Start a