[GENERAL] Question on session_replication_role

Our set up: * Db version: postgres 9.3.4 * OS: CentOS 5.6 * kernel Version - Linux 2.6.18-238.19.1.el5 #1 SMP Fri Jul 15 07:31:24 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux * memory - 256 GB * We have slony replicating to this DB from the primary server *

[GENERAL] vacuum full post 9.0 - reindex needed?

I haven’t been able to find clear information online about what happens with existing indexes on a postgres post-9.0 database (we specifically use 9.3) after a vacuum full. There is a lot of information on how a vacuum differs from a vacuum full, but my question is – is a re-index needed after

Re: [GENERAL] Repeated semop calls

>Are there a lot of tuples in the table that have been inserted or updated by still-open transactions? Yes, there are likely to be inserts. That table is a log capture table used by our replication software, so essentially every update/delete/insert will have a record inserted into the table. It

Re: [GENERAL] Repeated semop calls

>1. disabling zone_reclaim (echo 0 > /proc/sys/vm/zone_reclaim_mode) > 2. disabling transparent hugepage support - this has various names on > different kernel/distributions, but "find /sys | grep -i > transparent.*hugepage.*enable" will find it, and then just echo never there. Thank you, yes,

[GENERAL] Repeated semop calls

Hi, We run postgres 9.3.3 on Centos 6.3, kernel 2.6.32-431.3.1. Every once in a while, we see postgres processes spinning on semop: Here is an output from an strace on a delete process: root@site-db01a:~ # strace -p 53744 Process 53744 attached - interrupt to quit semop(21692498, {{6, 1, 0}}, 1

Re: [GENERAL] Oracle to PostgreSQL replication

We use symmetricDS for this. Works pretty well. http://www.symmetricds.org/ From: Serge Fonville mailto:serge.fonvi...@gmail.com>> Date: Wednesday, May 7, 2014 at 2:49 AM To: Geoff Montee mailto:geoff.mon...@gmail.com>> Cc: Sameer Kumar mailto:sameer.ku...@ashnik.com>>, PostgreSQL General Discu

Re: [GENERAL] Increase in max_connections

size: 393215 MB node 1 free: 319 MB node distances: node 0 1 0: 10 20 1: 20 10 root@site-db01b:~ # cat /proc/sys/vm/zone_reclaim_mode 0 Thanks, Karthik On 3/26/14 1:54 PM, "Bruce Momjian" wrote: >On Wed, Mar 26, 2014 at 08:22:01PM +, Anand Kumar,

Re: [GENERAL] Increase in max_connections

arthik On 3/14/14 3:37 PM, "Anand Kumar, Karthik" wrote: >For anyone that's still following - we tried upgrading to postgres 9.3.3 - >that hasn't helped. > >Running an strace on the pid that was consuming the highest CPU at the >time of the outage shows: >

Re: [GENERAL] Increase in max_connections

blogspot.com/2012/06/perf-good-bad-ugly.html - will see what that has to show. Thanks, Karthik On 3/11/14 1:06 PM, "John R Pierce" wrote: >On 3/11/2014 10:20 AM, Anand Kumar, Karthik wrote: >> We typically see about 500-700 active queries at a time > >if these are prima

Re: [GENERAL] Increase in max_connections

down our applications (they maintain persistent connections once established, so any connection overhead slows them down), and with transaction level pooling, simply did not work. Thanks, Karthik From: Jeff Janes mailto:jeff.ja...@gmail.com>> Date: Tuesday, March 11, 2014 9:23 AM To: "

Re: [GENERAL] Increase in max_connections

ed on recommendations from posrgtes user groups, and via testing with setting it up and running explain analyze on queries. None of the settings have changed when this problem began. Thanks, Karthik From: Venkata Balaji Nagothi mailto:vbn...@gmail.com>> Date: Monday, March 10, 2014 7:35 PM To: &

[GENERAL] Increase in max_connections

Hi all, We're running postgres 9.3.2, server configuration below. Seemingly randomly, we will see the number of active queries in postgres go up until we hit max_connections. The DB will recover after a few minutes. We had the issue a couple of times in Feb 2014. We then upgraded the postgres

Re: [GENERAL] timezone change after upgrade from postgres 9.1 to 9.3?

Thank you. Its a 'yes' on 2 there. I did copy the config file from the 9.1 installation. Thank you for mentioning that, will fix it. Thanks, Karthik On 1/30/14 4:17 PM, "Tom Lane" wrote: >Adrian Klaver writes: >> On 01/30/2014 03:17 PM, Anand Kumar, Karthik wr

[GENERAL] timezone change after upgrade from postgres 9.1 to 9.3?

Hi, We just upgraded our postgres database from 9.1 to 9.3. And noticed that the timezone changed from PST to GMT. Is that known behavior? Has anyone else run into it, or am I just missing something? I've verified the server's timezone is right, and nothing in the postgres user's profile is ch

Re: [GENERAL] Sudden slow down and spike in system CPU causes max_connections to get exhausted

Thanks all for your suggestions. Looks like disabling transparent huge pages fixed this issue for us. We haven't had it occur in two days now after the change. Thanks, Karthik -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www

Re: [GENERAL] Sudden slow down and spike in system CPU causes max_connections to get exhausted

The reason we're on ext2 is to get around http://www.postgresql.org/message-id/CED87E13.C57E7%karthik.anandkumar@memo rylane.com We had pretty severe index and table corruption that would occur randomly - this was on ext3, and centos 5.6, 2.6.18 kernel. The problems got fixed after we upgraded th

[GENERAL] Sudden slow down and spike in system CPU causes max_connections to get exhausted

Hi, We run postgres 9.1.11, on Centos 6.3, and an ext2 filesystem Everything will run along okay, and every few hours, for about a couple of minutes, postgres will slow way down. A "select 1" query takes between 10 and 15 seconds to run, and the box in general gets lethargic. This causes a pil

Re: [GENERAL] Multi Master Replication

We use symmetricDS pretty extensively, across oracle and postgres databases. It has its flaws and its strengths. It shines when there's multiple database platforms involved, when the volume of transactions is not too high, and supports multi master. Its optimized for wan topologies, so its great if

Re: [GENERAL] index and table corruption

> >Thanks Shaun! > >Yes, we're getting synchronous_commit on right now. > >The log_min_duration was briefly set to 0 at the time I sent out the post, >just to see what statements were logged right before everything went to >hell. Didn't yield much since we very quickly realized we couldn't cope >wi

Re: [GENERAL] Best way to sync possibly corrupted data?

Thank you. pg_dump is what we will use. We did re-assign the LUN to a new system last night, and are monitoring. Too early to say anything, but so far, we haven't seen the corruption. And yes, we will get the dump from the new system. We do not have the hardware to move the backups to a differen

[GENERAL] Best way to sync possibly corrupted data?

HI, We have an issue with possibly corrupt data in our postgresql server. Errors like: ERROR: index "photos_p00_n2" contains unexpected zero page at block 0 ERROR: invalid page header in block 12707 of relation pg_tblspc/5020557/PG_9.1_201105231/16393/9014673 Thanks to all the suggestions fr

Re: [GENERAL] index and table corruption

Hi Jerry, Thanks for the suggestion Yes, until about a month ago, we weren't wrapping our snapshots with pg_start_backup and pg_stop_backup. Same reason as you mentioned, the database would start up and "trivial checks" would be okay, and so we figured "why write a script?". However we did chang

Re: [GENERAL] index and table corruption

Thanks Shaun! Yes, we're getting synchronous_commit on right now. The log_min_duration was briefly set to 0 at the time I sent out the post, just to see what statements were logged right before everything went to hell. Didn't yield much since we very quickly realized we couldn't cope with the vol

[GENERAL] index and table corruption

Hi, We're looking for help with possible corruption of our indexes and tables. Seemingly in the middle of normal operations, we will run into errors like the below: ERROR: index "mv_visits_p03_n2" contains unexpected zero page at block 15939 ERROR: invalid page header in block 344713 of relati

Re: [GENERAL] Donwload location for PostgreSQL version 8.2.7

ostgreSQL version 8.2.14? is any issues in upgrading PostgreSQL version 8.2.6 with PostgreSQL version 8.2.14? On Mon, Nov 9, 2009 at 5:03 PM, Arjen Nienhuis wrote: > On Mon, Nov 9, 2009 at 12:22 PM, Anand <1008an...@gmail.com> wrote: > > > > Hi, > > > > I tried to down

[GENERAL] Donwload location for PostgreSQL version 8.2.7

QL version 8.2.7. - Regards Anand

[GENERAL] Need Refrences

Hi All, Im looking for some case studies or reference sites or benchmarks for Solaris/Linux and Postgresql and application level benchmarks like JBOS/Tomcat with Postgres as backend. It would be great if anybody could help me. Regards Anand Kumar. begin:vcard fn:Anand Kumar M n:Meenakshi

Re: Bug#342369: [GENERAL] PostgreSQL 8.1.0 RHEL / Debian incompatible packages

?bug=342369 The bug has been closed on Peter's advice. Cheers, Anand -- `When any government, or any church for that matter, undertakes to say to its subjects, "This you may not read, this you must not see, this you are forbidden to know," the end result is tyranny and oppres

[GENERAL] PostgreSql replication with heterogeneous databases!

/daffodilreplica http://www.daffodildb.com/dbreplicator.html   Please revert back with your comments and queries. I would be glad to answer.   Regards Gaurav Anand  

[GENERAL] bolb data type

Hello, i have data in form of images which are in GB's, i need to store the extracted data from the images. This will required large fields size. I was thinking of Blob data type as we have in Oracle. Do we have blob data type in postgreSQL, if yes in which version. Thank's G

Re: [GENERAL] About multiple access to a table

hi all rows get implicitly locked.. hope this helps Anand On Fri, Jun 01, 2001 at 01:14:20PM +0200, Jose Manuel Lorenzo Lopez wrote: >Hello community, > >I have a doubt about multiple access to a table in my database. >When two people are accessing the same table for insert or upd

Re: [GENERAL] Specifying psql password on command line

preety simple.. In ur shell script use psql -h localhost ur_db -U ur_user_name and dropdb commands. It looks like there is no way to specify the password >on the command line. The password is always provided in the for

Re: [GENERAL] how can i change my table/column constraint

basically copy the table to some other table.. Drop the old table.. recreate it with the constraints changed Repopulate the table.. Hope this helps Anand On Sat, May 05, 2001 at 01:49:31PM +0700, Muhammad Rusydi wrote: >Hi, >if i have created this tables: >create table lab ( >kd_l

Re: [GENERAL] Schema Import

hi Bob, Try psql -h -U -f HTH Anand On Mon, Apr 16, 2001 at 12:36:06PM -0700, Bob McCormick wrote: >All, > >I've found a case tool that will generate a schema based on PostgreSQL >syntax and am wondering if it is possible to run this generated SQL script >to have

Re: [GENERAL] plpgsql -- arrays/temporary tables?

hi I think create likeddl statements fal under the category of dynamic queries which plpgsql in its native state cant handl.. Try using EXECUTE to execute this query Hope this helps Anand On Wed, Apr 11, 2001 at 12:25:43AM -0400, Steven D. Arnold wrote: >The following function doesn

Re: [GENERAL] transaction aborted with error

I dont think so .. Transactions need to be atomic.. Either succeed or fail.. I thik what postgressql does is quite OK only a little irritating if u are issuing command thru the psql terminal.. Anand On Thu, Mar 22, 2001 at 10:15:54AM +0100, DaVinci wrote: > Hello. I have a problem w

Re: [GENERAL] pg_dump not working..

Sorry for the noise on the list.. It turned out that the internet connectivity at our place balnked out for the few minutes when i was trying it out.. Sorry once again.. Anand On Fri, Mar 16, 2001 at 04:43:43PM +0530, Anand Raman wrote: >hi guys > >I am trying to use pg_dump to get a

Re: [GENERAL] Why SELECT OWNER.TABLENAME.COLUMNNAME not working ?

Hi I guess this is because postgresql doesnt yet support the concept of schemas. Such a select statement will make sense when the database supports schemas.. Hope this helps Anand On Mon, Mar 05, 2001 at 03:01:42PM +0600, Zuev Dmitry wrote: >Can anybody tell me why i can't specify OWNE

[GENERAL] pg_dump not working..

psql. Can anyone tell me what might be causing this.. Both the local and the remote database are postgresql 7.0.3 Thanks for ur help Anand ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Importing data only

If u dont want to recreate the db , u will have to atleast delete the data before moving on .. Try a delete * from and then import.. Thanks Anand On Wed, Mar 07, 2001 at 03:58:16PM +0100, Lisa Goulet wrote: >Hi, > >I've set up a secondary server and want to keep the db

Re: [GENERAL] COPY again...

ur feed is incorrect the entire csv file will be rejected without any reason being displayed.. U will have to sort this problems out by going thru samples of ur csv file.. Hope this is of some help Anand On Wed, Mar 07, 2001 at 03:34:24PM +0100, Tony Grant wrote: >Gets me every time this

Re: [GENERAL] Find out when a table was last changed ?

No u need to maintain this information in another column such as last_update_date which your application should update everyt time u perform any operation on it.. Hope this helps Anand On Wed, Feb 28, 2001 at 04:24:52AM +0100, Markus Fischer wrote: >Hi, > Is there some kind of comm

Re: [GENERAL] joining databases

Currently there is no way to acces more than one db at a time.. But i heard that there will be implementation of schema pretty soon.. Anand On Tue, Feb 27, 2001 at 06:09:03PM -0600, will trillich wrote: >how can i join separate DATABASES? > > select > a

Re: [GENERAL] strange query results

iced a few fields had '' characters to signify '.. This was creating problems in some jdbc queries. One changing them to single ' and reloading all the data, the problem simply disappered.. Thanks for the help Anand Raman On Tue, Feb 13, 2001 at 10:20:53AM -0500, Tom La

Re: [GENERAL] Tuple is to big

hi Endre U can go upto 32 k on 7.0.x and there is no such limit on 7.1 Try to upgrade.. Regards Anand On Tue, Feb 13, 2001 at 04:11:59PM -0500, Bodoni Endre wrote: >I have a little trouble with my PostgreSQL 6.5.1. I use a table with >text character type. >When I try to insert ab

Re: [GENERAL] Case insensitive selects?

Hi use it if u absolutly need it.. Using a function on a column name doesnt use the index associated with that column,.. So exercise this option with some amount of thinking.. Anand On Wed, Feb 14, 2001 at 11:39:47AM -0500, Adam Lang wrote: >It is in the list archives several times. > &g

Re: [GENERAL] jdbc connection pool settings

it depends on what kind of concurrent connections u will be getting.. For admin interfaces the kind of settingu mentioned might be OK but in case it is a heavily loaded site then u need to think.. Anand On Mon, Feb 12, 2001 at 02:55:08PM -0800, Culley Harrelson wrote: >I'm in the pr

Re: [GENERAL] strange query results

count(*) from exhibit_distributions group by site_section; NOTICE: QUERY PLAN: Aggregate (cost=69.83..74.83 rows=100 width=12) -> Group (cost=69.83..72.33 rows=1000 width=12) -> Sort (cost=69.83..69.83 rows=1000 width=12) -> Seq Scan

[GENERAL] strange query results

nt out the mistake. This is proving to be a show stopper .. We arent able to select rows for a particular site_section.. Thanks for your response Anand

[GENERAL] backend closing connections while executing...

_char(exh_dist.length,'D99')) from exhibit_distributions exh_dist the backend closes abnormally.. Can any help me out of this .. Thanks Anand

[GENERAL] Re: backend closing connections while executing...

20:23:33 2001 The Data Base System is starting up What is status 139 and how can i avoid it.. Thanks for any help Anand On Thu, Jan 25, 2001 at 01:06:01AM +0530, Anand Raman wrote: >hi guys > >While executing a simple query my the psql session reports that the >session has close

Re: [GENERAL] \copy not importing in 702... (SOLVED)

hi guys I just realized that this is occuring because of a the absence of a primary key in the other table. Thus the copy command exited without any failure notice.. Thanx Anand On Wed, Jan 24, 2001 at 12:29:18AM +0530, Anand Raman wrote: >hi guys > >I am having a strange problem w

[GENERAL] \copy not importing in 702...

ow) arttoday=# select version(); version - PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66 (1 row) ANy help will be appreciated.. Thanx Anand

Re: [GENERAL] Newbie question

what do u mean by the datadir problem.. if pg_ctl asks for a datadir then ucan set it in /etc/profile and start again.. Hope this helps Anand On Mon, Jan 08, 2001 at 03:44:34PM +0100, MUMCU, Burak wrote: > >Hi all, > >I'm using Suse Linux 7.0 and I have installed PostgreSQL. The

[GENERAL] pg_dump return status..

spin which continues even when pg_dump is not able to connect .. Is there anyway around this. I thought of one way was to check stderr for the occurence of the word "failed" and then exit.. Ur suggestions are most welcome version postgresql 702 Regards Anand Raman

[GENERAL] \connect

hi guys how to connect as a different user to a different db using the \connect command.. I dont see any option for specifing the password or the host to which i want to connect . Am i missing something.. Thanx for any suggestions Anand

[GENERAL] connecting in shell scripts ??

elect current_timestamp" < passwdfile where passwdfile has the passwd for the connection This isnt working.. I am a little confused for the same thing worked for pg_dump.. Looking forward for ur suggestions.. I am on 7.0.3 Thanx Anand Raman

[GENERAL] replacing a word..

uld be seen by indexer as Spain's Davis Cup hero Juan Carlos Ferrero has withdrawn Is it possible.. I tried using translate() and the ~ operator to no avail.. Could some please shed some light on this.. Thanx Anand Raman

Re: [GENERAL] How I can join between the other database's tables?

hi all, I second this opnion.. Coming from a web development environment, it could help us to distribute load on our servers.. regards Anand On Thu, Dec 28, 2000 at 08:21:26AM -0500, Adam Rossi wrote: >On Wednesday 27 December 2000 08:44 pm, Adam Haberlach wrote: > >> I'

Re: [GENERAL] Max sessions question

hi tim the answer is very much there try out man postmaster.. To increase the number of backends use the -N option. Hope this helps Anand On Fri, Dec 22, 2000 at 11:37:24AM -0800, Tim Barnard wrote: >Hello all, >I've looked through the docs and I can't find any answers to this q

Re: [GENERAL] COPY doesnt work on views

hi If getting the output of the query is all u want then u can spol the output of the query to a file.. I think it is done using \o .. Hope this helps Annad On Tue, Dec 12, 2000 at 04:36:10PM +, Steve Heaven wrote: >The COPY TO filename doesnt seem to work. >Copying a table works OK.

[GENERAL] Postgresql equivalent for nvl

Hi guys Sorry for hitting the button soon but whats the postgresql equivalent for Oracle's nvl(). I tried using ifnull() but then postgresql is cribbing that the function doesnt exist.. Thanx for the help Anand

Re: [GENERAL] date format problem

helps Anand Raman - Original Message - From: Bill Barnes <[EMAIL PROTECTED]> To: Anand Raman <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, May 03, 2000 1:51 PM Subject: RE: [GENERAL] date format problem > Hello Anand: > > Thanks for the input. >

Re: [GENERAL] date format problem

HI bill Try to cast the field to the datetime type 'ur_string_goes_here'::datetime Hope this will help Anand Raman - Original Message - From: Bill Barnes <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 28, 2000 6:09 PM Subject: [GENERAL] date fo

Re: [GENERAL] postgresql7.0 jdbc driver

ror 2 same is the case with $ make jdbc2 Thanx for the assitance Anand Raman - Original Message - From: Bruce Momjian <[EMAIL PROTECTED]> To: Anand Raman <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, May 02, 2000 6:49 PM Subject: Re: [GENERAL] postgresql7.0

[GENERAL] Enumerated data type

HI guys Is there anything equivalent to the enumerated data types in postgresql.. Thanx for ur help Anand Raman

[GENERAL] Pg.pm for Windows?

How can I use Pg.pm in my perl scripts running on Windows through ActivePerl? Some of my developers are refusing to work on Linux machines for just writing perl scripts :-). Thanks, Anand.

Re: [GENERAL] Re: where is the "applied"?

which can be used to create a patch, if it work with the new version. -- Anand Bruce Momjian wrote: > No idea why it isn't in there. Let me know what I should apply. > > > Hi Kai, > > > > It beats me too. I was under the impression that the patch was applied for >

[GENERAL] Re: where is the "applied"?

g it but I haven't tested it for V6.5. -- Anand. kai qu wrote: > hi, Anand, > > why I can not find it in the source code in V6.5? isn't it applied? Am I > missing something ? > > Kai > > ## > From: Bruce Momjian

[GENERAL] How to increase shared memory buffers?

o, (I know this should be asked on a Linux group, but...), does anybody know how can I get my Linux system to allow Postgres more shared memory? Thanks, Anand.

[GENERAL] Postgres on Sun Solaris 2.5.1

compiler has been used to test the port of Postgres on Solaris 2.x. Or to reword it : Can I use GCC to compile Postgres on Solaris? Sorry for being verbose, Thanks, Anand.

[GENERAL] SPI

aster : fatal: relocation error: symbol not found: SPI_result: referenced in /bytek/po stgres/postgresql-6.4.2/src/test/regress/input/../../../../contrib/spi/refint.so Has the SPI interface been changed? Thanks for your help in advance, - Anand Surelia

[GENERAL] Regression test failing on Sparc Solaris 2.5.1

k/postgres/lib/plpgsql.so Did I miss something? I had set the PGLIB varialble and gone ahead and set the LD_LIBRARY_PATH to the same value also. No luck. Thanks, Anand Surelia.

[GENERAL] Deadlock on Linux

e any idea what is happening? The script in question runs fine when I run it independent of the cron. Thanks for your help in advance, Anand Surelia.

[GENERAL] Sub Query

where session.sessionid=administration.sessionid) Doesn't Postgres support sub queries in delete statement? - Anand.

No Subject

Hi, I am getting a PQExec error when I run this query. delete from a where age('now

[GENERAL] Timestamp

Hi , Can anyone tell me how to add a constant time interval ( say 30 seconds ) to a timestamp field and convert the result back to a valid timestamp? Thanks, Anand

[GENERAL] SPI and Libpq

Hi, Can anyone tell me what is the difference between the SPI and the Libpq interfaces and when to use what? I am writing some functions that will be used by triggers. What interface should I use to implement those functions? Thanks, Anand

[GENERAL] Foreign Keys: check_primary_function

RE * check_primary_key ('Fkey1', 'Fkey2', 'Ptable', 'Pkey1', 'Pkey2', '[automatic|dependent]'). */ I am attaching the new ../contrib/spi/refint.c file which will do this. I will be glad to help in case of any problems. - Anand. /* * re

[GENERAL] Re:Foreign Keys

s before if the option is "dependent". If anybody is interested I might polish the code a bit and post to the list. Thanks, Anand.

[GENERAL] Foreign Key

rule' I want to implement? If there is none then I may have to hack the code of check_primary_key to do it. Is there someone who can help me do it faster? Thanks, Anand

[GENERAL] Check constraint

t backend closed the channel before r esponding. This probably means the backend terminated abnormally before or while pr ocessing the request. Could someone please explain what is going on? Do the Check constraints do not take functions? Thanks, Anand

[GENERAL] Database Connect Permission

Hi, Is there any way to specify connect permissions to a database for specific users? Right now, any user can connect to any database even though he may not be able to see any tables. Thanks, Anand Surelia.