[GENERAL] Tool for data modeling and ER diagram

Hi List, What is the best tool of data modeling and ER diagram for PostgreSQL. -- Thanks & Regards DJ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, re-transmission, dissemi

[GENERAL] calculation of database size

How can I measure the approximate database size based on row data. Is there any calculation template? -- Thanks & Regards DJ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, re-tra

Re: [GENERAL] calculation of database size

3.978.43 www.microland.com India's leading Infrastructure Management Services Company -Original Message- From: Jaiswal Dhaval Sudhirkumar Sent: Thu 12/9/2010 10:05 PM To: pgsql-general@postgresql.org Subject: calculation of database size How can I measure the approximate database size

Re: [GENERAL] calculation of database size

Got the link. http://wiki.postgresql.org/wiki/FAQ#What_is_the_maximum_size_for_a_row.2C_a_table.2C_and_a_database.3F -- Thanks & Regards DJ From: Jaiswal Dhaval Sudhirkumar Sent: Thu 12/9/2010 10:07 PM To: Jaiswal Dhaval Sudhirkumar; pgsql-gen

[GENERAL] Spatial data Loading and storing

Hi List, I have a query about loading huge amount of data into postgis. I am using shp2pgsql tool which is loading data with single channel only inside database. i.e. one shape file at a time. Is there any tool which can load multiple shape file at a time. Another query is that I want to sto

[GENERAL] HA solution

Hi, I am looking for active-active clustering solution. I have one SAN box and two separate NODES, where I need to create active-active cluster. My data directory would be one and mounted to the SAN box for both the nodes. (There will be one sharable data directory for both the nodes) So the

Re: [GENERAL] HA solution

houghts/comments/help from experts. -- Thanks & Regards Dhaval Jaiswal -Original Message- From: pgsql-general-ow...@postgresql.org on behalf of John R Pierce Sent: Sat 1/15/2011 12:23 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] HA solution On 01/14/11 9:4

Re: [GENERAL] HA solution

Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Sun 1/16/2011 1:28 AM To: pgsql-general@postgresql.org Cc: Jaiswal Dhaval Sudhirkumar; John R Pierce Subject: Re: [GENERAL] HA solution On Saturday 15 January 2011 10:07:14 am Jaiswal Dhaval Sudhirkumar wrote: > Thanks for your

Re: [GENERAL] HA solution

ease? -- Thanks & Regards Dhaval Jaiswal From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Mon 1/17/2011 1:41 AM To: pgsql-general@postgresql.org Cc: Jaiswal Dhaval Sudhirkumar; John R Pierce Subject: Re: [GENERAL] HA solution On Sunday 16 January 2

Re: [GENERAL] Mysql to Postgresql

Take a look at the Navicat for PostgreSQL. -- Thanks & Regards Dhaval Jaiswal Cell: +91 80953.978.43 From: pgsql-general-ow...@postgresql.org on behalf of Adarsh Sharma Sent: Tue 2/22/2011 2:51 PM To: pgsql-general@postgresql.org Cc: my...@lists.mysql.com Sub

Re: [GENERAL] Tool for shifting tables from Mysql to Postgresql

By looking at error it seems that database encoding is different in mysql database. By default db encoding in PostgreSQL is UTF-8. You can set client_encoding by set client_encoding = You can check the Mysql database encoding using following command. show variables like "character_set_data

Re: [GENERAL] How to tune this query

In query some are the repeatative information like below value repeating 3 times. "19.548124415111626 73.21900819489186" You can create the spatial index on spatial data which will improve the performance of the query & off course ANALYZE after creating index. -- Thanks & Regards Dhaval Jai

Re: [GENERAL] ER tool that supports domains and custom types?

open system architect (open source), E-R data modeling, DBWrench. If you are planning to go for paid one than E-R data modeling is the best one. -- Thanks & Regards Dhaval Jaiswal -Original Message- From: pgsql-general-ow...@postgresql.org on behalf of Arturo Perez Sent: Wed 3/9/2011

Re: [GENERAL] about memory size reported by system.

Are you using any connection pooling system, if not look at the pgpool & pgbouncer. open connections always reserves memory, which slowdown the performance of system. you can also handle application connections at application level by defining garbage value if any connection disconnect. It

[GENERAL] >>relation with OID 1211822032 does not exist

Hi All, We are getting following error on intermittent basis when we write data into database. We are on postgreSQL 8.0.2, with slony I. We used to stop the replication, taking back-up from the primary, restore it on secondary server and again start the replication again. We used to do above acti

Re: [GENERAL] Unknown winsock error 10061

Is there any other server running over the same system ? Have you killed any processes from OS level ? What is the message showing when you are trying to start the pg server ? -- Thanks Dhaval -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@pos

Re: [GENERAL] Query is stuck

select procpid, current_query,query_start - now(), backend_start from pg_stat_activity where current_query not like '%IDLE%' and waiting = 't'; -- Thanks Dhaval From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Satish Burnwal (sburnwal) S