Re: [GENERAL] Inheritance and foreign keys

On Thu, May 25, 2017 at 6:00 PM, Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > The way I do it is the following : > - ensure a common sequence for the ID for all tables in the inheritance > tree (usually one parent and one or more children) > - enforce normal FK constraints for all F

[GENERAL] Inheritance and foreign keys

); select * from myt; id 1 2 create table a (id integerreferences myt(id)); insert into a values(2); ERROR: insert or update on table "a" violates foreign key constraint "a_id_fkey" DETAIL: Key (id)=(2) is not present in table "myt". Regards, Jayadevan

Re: [GENERAL] truncate table getting blocked

dding this line fixed it ... conn.set_isolation_level(psycopg2.extensions.ISOLATION_LEVEL_AUTOCOMMIT) Reference - http://initd.org/psycopg/docs/faq.html Thanks, Jayadevan

[GENERAL] truncate table getting blocked

myschema.table1; | SET search_path TO myschema,public PG version : PostgreSQL 9.4.5 on x86_64-suse-linux-gnu, compiled by gcc (SUSE Linux) 4.8.5, 64-bit Thanks, Jayadevan

Re: [GENERAL] Partitioning and constraint exclusion

n on child1 (cost=0.00..40.00 rows=12 width=4) (actual time=0.000..0.000 rows=0 loops=1) Filter: (id = 1) * -> Seq Scan on child3 (cost=0.00..40.00 rows=12 width=4) (actual time=0.000..0.000 rows=0 loops=1)* * Filter: (id = 1)* Thanks, Jayadevan David J. > >

Re: [GENERAL] Partitioning and constraint exclusion

table with 2500+ values in the check constraint. I may be missing something? I tried changing the filter from myuid in (1,2,3) to myuid = 1 or myuid = 2 or It did not improve the plan. One Index Cond became 3 Index Cond . Thanks, Jayadevan

[GENERAL] Partitioning and constraint exclusion

used. But why doesn't the planner just use constraint exclusion and not go for the index scan? Anyone faced a similar issue? Thanks, Jayadevan

Re: [GENERAL] Streaming replication - slave not getting promoted

On Sun, Jan 4, 2015 at 8:01 PM, Adrian Klaver wrote: > On 01/04/2015 06:09 AM, Jayadevan M wrote: > >> Hi, >> I have streaming replication set up, with PostgreSQL 9.3. The entries in >> recovery.conf on the slave are as follows - >> standby_mode = 'on' &g

[GENERAL] Streaming replication - slave not getting promoted

hould NOT be located in the same directory as postgresql.conf " postgresql.conf is in $PGDATA. So they will be in the same directory? Regards, Jayadevan

[GENERAL] Query planning

, right? How many unique values are there in a column (cardinality), that is estimated while finding out selectivity? Regards, Jayadevan

Re: [GENERAL] Insert zero to auto increment serial column

Will a rule work? http://www.postgresql.org/docs/9.3/static/sql-createrule.html On Wed, Apr 2, 2014 at 5:47 PM, loc wrote: > I'm currently using an Informix Innovator-C database with Aubit4GL and I > would like to migrate to PostgreSQL, it looks like the transition will not > be too difficult,

[GENERAL] Doubts on startup costs

equal to or greater than the total cost of the inner nodes? (My guess is NO, there may be cases where the outer node can start processing before the inner node is completely done). Regards, Jayadevan

Re: [GENERAL] High Level Committers Wanted

On Sat, Mar 15, 2014 at 1:51 AM, Andy Colson wrote: > On 3/14/2014 6:08 AM, Antman, Jason (CMG-Atlanta) wrote: > >> I'm not a "high level committer", nor am I even a regular poster to this >> list. >> >> not saying this post is true, but... If I'm reading between the lines >> correctly, this coul

[GENERAL] table design and data type choice

vote_up =1) . Is it better to have data type of Boolean, varchar or int? I assume there isanother decision too - have 2 columns - one for up and one for down, or have just one column which will be 1 or -1. Regards, Jayadevan

Re: [GENERAL] authentication failure

I am able to login as postgres with password from the same machine. So it is not an expiry issue (as you too concluded). Output from strace is about 500 lines. I am pasting what I feel may be relevant. I hope this will be useful. execve("/usr/pgsql-9.3/bin/psql", ["psql", "-h", "localhost"], [/*

Re: [GENERAL] authentication failure

gpass $ env | grep PG PGPORT=1234 PGUSER=postgres PGHOST=localhost On Sun, Jan 5, 2014 at 9:03 PM, Adrian Klaver wrote: > On 01/04/2014 08:46 PM, Jayadevan M wrote: > >> Log entries for 3 situations - 2 successful and one failed attempt - >> >> From non-chroot, shell user

Re: [GENERAL] authentication failure

Sameer Kumar wrote > This only tells that there is one instance running! > > There could be multiple PostgreSQL installations. And I guess that is what > Tom meant here. I doubt that was what Tom meant. Anyway, we can see from the error that the request did reach the server. Sameer Kumar wrote

Re: [GENERAL] authentication failure

=[unknown] LOG: connection received: host=::1 port=47949 2014-01-05 10:12:51 IST [17052]: [2-1] user=postgres,db=postgres LOG: connection authorized: user=postgres database=postgres On Sat, Jan 4, 2014 at 8:43 PM, Adrian Klaver wrote: > On 01/03/2014 09:29 PM, Jayadevan M wrote: > >> T

Re: [GENERAL] authentication failure

st a minor inconvenience, but I would like to resolve this. The no password supplied message comes back so fast, it is as if it did not even attemp to connect. On Fri, Jan 3, 2014 at 8:37 PM, Tom Lane wrote: > Adrian Klaver writes: > > On 01/03/2014 04:54 AM, Jayadevan M wrote: > >>

Re: [GENERAL] authentication failure

:13 PM, Jayadevan M > wrote: > >> I am able to login from the non-chroot environment. So it is not an issue >> with pg_hba.conf and not an issue of password expiration. Is there a debug >> psql option? >> >> OK. > > Have you checked the PGPASSWORD environmen

Re: [GENERAL] authentication failure

I am able to login from the non-chroot environment. So it is not an issue with pg_hba.conf and not an issue of password expiration. Is there a debug psql option? On Fri, Jan 3, 2014 at 5:09 PM, Chris Curvey wrote: > > > > On Fri, Jan 3, 2014 at 4:16 AM, Jayadevan M > wrote: &

Re: [GENERAL] authentication failure

Nope - psql -W psql: FATAL: password authentication failed for user "postgres" On Fri, Jan 3, 2014 at 2:49 PM, Ashesh Vashi wrote: > Try "psql -W" for prompting the password forcefully. > > > On Fri, Jan 3, 2014 at 2:46 PM, Jayadevan M > wrote: > >&g

[GENERAL] authentication failure

running in the same server in the non-chroot environment. I am also running a python application which uses psycopg2 and that is working fine. Regards, Jayadevan

Re: [GENERAL] Refresh Materialized View

To answer my own question, I saw this thread - http://postgresql.1045698.n5.nabble.com/Efficiency-of-materialized-views-refresh-in-9-3-td5762618.html I think that does answer my questions. Nothing has changed? Regards, Jayadevan On Wed, Jan 1, 2014 at 6:42 PM, Jayadevan M wrote: > Hello

[GENERAL] Refresh Materialized View

? Does the refresh result in exclusive locking? Regards, Jayadevan

Re: [GENERAL] design for multiple time series

On Fri, Dec 13, 2013 at 12:15 AM, Seb wrote: > Hi, > > I'm working on the design of a database for time series data collected > by a variety of meteorological sensors. Many sensors share the same > sampling scheme, but not all. I initially thought it would be a good > idea to have a table ident

Re: [GENERAL] vacuuming - doubt

Scott Marlowe-2 wrote > 30 second vacuum lesson: Thank you. -- View this message in context: http://postgresql.1045698.n5.nabble.com/vacuuming-doubt-tp5782828p5783057.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-g

[GENERAL] vacuuming - doubt

16384 (1 row) accounts=> vacuum full myt; VACUUM accounts=> select pg_total_relation_size('myt');; pg_total_relation_size 0 (1 row) So what was the 65536 bytes left behind after standard vacuum? Regards, Jayadevan

[GENERAL] WITH and exclusive locks

nce is not an issue. Is that correct? Regards, Jayadevan

Re: [GENERAL] log_line_prefix

hubert depesz lubaczewski-2 wrote > It looks like you're using csvlog. log_line_prefix is used only for > stderr/syslog logging. Yes, that is right. Thank you. -- View this message in context: http://postgresql.1045698.n5.nabble.com/log-line-prefix-tp5778674p5778688.html Sent from the Postgre

[GENERAL] log_line_prefix

28.349 IST,,,3186,,5286c0d6.c72,10,,2013-11-16 06:18:22 IST,,0,LOG,0,"parameter ""log_line_prefix"" changed to ""%m %d %u ""","" 2013-11-16 08:27:34.681 IST,"postgres","postgres",3469,"[local]",5286df1d.d8d,1,"SELECT",2013-11-16 08:27:33 IST,2/0,0,LOG,0,"duration: 0.732 ms statement: select now();","psql" I think some other setting is printing all the info anyway. But which setting? Regards, Jayadevan

[GENERAL] Postgres Server backend process

- "When a request message is received, we now fork() immediately. The child process performs authentication of the request," Now authentication is done by the Backend process and not by the daemon? Regards, Jayadevan

Re: [GENERAL] Tuning 9.3 for 32 GB RAM

y go through http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server and see what http://pgfoundry.org/projects/pgtune/ says. Jayadevan

Re: [GENERAL] Theory question

On Thu, Nov 14, 2013 at 7:58 AM, Jayadevan wrote: > Jeff Janes wrote > > No. The checkpointer writes all data that was dirty as of a certain time > > (the start of the checkpoint) regardless of how often it was used since > > dirtied, and the background writer writes data

Re: [GENERAL] Theory question

Jeff Janes wrote > No. The checkpointer writes all data that was dirty as of a certain time > (the start of the checkpoint) regardless of how often it was used since > dirtied, and the background writer writes data that hasn't been used > recently, regardless of when it was first dirtied. Neither

Re: [GENERAL] Theory question

Kevin Grittner-5 wrote > The checkpointer process is responsible for creating safe points > from which a recovery can begin; the background writer tries to > keep some pages available for re-use so that processes running > queries don't need to wait for page writes  in order to have free > spots to

[GENERAL] Theory question

Hi, What are the real differences between the bgwriter and checkpointer process? Both of them write data from the buffer to the data files, right? Is it just a matter of 'when' they write? Regards, Jayadevan

Re: [GENERAL] Documents/ppts/pdfs

p://www.postgresql.org/files/developer/optimizer.pdf> (From >OSCON 2003) > > > Thanks & Regards > Raghu Ram > > Thank you. Regards, Jayadevan

[GENERAL] Documents/ppts/pdfs

? I can't find any links in postgresql.org or documentation pointing to files like this. Regards, Jayadevan

Re: [GENERAL] Explanantion on pgbouncer please

Why don't you try adding layers one by one? 1) Ensure you can connect to PostgreSQL from psql client (on another machine) 2) Configure pgbouncer 3) See if you can connect from psql > pgbouncer > PostgreSQL Check the data in pgbpuncer and PostgreSQL (number of sessions, idle connections etc). You co

Re: [GENERAL] Connection pooling

I have never used pgbouncer myself. But my guess is you have to look at the Timeout parameters in the configuration file. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Connection-pooling-tp5776378p5776481.html Sent from the PostgreSQL - general mailing list archive at

Re: [GENERAL] search_path and current_schema

OK. When I logged in as a user who had access to the schema, the output from current_schemas and search_path were matching. Thanks. On Sun, Oct 27, 2013 at 9:55 PM, Tom Lane wrote: > Jayadevan M writes: > > I thought current_schemas and search_path will return the same set of &g

[GENERAL] search_path and current_schema

rch_path; search_path -- mynewschema, "$user", public (1 row) I thought current_schemas and search_path will return the same set of schemas (except that current_schema will show pg_catalog also, if we use true). Shouldn't mynewschema appear in the output of select current_schemas(true)? Regards, Jayadevan

Re: [GENERAL] PostgreSQL Point In Time Recovery

Alan Hodgson wrote > Well, yeah. The point was that you possibly could run it for a while to > "catch > up" without taking a new base backup if you desired. You should also keep > copies of it for PITR. Something like this - delayed replication

Re: [GENERAL] PostgreSQL Point In Time Recovery

Alan Hodgson wrote > That's basically what warm standby's do, isn't it? As long as they keep > recovery open it should work. A warn standby will be almost in sync with the primary, right? So recovery to point-in-time (like 10 AM this morning) won't be possible. We need a base, but it shouldn't be

Re: [GENERAL] PostgreSQL Point In Time Recovery

Jeff Janes wrote > I restore from my base backup plus WAL quite often. It is how I get a > fresh dev or test instance when I want one. (It is also how I have > confidence that everything is working well and that I know what I'm doing > should the time come to do a real restore). When that starts

[GENERAL] PostgreSQL Point In Time Recovery

avoid that, what is the standard process followed - take a base backup every day or once a week? Regards, Jayadevan

Re: [GENERAL] postgresql.conf error

ot;"/pgdata/prod/data_93/postgresql.conf"" contains errors; unaffected changes were applied","" On Fri, Oct 18, 2013 at 1:12 PM, Tom Lane wrote: > Jayadevan M writes: > > Which is the quickest way to troubleshot the message " > > LOG: co

[GENERAL] postgresql.conf error

_ctl reload. Is there an option to test the configuration file for errors, after making changes? Regards, Jayadevan

Re: [GENERAL] logging statements in PostgreSQL

Hi, I was looking for options to make sure SQLs executed as part of functions also get logged. Since this is a production system, I wanted to do it without the EXPLAIN also written to the logs. May be that is not possible? Regards, Jayadevan On Mon, Sep 30, 2013 at 5:08 PM, Albe Laurenz wrote

Re: [GENERAL] logging statements in PostgreSQL

, Amit Langote wrote: > On Wed, Sep 25, 2013 at 12:18 PM, Jayadevan M > wrote: > > Hi all, > > I am planning to use pgbadger for analyzing queries. Documentation for > > pgbadger says "Do not enable log_statement as their log format will not > be >

[GENERAL] logging statements in PostgreSQL

s too, for example. select sp_pg_refresh_alert_data(current_date); But the SELECT and INSERT in the function are not getting logged. Is that how PostgreSQL logging works, or I have missed something? Regards, Jayadevan

Re: [GENERAL] Query runs forever after upgrading to 9.3

Could you please post EXPLAIN for that query? How 'fat' are the temporary tables - just a couple of columns or really wide? On Mon, Sep 23, 2013 at 7:08 PM, Andrus wrote: > Query > > SELECT * FROM toode > WHERE toode in (SELECT toode FROM tempkaive) > OR toode in (SELECT toode FROM tempalg

Re: [GENERAL] Postgres 9.3 Installation Problems Windows 7 64 Bit Pro

It should be possible to install the SW without initializing the cluster. That way you may be in a better position to troubleshoot the issue. Complete the installation, then use initdb to initialize a cluster. Have a look at this url too - http://wiki.postgresql.org/wiki/Running_%26_Installing_Post

Re: [GENERAL] Using oracle stored procedures for postgresql database

Regards, Jayadevan On Fri, Sep 20, 2013 at 3:19 PM, nikhilruikar wrote: > Hi > I am planning to migrate oracle database to postgres. I need to know > if there are any plugins or tool with which I can use stored procedures > written in oracle schema for postgres with out c

Re: [GENERAL] Query - CPU issue

Thank you for the pointers. I will try those suggestions. As I mentioned later, resolving the query solved the problem for now. Regards, Jayadevan On Thu, Sep 19, 2013 at 11:40 AM, Kevin Grittner-5 [via PostgreSQL] < ml-node+s1045698n5771567...@n5.nabble.com> wrote: > Jayadevan

Re: [GENERAL] Query - CPU issue

Rewriting the query in the function like this solved the issue (this is how it was in the SQL at https://github.com/tvondra/geoip/blob/master/sql/geoip--0.1.0.sql) explain analyze SELECT l.id, l.country, l.region, l.city FROM blocks b JOIN locations l ON (b.location_id = l.id) WHERE 37211969

Re: [GENERAL] Query - CPU issue

Kevin Grittner-5 wrote > We already had this.  I was asking for you to get EXPLAIN ANALYZE > output for a run of the SELECT statement inside the geoip_city() > function. "Merge Join (cost=9268.34..26193.41 rows=6282 width=24) (actual time=892.188..892.190 rows=1 loops=1)" " Merge Cond: (l.id = b

Re: [GENERAL] Query - CPU issue

Kevin Grittner-5 wrote > What is the longest you have let it run, in hours or minutes? I let it run for about 10 minutes and killed it. Kevin Grittner-5 wrote > By the way, IMMUTABLE has to be wrong here, since the results > depend on the state of the database.  STABLE is likely the right > desig

[GENERAL] Query - CPU issue

GUAGE sql IMMUTABLE COST 100; There are indexes on the start_ip and end_ip and an explain tells me the indexes are being used (if I execute the SELECT in the function using a valid value for the ip value. Regards, Jayadevan

[GENERAL] Moving from 9.2 to 9.3

Hello, When I upgraded from 9.2 to 9.3, I copied the postgresql.conf and pg_hba.conf files form 9.2 installation and used those. Is that likely to cause any issues? I did not see any significant parameter changes from 9.2 to 9.3. So far, it is running fine. Regards, Jayadevan

Re: [GENERAL] [pgeu-general] Call for design: PostgreSQL mugs

Hello all, "Elephants Never Forget" sounds like a good idea. It refers to reliability of the database (from a transaction perspective) and ability to recover "lost data". http://www.scientificamerican.com/article.cfm?id=elephants-never-forget Regards, Jayadevan On Sun, Se

Re: [GENERAL] OLAP

Alban Hertroys-4 wrote > How is Pentaho an OLAP tool? Aren't you mixing up a few things? > We already use Pentaho for ETL, so I'm a bit familiar with it. Why do you > consider it suitable for managing an OLAP database? > > How would Pentaho manage cube rollup triggers, business models, dimensions

Re: [GENERAL] PostgreSQL 9.3

Hi, Thanks. So we are close to the tentative release date. Good. Regards, Jayadevan On Mon, Aug 19, 2013 at 10:16 AM, Sandro CAZZANIGA < cazzaniga.san...@gmail.com> wrote: > Le 19/08/2013 06:38, Jayadevan M a écrit : > > Hello all, > > Is the release date for PostgreSQL 9

[GENERAL] PostgreSQL 9.3

Hello all, Is the release date for PostgreSQL 9.3 production decided? We are going live in a couple of weeks with a portal and if possible, would like to go with 9.3, Materialized Views being the key feature that will add value. Regards, Jayadevan

Re: [GENERAL] Debugging Postgres?

Hi, Having a look at the PostgreSQL log may help. http://stackoverflow.com/questions/71/how-to-log-postgres-sql-queries You could also try logging in via psql on the database host itself, to ensure it is not a network issue. Regards, Jayadevan On Wed, Aug 14, 2013 at 2:21 AM, Barth Weishoff

Re: [GENERAL] Trigger to update table info

Hi, In case you are not keen on getting the latest and really accurate counts/size, you could just refer the views readily available - http://stackoverflow.com/questions/2596670/how-do-you-find-the-row-count-for-all-your-tables-in-postgres You won't get the updatetime, though. Regards, Jaya

Re: [GENERAL] Replication Postgre > Oracle

Hi, >From Oracle to PostgreSQL, you could have a look at Goldengate. It does not support PostgreSQL as the source database. Regards, Jayadevan On Wed, Aug 7, 2013 at 1:54 PM, BOUVARD Aurélien < aurelien.bouv...@supinfo.com> wrote: > Hi all, > > ** ** > > M

Re: [GENERAL] Migration from Symfoware to PostgreSQL-Constructor functions

Hi, System tables, views and most of the metadata can be retrieved from these views - http://www.postgresql.org/docs/9.2/static/information-schema.html Regards, Jayadevan On Sun, Aug 4, 2013 at 2:48 PM, sachin kotwal wrote: > Hello > > While migrating small application from Sym

Re: [GENERAL] pg recovery

here. When you said recovery has begun, I confused it with promotion. Apologies. I tried restarting the standby node and it worked. Thanks a lot, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contai

Re: [GENERAL] pg recovery

ge to recovery.conf. How can I make slave 'accept' that change? Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have recei

[GENERAL] pg recovery

Hi, I have postgresql streaming replication set up. I forgot to add an entry for trigger_file in recovery.conf. So I added that entry and did a pg_ctl reload. Is there a way to confirm that the entry has been read by the server? Any view/function? Regards, Jayadevan DISCLAIMER: &quo

Re: [GENERAL] query on query

d candidate for a CTE: > >WITH RECURSIVE t(n) AS ( >VALUES (10) > UNION ALL >SELECT n+10 FROM t WHERE n < 50 >) >select count(*), t.n from m, t where mark > t.n group by t.n; I meant 'fast', not 'fat. Sorry for the typo. You got it right. The query

[GENERAL] query on query

ll have many thousands of records. Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact t

Re: [GENERAL] json functions

ee what it does (which isn't much since json >is >an already serialized format). OK. That explains it. I was wondering why we have quite a few functions under pg_catalog and just a few in the documentation. Thank you. Regards, Jayadevan DISCLAIMER: "The information in this e-mail

[GENERAL] json functions

Hi, I have PostgreSQL 9.2.1. I can see a few json functions under pg_catalog, json_send, for example. But I can't find any documentation. Am I missing something? Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to

[GENERAL] Oracle to PostgreSQL replication with Goldengate

quite a few cases - such as trying out the application on PostgreSQL before really cutting over from an Oracle database, may be running reports off PostgreSQL and so on. Regards, Jayadevan

Re: [GENERAL] Data sets for download

on might be the Dell DVD Store Loadtest: >http://linux.dell.com/dvdstore/ > >It can generate testdata with a specific scale and it works well with Postgres. > Thank you. Will try these. Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is inten

[GENERAL] Data sets for download

not simple. Anything similar - the typical warehouse/customer/order tables or emp/dept/project ? Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged mat

[GENERAL] Replication - doubts

e complete - in this case the slave is almost uptodate If I set up a slave using the archived WAls and set hot_standby on in the slave, will I be able to read from the slave? Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for

Re: [GENERAL] PostgreSQL data loads - turn off WAL

(real, logged tables). This url might also help - http://www.postgresql.org/docs/9.1/static/populate.html Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileg

Re: [GENERAL] How to isolate the result of SELECT's?

ergo changes, but you will get repeatable reads. Explicitly locking the tables is another option. http://www.postgresql.org/docs/current/static/explicit-locking.html Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom

Re: [GENERAL] Hope for a new PostgreSQL era?

onfigure etc. I hope many of these features will become part of the 'core' soon. Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged mater

Re: [GENERAL] Hope for a new PostgreSQL era?

ion server events in the development/test environment. http://docs.oracle.com/cd/B28359_01/server.111/e12253/dbr_intro.htm Won't something like this be useful in PostgreSQL? It will let us mimic the production environment load and analyze it better. Regards, Jayadevan DISCLAIMER: "

Re: [GENERAL] Conceptual Architecture

.com/~gsmith/content/postgresql/InsideBufferCache.pdf Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail

Re: [GENERAL] Help on PostgreSQL

SQL. That is what we did. We used ora2pg for database migration and orafce (http://pgfoundry.org/projects/orafce/) to minimize code changes. Since we did not have many procedures/packages it worked very well. Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any at

Re: [GENERAL] Materialized views in Oracle

log tables. In a high end OLTP system, this overhead is not desirable. " Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you

Re: [GENERAL] How to convert ByteA to Large Objects

data from pg_largeobject where loid= gave us a couple of hundred records, so we assume data has been inserted. Switching to file storage will mean quite a bit of changes at the code level, and a lot of testing of the products that runs fine on Oracle now. Regards, Jayadevan DISCLAIMER: "

Re: [GENERAL] How to convert ByteA to Large Objects

Thank you. We are working on an Oracle to PostgreSQL migration project. BLOB columns got converted to BYTEA in PostgreSQL and we ran into problems. We used this to convert the data type to OID. Thank you. -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-convert-By

Re: [GENERAL] Complex query question

5 | BB|80 | 10 (5 rows) test=# select a.* from myt a where id in (select min(id) from myt group by loc_title) order by loc_title; id | loc_title | loc_value | loc_unit +---+---+-- 1 | AA| 80 | 10 3 | BB|80 | 10 (2 rows

Re: [GENERAL] COPY FROM how long should take ?

in postgresql table stopped increasing after some time and I realized data transfer was failing. I checked the log file for errors,corrected the data issues in the source table (Oracle) and it finished the load without issues. Regards, Jayadevan DISCLAIMER: "The information in this e-mai

Re: [GENERAL] Getting value of bind variables

utput go somewhere else? I am looking at the column query_text (select * from postgres_log where error_severity='ERROR' and log_time > '20110818') and it shows .AND ( CUSINDINF.MEMDOB )= ($4) Regards, Jayadevan DISCLAIMER: "The information i

[GENERAL] Getting value of bind variables

ogging level set to debug5 in postgresql.conf for all logging options. But what is the 'correct' approach? Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential

Re: [GENERAL] PostgreSQL documentation on kindle - best practices?

to kindle format, free of cost. It is not a good idea to try and read pdf files in Kindle. You have to send the pdf file to @free.kindle.com Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and ma

Re: [GENERAL] How to restore from backup to 8.4.3 server using 9.0 dump/restore

ther connection exists when it starts; Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly

Re: [GENERAL] Debug advice when postgres connection maxing out

see http://www.postgresql.org/docs/9.0/static/functions-admin.html Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this

Re: [GENERAL] gap between error and cure

select user; current_user -- postgres (1 row) postgres=# show hba_file; hba_file --- /usr/local/pgsql/data/pg_hba.conf (1 row) Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

from liveable where mypk in (select id from mytemp ) Reading about what goes into WAL tells me that the permanent table data will be replicated all right even if the temp tables are not logged. Is that right? Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any a

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

ot about layout, rather the DMLs. If I do an insert into an 'unlogged' table, what happens to that? Will that be replicated in the slave (using PostgreSQL's inbuilt replication)? Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is inte

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

for highly volatile, but not very valuable, > > data, such as session statues, application logs, etc. > > One doubt - if the tables are 'unlogged' , will the DMLs against these still be replicated to a slave? Regards, Jayadevan DISCLAIMER: "The information in this

  1   2   >