Hi Rajesh,
Parameter hot_standby is on on slave server ?. You are trying to change
postgres password on master or slave ?.
Regards
Manoj K P
8050972028
On Tue, Aug 26, 2014 at 10:15 AM, sivananda reddy nanda.op...@gmail.com
wrote:
Hi Rajesh
Please share the below information:
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 psql
On Sat, Aug 23, 2014 at 2:18 AM, Joseph Kregloh jkreg...@sproutloud.com
wrote:
On Fri, Aug 22, 2014 at 2:21 PM, Jerry Sievers gsiever...@comcast.net
wrote:
Joseph Kregloh jkreg...@sproutloud.com writes:
Hi,
Currently I am doing asynchronous replication from master to
slave. Now if
On Tue, Aug 26, 2014 at 3:11 PM, Ramesh T rameshparnandit...@gmail.com
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
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 not. So
On Tue, Aug 26, 2014 at 5:43 AM, Raghu Ram raghuchenn...@gmail.com wrote:
On Tue, Aug 26, 2014 at 3:11 PM, Ramesh T rameshparnandit...@gmail.com
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:
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
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;
But this
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
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
Larry White ljw1...@gmail.com 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
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 t...@sss.pgh.pa.us wrote:
Larry White ljw1...@gmail.com writes:
Logically, what I want is to be able to make queries
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 raghuchenn...@gmail.com wrote:
On Fri, Aug 22, 2014 at 4:40 PM, Ramesh T
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.
On Tue, Aug 26, 2014 at 5:44 PM, Keith Fiske ke...@omniti.com 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
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
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
On Aug 26, 2014, at 3:08 PM, Arze, Cesar ca...@som.umaryland.edu 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
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.
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.commailto:st...@blighty.com) wrote:
On Aug 26, 2014,
-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
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
Quote
I've figured out, have to apply a separate patch to query out of nested
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
My mistake, the host OS is RHEL 5.9
On August 26, 2014 at 11:09:35 PM, John R Pierce
(pie...@hogranch.commailto: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 if I
24 matches
Mail list logo