On 10/24/2011 06:38 PM, Merlin Moncure wrote:
On Mon, Oct 24, 2011 at 3:22 AM, Manoj K P wrote:
Postgres recovered from data folder , after that some queries shows error
select * from table2 order by app_id ; - its work ( 5000 data)
select * from table2 order by app_id desc ; - its
Hi,
As we know that "pg_stat_statements" will monitor the queries after
normalizing the queries(Removes the values present in query). I want to
know is there a way to store those normalized values because I want to
check the type of data(values) ,range of data that is being hit to the
databas
Is there a way to reload shared_preload_libraries with out restarting the
server??
I tried alter system command in postgres 9.4 but I could not change it..
Hi,
I use Postgres 9.4 database.Now,I am optimizing the queries by using
the results of "explain" and "explain analyze",Sometimes I am creating
Indexes to optimize them. But, I was not successful sometimes as even I
create Index to optimize them, the planner is not using them .
So my question
tion goes wrong/bust?
Please suggest.
Kind Regards,
Manoj Agarwal
Tomcat.
Which tutorial, may help me in this regard.
thanks and Regards
--
Manoj , India
(1) and still
NOT able to fully commit the transactions. Statements that are executed after
(3) are not seeing this problem.
B. How do I make these statements timeout faster than stuck forever.
statement_timeout config param is not helping here.
any help is much appreciated.
thanks,
Manoj
ssues with them. Is there a way to restore the database from SQL_ASCII to
UTF-8? Is there a way to restore the database as SQL_ASCII and then convert
the Encoding to UTF-8? What is the consistency level? Or are there chances
of getting garbage?
Kind Regards,
Manoj Agarwal
Hi,
The encoding that is used by the clients that supplied data to the database
is ISO-8859-1.
Kind Regards,
Manoj Agarwal
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Wednesday, June 06, 2012 6:43 PM
To: Manoj Agarwal
Cc: pgsql-general@postgresql.org
Perl module. After installing the module, I used the
following command to restore SQL_ASCII database to UTF-8:
pg_restore -O db_dump_sql_ascii | fix_latin | psql -d db_utf
The conversion was done successfully without any errors. The database was
restored as UTF-8.
Kind Regards,
Manoj Agarwal
DB to know its status slave or master
?? So, that i can issue write statements only after I know that the DB
is the new master now
-- Or anyway to make pg_ctl promote to wait till the slave is completely
promoted ?
Any help is appreciated.
--
thanks,
Manoj
--
Sent via pgsql-gener
awesome. thanks for the help. Will test it out.
thanks,
Manoj
On 07/20/2012 06:57 PM, Chris Angelico wrote:
On Sat, Jul 21, 2012 at 5:28 AM, Manoj Govindassamy
wrote:
-- Anyway I can query the state of DB to know its status slave or master ??
So, that i can issue write statements only
x27;pg_restore' commands. Any help will be highly appreciated.
Kind Regards,
Manoj Agarwal
abase in a
cluster, but as a whole, is it possible?
Kind Regards,
Manoj Agarwal
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Thursday, August 02, 2012 2:18 AM
To: Manoj Agarwal; pgsql-general@postgresql.org
Subject: Re: [GENERAL] File system le
/initdb
Reason: image not found
Trace/BPT trap
Any ideas? This is on Mac OS 10.5.4. What I see in /usr/local/pgsql/
lib is libpq.5.dylib and not libpq.4.dylib.
Thanks!
Manoj Patwardhan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Thanks guys!
Yes, 8.3.3 binaries got installed in /usr/local/pgsql/bin and so the
7.3 version that I had previously didn't get overwritten. Binaries for
7.3 were in /usr/local/bin
Works now.
Regards,
Manoj Patwardhan
On Aug 3, 2008, at 12:17 AM, Tom Lane wrote:
John DeSoi &l
ness ? tcp connection timeouts, replication timeouts
all detect the failures, but i want to run some corrective action on
these failure detection.
--
thanks,
Manoj
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgres
any help on this is much appreciated.
thanks,
Manoj
On 01/11/2012 01:50 PM, Manoj Govindassamy wrote:
Hi,
I have a PG 9.1.2 Master <--> Slave with synchronous replication
setup. They are all working fine as expected. I do have a case where I
want to flip Master to non replicatio
anyone with PG Synchronous Replication knowledge, please help me with
your views on the below questions.
thanks,
Manoj
On 01/12/2012 10:12 AM, Manoj Govindassamy wrote:
any help on this is much appreciated.
thanks,
Manoj
On 01/11/2012 01:50 PM, Manoj Govindassamy wrote:
Hi,
I have a
mechanism for master in PG9.1.2 ? We are using C interface for
PG. Any kind of health checking that we can do on the master to detect
the hot-standby problem and let master reload its config with empty
synchronous_standby_names ?
Any help is much appreciated.
thanks,
Manoj
On 01/16/2012 07:44
ways to detect Master PG's replication not working (via libpq would
be more preferable).
thanks,
Manoj
On 01/17/2012 05:04 PM, Fujii Masao wrote:
On Wed, Jan 18, 2012 at 6:37 AM, Manoj Govindassamy
wrote:
(2) We are not comfortable moving to PGPool just for automatic failback mode
on hot-s
Hi,
I have the following requirements, and I want to do them without shutting
down postgres. Any help appreciated.
1. Get a list of connections to the postgres server
2. Disconnect some/all connections from postgres
3. I modified the pg_hba.conf to block a particular user from connecting to
that user (that was already opened, and is being
pooled) doesn't get rejected.
Is (b) the expected behavior? How do I force existing connections from the user
to be dropped without restarting db?
thanks
Manoj
___
It would be good if u can give text of the view and table structure of
the two tables.
Some of the things u can do is.
VACCUM and ANALYZE tables;
Create index on coulmn specified in where clause of the query.
Manoj
claudia wrote:
Hi, I developing a program using postgres and linux like
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
wrote:
> Hi Rajesh
>
> Please share the below information:
>
> 1)postg
( 5000 data)
select * from table2 order by id desc ; - shows following error
manoj[local] postgres ERROR: index "tbl2_id_pkey" contains unexpected zero
page at block 311121
manoj [local] postgres HINT: Please REINDEX it.
index "tbl2_id_pkey" is primary key
Reindex not pratica
*Server log*
Oct 1 00:06:59 server_host_name postgres[1453]: [5-1] 2011-10-01
00:06:59.831 EDT 1453 4e869041.5ad postgres [local] postgres LOG: duration:
418583.238 ms statement: select pg_start_backup('fortnightly');
Oct 2 03:03:18 server_host_name postgres[1453]: [6-1] 2011-10-02
03:03:18.2
27 matches
Mail list logo
