Re: [GENERAL] MySQL -> PostgreSQL conversion issue

Thank you for your reply, sorry for the late response, your reply really helped me. Thanks Deepak On Fri, Aug 19, 2011 at 11:39 AM, Alban Hertroys < dal...@solfertje.student.utwente.nl> wrote: > On 19 Aug 2011, at 14:50, DM wrote: > > > Hi All, > > > > how to i

[GENERAL] MySQL -> PostgreSQL conversion issue

Hi All, how to insert mysql (datetime interval) data to postgrres interval datatype. mysql | test_interval | datetime | YES | | 1970-01-02 00:00:00 | | psql test_interval | interval | any solution for this? thanks Deepak

[GENERAL] SHMMAX and SHMALL question

Firstof all sorry for posting linux kernel question in pgsql-general, but i am trying to figure out what value to set for postgresql db server. RAM = 16GB, what value should i set for shmall? If i set shmall to 4294967296 (4GB), current PAGE_SIZE is 4096 should i need to set my shmmax = 429496729

Re: [GENERAL] How can I find the schema that a table belongs to?

x27;S','') AND n.nspname <> 'pg_catalog' AND n.nspname <> 'information_schema' AND n.nspname !~ '^pg_toast' AND pg_catalog.pg_table_is_visible(c.oid) AND c.relname like '%my_table_name%' ORDER BY 1,2; ***

Re: [GENERAL] How can I find the schema that a table belongs to?

hich works but seems a bit brute-force. regards, tom lane - Hide quoted text - ======> On Wed, Jan 19, 2011 at 12:58 PM, Jerry LeVan wrote: > > On Jan 19, 2011, at 3:12 PM, DM wrote: > > > one of the way to find out schema name is like below > >

Re: [GENERAL] How can I find the schema that a table belongs to?

one of the way to find out schema name is like below select * from pg_tables where tablename like '%xyz%'; schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers +---++++--+- (0 rows) ~Dee

[GENERAL] Pg_upgrade question

We are planning to upgrade to 9.01 from 8.4/8.3 version. On my production Server, there isn't much space left to do a pg_upgrade (Copy), Can I execute pg_upgrade from new box by pointing to the data directory and binaries on old box. Thanks Deepak

Re: [GENERAL] Postgres 9.01 and WAL files issue

feedback you get as to why it isn't returning either a positive or negative > return. > > > On Wed, Nov 24, 2010 at 5:52 PM, DM wrote: > >> Hi All, >> >> pg_stop_backup is not stopping... >> >> Postgresql version 9.01 >> OS: Centos >&

Re: [GENERAL] diagram tools?

There are many of them, I use SchemaSpy java based - easy to generate. http://schemaspy.sourceforge.net/ Thanks Deepak On Wed, Nov 24, 2010 at 8:08 AM, Dan Armbrust < daniel.armbrust.l...@gmail.com> wrote: > Can anyone recommend a PostgreSQL compatible free tool that I can use > to generate so

[GENERAL] Postgres 9.01 and WAL files issue

Hi All, pg_stop_backup is not stopping... Postgresql version 9.01 OS: Centos Postgresql.conf ==> default configuration did not change anything Steps 1. Initiated psql -c "SELECT pg_start_backup('label', true)" 2. Started RSYNC job to sync slave box rsync -a /var/lib/pgsql/data/ dbpg9-test-

Re: [GENERAL] Query precision issue

Hello Sairam, What is the type of the colum?, what version of postgres are you using? I didn't had any problem retrieving data in both ways... check out the below = test=# create temp table test (col1 float); CREATE TABLE test=# insert into test values

Re: [GENERAL] Question on Explain : Index Scan

| not null sid| character varying(13) | ename | character varying(80) | Indexes: "test_seqindex2_pkey" PRIMARY KEY, btree (eid) "idx_test_seqindex2_sid" btree (sid) ======

Re: [GENERAL] Question on Explain : Index Scan

perfecto, thank you for the explanation. - Deepak On Thu, Oct 21, 2010 at 3:20 AM, Mathieu De Zutter wrote: > On Thu, Oct 21, 2010 at 3:47 AM, DM wrote: > > I was hoping the optimizer would do a join using index scan. > > > > Could some one please explain me why its no

Re: [GENERAL] Composite Index question

Thank you for all your suggestions and answers. - Deepak On Wed, Oct 20, 2010 at 7:41 PM, mark wrote: > > On 10/20/2010 05:43 PM, DM wrote: > > Composite Index question: > > > > I have composite index on 3 columns on a table, by mistake the composite > > index

[GENERAL] Question on Explain : Index Scan

Question on Index scan: ---> test=# \d test_seqindex1 Table "public.test_seqindex1" Column | Type | Modifiers +---+--- sid| character varying(13) | not null nam

Re: [GENERAL] Generate a dynamic sequence within a query

ss); select * from dup_test; nm1 | nm2 | dup_id -+-+ A | A | 1 A | B | 2 A | C | 3 B | A | 4 B | B | 5 B | C | 6 (6 rows) Hope this helps On Wed, Oct 20, 2010 at 4:07 PM, David Kerr wrote: > On Wed, Oct 20, 2010

Re: [GENERAL] Composite Index question

g. > > On 10/20/2010 06:02 PM, DM wrote: > > Its a huge table in production, i dont want to take any risk. > > > > I can simulate and test this but i was to checking to see If any one > > knows off hand about this. > > > > > > > > I can s

Re: [GENERAL] Composite Index question

dex definition; > re-run the same queries; report to the group. The redundant index isn't > helping, that much is certain. > > On 10/20/2010 05:43 PM, DM wrote: > > Composite Index question: > > > > I have composite index on 3 columns on a table, by mistake the co

[GENERAL] Composite Index question

Composite Index question: I have composite index on 3 columns on a table, by mistake the composite index was created twice on the table. Will there any performance issues on this table because of the 2 same composite indexes? Thanks Deepak

Re: [GENERAL] Generate a dynamic sequence within a query

select generate_series(1,(select count(*) from tax)), country from tax; you should use braces around the sub select. Thanks Deepak On Wed, Oct 20, 2010 at 3:30 PM, David Kerr wrote: > On Wed, Oct 20, 2010 at 11:28:18PM +0100, Raymond O'Donnell wrote: > - On 20/10/2010 23:22, David Kerr wrote:

Re: [GENERAL] Enforcing password standards

Thanks everyone, I will wait for Postgres 9.0 to implement this feature then. Thanks Thanks Deepak On Fri, Jun 11, 2010 at 10:30 AM, Joshua Tolley wrote: > On Thu, Jun 10, 2010 at 06:01:24PM -0700, DM wrote: > >How to force postgres users to follow password standards an

[GENERAL] Enforcing password standards

How to force postgres users to follow password standards and renewal policies? Thanks Deepak

Re: [GENERAL] Move data from DB2 to Postgres any software/solutions/approach?

Thank you so much for all your inputs. On Fri, Jun 4, 2010 at 3:27 PM, John R Pierce wrote: > DM wrote: > >> Thank you so much for every ones inputs. >> >> It is not real time, updates every 5 mins should be fine. But the DB2 >> database is real busy and its real

Re: [GENERAL] Move data from DB2 to Postgres any software/solutions/approach?

Thank you so much for every ones inputs. It is not real time, updates every 5 mins should be fine. But the DB2 database is real busy and its real performance based. Thanks Deepak On Fri, Jun 4, 2010 at 2:49 PM, John R Pierce wrote: > DM wrote: > >> Sorry i didnt frame my quest

Re: [GENERAL] Move data from DB2 to Postgres any software/solutions/approach?

postgres database. Thanks Deepak On Fri, Jun 4, 2010 at 2:23 PM, DM wrote: > Thanks Robert, > > Is there any tools available. > > Thanks > Deepak > > > On Fri, Jun 4, 2010 at 2:19 PM, Richard Broersma < > richard.broer...@gmail.com> wrote: > >> On Fri, Ju

Re: [GENERAL] Move data from DB2 to Postgres any software/solutions/approach?

Thanks Robert, Is there any tools available. Thanks Deepak On Fri, Jun 4, 2010 at 2:19 PM, Richard Broersma wrote: > On Fri, Jun 4, 2010 at 2:13 PM, DM wrote: > > We want to replicate /move data form db2 to postgres is there any > software / > > solutions / approach av

[GENERAL] Move data from DB2 to Postgres any software/solutions/approach?

Hi All, We want to replicate /move data form db2 to postgres is there any software / solutions / approach available to do this? Thanks Deepak

Re: [GENERAL] PostgreSQL Performance issue

Hello there, 1. Try using COPY Command, you will see significant decrease in the loading time. 2. Turn off auto commit and Remove foreign key constraints if it is only one time load - this will also help in decreasing the load time. Try these options and let us know how it went. We load around 6

Re: [GENERAL] pg_dump issues

You were right, after zipping the dump file it came out to 6.9G Thanks for your help. thanks Deepak On Tue, Feb 2, 2010 at 3:20 PM, Scott Marlowe wrote: > On Tue, Feb 2, 2010 at 4:07 PM, DM wrote: > > Hi All, > > I have a database with only one schema with 5 tab

Re: [GENERAL] pg_dump issues

Hi All, I have a database with only one schema with 5 tables nspname | relname | size -+-+- sch | job1 | 211 MB sch | job2 | 5611 MB sch | job3 | 658

[GENERAL] pg_dump issues

Hi All, I have a database with only one schema with 5 tables nspname | relname | size -+-+- sch | job1 | 211 MB sch | job2 | 5611 MB sch | job3 | 658

Re: [GENERAL] port question

Hello Amy, trying to understand your situation, *I have installed a v8.4 and first port using localhost is ok - *default port is 5432 You can only use one port for one instance of postgres, default port 5432 can be overridden by any new port number. Thanks Deepak On Sun, Jan 24, 2010 at 11:23

Re: [GENERAL] When is the release date for Postgres 8.5?

It looks like alpha version of 8.5 is already out here is the link http://www.postgresql.org/about/news.1172 Thanks Deepak On Fri, Jan 22, 2010 at 12:05 PM, Larry Rosenman wrote: > On Fri, 22 Jan 2010, John R Pierce wrote: > > Larry Rosenman wrote: >>

Re: [GENERAL] When is the release date for Postgres 8.5?

Thank you for the update. Thanks Deepak On Fri, Jan 22, 2010 at 5:45 AM, Bruce Momjian wrote: > A. Kretschmer wrote: > > In response to DM : > > > Hello All, > > > > > > When is the release date for Postgres 8.5? > > > > Never. > > >

[GENERAL] Fragmentation/Vacuum, Analyze, Re-Index

Hello All, How to identify if a table requires full vacuum? How to identify when to do re-index on an existing index of a table? Is there any tool for the above? Thanks Deepak Murthy

[GENERAL] When is the release date for Postgres 8.5?

Hello All, When is the release date for Postgres 8.5? Thanks Deepak

Re: [GENERAL] Comparing 2 databases

Also check this out Very interesting – it can compare data between the DBs (tables/views). Check this out – http://www.zidsoft.com/ http://www.zidsoft.com/screenshots.html Thanks Deepak On Tue, Dec 29, 2009 at 4:37 PM, Joshua Tolley wrote: > On Tue, Dec 29, 2009 at 03:21:18PM -0500, akp gee

[GENERAL] Install compat-postgresql-libs-debuginfo on postgres 8.3.8 without using RPM

All How to Install compat-postgresql-libs-debuginfo on postgres 8.3.8 by compiling the source code. The way i have installed postgres is by compiling the postgres files. Thanks Deepak

Re: [GENERAL] [ADMIN] Best way to install postgres? RPM/Source Code Build

Thank you guys for the answers. On Tue, Apr 28, 2009 at 6:06 PM, Joshua D. Drake wrote: > > > > > Ops team want to install postgres as (usr/local/bin) using RPM, and > > want to keep the data directory under (/var/lib/data/pgsql) and they > > say that we cannot have two versions at the same time

[GENERAL] Best way to install postgres? RPM/Source Code Build

Hi All, What is the best way to Install postgres database? We have installed (2) versions of the postgres on th server using source code (compiling and building) (/usr/local/pgsql/8.3.3/ and /usr/local/pgsql/8.3.6/) and our data directory is (/mnt/data/pgsql/) Our database size is more than 100GB.

[GENERAL] Re: [ADMIN] how to revoke multiple users permission from multiple tables at the same time?

, Apr 22, 2009 at 4:02 PM, Scott Marlowe wrote: > On Wed, Apr 22, 2009 at 5:01 PM, Scott Marlowe > wrote: > > On Wed, Apr 22, 2009 at 4:19 PM, DM wrote: > >> how to revoke multiple users permission from multiple tables at the same > >> time? > >> Or in simple

[GENERAL] how to revoke multiple users permission from multiple tables at the same time?

how to revoke multiple users permission from multiple tables at the same time? Or in simple is there a way to revoke multiple users grant access from multiple tables under a schema.? I use Revoke below command to execute on each table one by one. revoke SELECT/ALL on testtable from user1; Thanks

Re: [GENERAL] how to search for relation by name?

Here is the sql SELECT c.oid, n.nspname, c.relname FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relname LIKE ('%dt%') AND pg_catalog.pg_table_is_visible(c.oid) replace dt with your sequence name pg_catalog has the information. Thank

[GENERAL] Standards for Postgres Installation Question?

always defaults to -- /usr/local/pgsql/, Is there an RPM that i can use where i can specify my installation directory path? Thanks DM

[GENERAL] Can we load all database objects in memory?

Hi All, I have a database of 10GB. My Database Server has a RAM of 16GB Is there a way that I can load all the database objects to memory? Thanks for your time and taking a look at this question. Thanks Deepak

Re: [GENERAL] pg_restore error - Any Idea?

Eric, There was no change in the version, we are using postgres v8.3.5 Thanks Deepak On Sun, Mar 22, 2009 at 11:17 PM, Erik Jones wrote: > > On Mar 22, 2009, at 10:44 PM, DM wrote: > > Hi All, >> >> I am facing an error on executing the below command >&

[GENERAL] pg_restore error - Any Idea?

Hi All, I am facing an error on executing the below command dump name: pg_dump_FcZ0.pnps_200903041201_1.2.1.0_base_testing databae name: pnqd_test $pg_restore -U postgres -p 5433 -d pnqd_test pg_dump_FcZ0.pnps_200903041201_1.2.1.0_base_testing pg_restore: [archiver (db)] Error while PROCESSING

Re: [GENERAL] max_fsm_relations and max_fsm_pages problem

Question How many database objects or relations do you have? Thanks Deepak On Wed, Mar 18, 2009 at 8:12 AM, Gauthier, Dave wrote: > Hi: > > > > I have max_fsm_relations set to 1200 and max_fsm_pages set to 20 in > postgres.conf (well over 16x max_fsm_relations) but still get... > > > > FATAL