Re: [GENERAL] building a binary-portable database

On Aug 1, 2009, at 8:24 AM, Alban Hertroys wrote: On 1 Aug 2009, at 24:53, Alexy Khrabrov wrote: That's doable of course, but I wonder what would it take to get it to work as-is, when building pg from source on each box, giving their fairly similar characteristics. Or, if time_t is differen

Re: [GENERAL] Can I add a super table to existing tables?

On Sat, Aug 1, 2009 at 9:42 PM, David Fetter wrote: > On Sat, Aug 01, 2009 at 08:10:02PM -0700, Jun Yang wrote: > > On Sat, Aug 1, 2009 at 7:53 PM, David Fetter wrote: > > > On Sat, Aug 01, 2009 at 06:28:54PM -0700, Jun Yang wrote: > > > > Hi all, > > > > > > > > I want to add some common column

Re: [GENERAL] questions on (parallel) COPY and when to REINDEX

Andy Colson writes: > I have never tried two processes copy'ing into the same table at the same > time, but I'd bet its possible. It's no different from concurrent INSERTs ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To ma

Re: [GENERAL] Can I add a super table to existing tables?

On Sat, Aug 01, 2009 at 08:10:02PM -0700, Jun Yang wrote: > On Sat, Aug 1, 2009 at 7:53 PM, David Fetter wrote: > > On Sat, Aug 01, 2009 at 06:28:54PM -0700, Jun Yang wrote: > > > Hi all, > > > > > > I want to add some common columns to all of my tables. > > > > Your case may be very special, but

Re: [GENERAL] Can I add a super table to existing tables?

Jun Yang wrote: On Sat, Aug 1, 2009 at 7:53 PM, David Fetter > wrote: On Sat, Aug 01, 2009 at 06:28:54PM -0700, Jun Yang wrote: > Hi all, > > I want to add some common columns to all of my tables. Your case may be very special, but offhand, this soun

Re: [GENERAL] Can I add a super table to existing tables?

On Sat, Aug 1, 2009 at 7:53 PM, David Fetter wrote: > On Sat, Aug 01, 2009 at 06:28:54PM -0700, Jun Yang wrote: > > Hi all, > > > > I want to add some common columns to all of my tables. > > Your case may be very special, but offhand, this sounds like a very > bad idea. What task is it you're tr

Re: [GENERAL] Can I add a super table to existing tables?

On Sat, Aug 01, 2009 at 06:28:54PM -0700, Jun Yang wrote: > Hi all, > > I want to add some common columns to all of my tables. Your case may be very special, but offhand, this sounds like a very bad idea. What task is it you're trying to accomplish? Cheers, David. -- David Fetter http://fette

Re: [GENERAL] Can I add a super table to existing tables?

Andy Colson wrote: Jun Yang wrote: Hi all, I want to add some common columns to all of my tables. One way I think would be to add a super table that contains the common columns to all tables. But is there a way to add a super table to existing tables for them to inherit from? Thanks! Jun

Re: [GENERAL] Can I add a super table to existing tables?

On Sat, Aug 1, 2009 at 6:49 PM, Andy Colson > wrote: Andy Colson wrote: Jun Yang wrote: Hi all, I want to add some common columns to all of my tables. One way I think would be to add a super table that co

Re: [GENERAL] Can I add a super table to existing tables?

Jun Yang wrote: Hi all, I want to add some common columns to all of my tables. One way I think would be to add a super table that contains the common columns to all tables. But is there a way to add a super table to existing tables for them to inherit from? Thanks! Jun as long as the pare

Re: [GENERAL] questions on (parallel) COPY and when to REINDEX

Janet Jacobsen wrote: Hi. We are running a data processing/analysis pipeline that writes about 100K records to two tables on a daily basis. The pipeline runs from about 6:00 a.m. to 10:00 a.m. Our user base is small - about five people. Each accesses the database in a different way (generally

Re: [GENERAL] How to execute external script from a TRIGGER or FUNCTION ?

After hours of search, I searched just some more and I think I found the solution, hope it can be useful to someone else : CREATE LANGUAGE plperlu; CREATE FUNCTION test_perl_external (integer) RETURNS boolean AS $$ $filename = '/tmp/somefile'; if (-e $filename) { return true; }

[GENERAL] Can I add a super table to existing tables?

Hi all, I want to add some common columns to all of my tables. One way I think would be to add a super table that contains the common columns to all tables. But is there a way to add a super table to existing tables for them to inherit from? Thanks! Jun -- Sent via pgsql-general mailing list

Re: [GENERAL] How to execute external script from a TRIGGER or FUNCTION ?

Denis BUCHER wrote: Hello, Denis BUCHER a écrit : I need to execute an external script from Postgresql, it could be in perl, in bash/shell, in whatever... Any help would be appreciated ! I just need a very simple example if possible... I already searched on the web but found nothing... Afte

[GENERAL] questions on (parallel) COPY and when to REINDEX

Hi. We are running a data processing/analysis pipeline that writes about 100K records to two tables on a daily basis. The pipeline runs from about 6:00 a.m. to 10:00 a.m. Our user base is small - about five people. Each accesses the database in a different way (generally using some script - eit

Re: [GENERAL] Drop Cluster

sw...@opspl.com wrote: I believe that command is specific to the debian/ubuntu distributions. in generic postgres, you'd simply stop the server, then delete the contents of the $PGDATA directory I cleared the PGDATA directory like this --> PGDATA="" export PGDATA that just sets the

[GENERAL] Reminder: pgday.eu 2009 Call for Papers

There is just over two weeks until the close of the call for papers for pgday.eu 2009, this years European PostgreSQL conference. If you haven't already, please submit your talk suggestions to pap...@pgday.eu as soon as you can! If you have submitted one already and not received a response, please

Re: [GENERAL] Can I have a look at your TuningWizard generated config file?

For 1024MB = 1024*1024*1024 bytes kernel.shmmax=1073741824 and for ceil(1073741824)/4096) = 262144 which is actually much smaller than the setting that is the default ( 2097152 ) But setting these two to the values above still gives similar error and the pg-server still doesn't start. 2009-08-01

Re: [GENERAL] How to execute external script from a TRIGGER or FUNCTION ?

Hello, Denis BUCHER a écrit : > I need to execute an external script from Postgresql, it could be in > perl, in bash/shell, in whatever... > > Any help would be appreciated ! I just need a very simple example if > possible... > > I already searched on the web but found nothing... After hours of

[GENERAL] How to execute external script from a TRIGGER or FUNCTION ?

Hello everyone, I need to execute an external script from Postgresql, it could be in perl, in bash/shell, in whatever... Any help would be appreciated ! I just need a very simple example if possible... I already searched on the web but found nothing... Denis -- Sent via pgsql-general mailin

Re: [GENERAL] Drop Cluster

sw...@opspl.com wrote: Hi, I believe that command is specific to the debian/ubuntu distributions. in generic postgres, you'd simply stop the server, then delete the contents of the $PGDATA directory I am using CentOS 5 and postgrest 8.1.11 . Could not find the PGDATA directory. :( On my

Re: [GENERAL] MSSQL to PostgreSQL

On Friday 31 July 2009 05:47:39 am Thom Brown wrote: > Hi all, > > We're migrating the contents of an old MSSQL server to PostgreSQL 8.3.7, so > a full conversion is required. Does anyone know of any guides which > highlight common gotchas and other userful information? > > Thanks > > Thom You mi

Re: [GENERAL] Can I have a look at your TuningWizard generated config file?

cat /proc/sys/kernel/shmmax 19 shmmax controls the maximum amount of memory to be allocated for shared memory, (1,999,999,999 in this instance.) http://ps-ax.com/shared-mem.html concerning shmall set shmall parameter for total amount of shared memory pages that can be used system w

Re: [GENERAL] MSSQL to PostgreSQL

On Fri, Jul 31, 2009 at 2:47 PM, Thom Brown wrote: > Hi all, > > We're migrating the contents of an old MSSQL server to PostgreSQL 8.3.7, so > a full conversion is required.  Does anyone know of any guides which > highlight common gotchas and other userful information? > As for other useful inform

Re: [GENERAL] Can I have a look at your TuningWizard generated config file?

Hmm.. not done quite yet it seems :( I tried initially to set shared_buffers to 1024MB but I got this message : 2009-08-01 15:04:46 CESTFATAL: could not create shared memory segment: Invalid argument 2009-08-01 15:04:46 CESTDETAIL: Failed system call was shmget(key=5432001, size=1106247680, 036

Re: [GENERAL] distributing postgresql binaries

Garry Saddington wrote: I have developed an application using Zope and Postgresql and I want to be able to distribute the application with a full database of data so that there are no setup worries for users. The platform is Windows. When I copy the app over to windows XP home, Postgres refuses

Re: [GENERAL] building a binary-portable database

On 1 Aug 2009, at 24:53, Alexy Khrabrov wrote: That's doable of course, but I wonder what would it take to get it to work as-is, when building pg from source on each box, giving their fairly similar characteristics. Or, if time_t is different, would it be a show-stopper? Fairly similar?

Re: [GENERAL] Drop Cluster]

Hi, > > I believe that command is specific to the debian/ubuntu distributions. > > in generic postgres, you'd simply stop the server, then delete the > contents of the $PGDATA directory > > I cleared the PGDATA directory like this --> PGDATA="" export PGDATA Still I get the same error replc

Re: [GENERAL] distributing postgresql binaries

Alan McKay wrote: Why not populate the registry properly? It is not that difficult to do. Good idea, but where do I find the correct entries? Regards Garry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Drop Cluster

Hi, > I believe that command is specific to the debian/ubuntu distributions. > > in generic postgres, you'd simply stop the server, then delete the > contents of the $PGDATA directory I am using CentOS 5 and postgrest 8.1.11 . Could not find the PGDATA directory. :( Will deleting the content

Re: [GENERAL] distributing postgresql binaries

Why not populate the registry properly? It is not that difficult to do. -- “Don't eat anything you've ever seen advertised on TV” - Michael Pollan, author of "In Defense of Food" -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscriptio

[GENERAL] distributing postgresql binaries

I have developed an application using Zope and Postgresql and I want to be able to distribute the application with a full database of data so that there are no setup worries for users. The platform is Windows. When I copy the app over to windows XP home, Postgres refuses to start and I get a cr

Re: [GENERAL] Drop Cluster

sw...@opspl.com wrote: Hi, Is there any command to drop a postgres cluster??? I tried the following link http://www.digipedia.pl/man/pg_dropcluster.8.html but it says command not found. Is there any other way?? Any help will be highly appreciated. I believe that command is specific to t