On Mon, 25 Aug 2008 21:57:52 +0200
Joris Dobbelsteen <[EMAIL PROTECTED]> wrote:
> The 'regular interface', that you will find in the documentation,
> ensures that the assumptions remain valid. It will not allow
> changes that cause these assumption to become invalid.
> (As a side note: you might
Phoenix Kiula wrote:
> On 8/26/08, Phoenix Kiula <[EMAIL PROTECTED]> wrote:
>> On 8/26/08, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>> >
>> > Slony replication lets postgresql accomplish this, which is really
>> > quite impressive. We just upgraded from an 8.1 server to an 8.3
>> > server v
Hi there,
i'm looking at building a series of web forms for maintaining data
stored in postgis.. and am wondering if there is some form of
python/php/java development environment (free or commercial) similar
to oracle's application express (aka HTML DB) that handles the generic
form style function
Bonjour,
J'ai un trigger (AFTER FOR EACH ROW) sur une table qui à chaque fois
qu'il y a un enregistrement sur cette même table, exécute une fonction
pgplsql qui éxécute elle-même une fonction PL/sh qui exécute un script
PHP.
Dans ce script PHP, je créer 10 enregistrements dans une autre tables où
Mark Roberts írta:
> On Mon, 2008-08-25 at 11:02 -0600, Scott Marlowe wrote:
>
>> Well, of course a 64 bit int is gonna be bigger than a 32 bit, but
>> with alignment issues and on 64 bit hardware, I'm guessing the
>> difference isn't exactly twice as slow / twice as much storage. And
>> it's w
Samuel ROZE a écrit :
> [...]
> J'ai un trigger (AFTER FOR EACH ROW) sur une table qui à chaque fois
> qu'il y a un enregistrement sur cette même table, exécute une fonction
> pgplsql qui éxécute elle-même une fonction PL/sh qui exécute un script
> PHP.
>
> Dans ce script PHP, je créer 10 enregist
Le mardi 26 août 2008 à 11:01 +0200, Guillaume Lelarge a écrit :
> Samuel ROZE a écrit :
> > [...]
> > J'ai un trigger (AFTER FOR EACH ROW) sur une table qui à chaque fois
> > qu'il y a un enregistrement sur cette même table, exécute une fonction
> > pgplsql qui éxécute elle-même une fonction PL/sh
>
> You need to download Slony 1.2.14, which supports both 8.2 and 8.3.
> You'll find it under Quick downloads.
>
Ok done. Slony is installed. Now what? How should I install a new
database which is 8.3.3?
I was also told that the postgresql.conf settings across 8.2 and 8.3
are different so I
On 2008-08-26 13:39, Phoenix Kiula wrote:
> Ok done. Slony is installed. Now what?
http://www.slony.info/documentation/versionupgrade.html
I think nobody would guide you step by step. Either read documentation
and do it yourself or hire an expert:
http://www.postgresql.org/support/professional_su
On 8/26/08, Tomasz Ostrowski <[EMAIL PROTECTED]> wrote:
>
> I think nobody would guide you step by step. Either read documentation
> and do it yourself or hire an expert:
Thanks. I suppose that spirit is quite evident in the documentation.
Why make it easy or easily understandable when you can
On Tue, Aug 26, 2008 at 5:02 AM, Tomasz Ostrowski
<[EMAIL PROTECTED]> wrote:
> http://www.slony.info/documentation/versionupgrade.html
> I think nobody would guide you step by step.
Well they may, then is nothing wrong with asking especially when
"breaking new ground." Since my databases are cur
On Mon, Aug 25, 2008 at 08:36:34PM -0600, Scott Marlowe wrote:
> Slony replication lets postgresql accomplish this, which is really
> quite impressive.
Pleased as I am to hear accounts of Slony being used successfully to
solve the upgrade problem -- it was one of our design goals in the
early di
On Tue, Aug 26, 2008 at 5:31 AM, Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> I suppose that spirit is quite evident in the documentation.
All kidding aside, the problem that you are having IS recognized as a
weakness with PostgreSQL. This is why some are already working on
solving the problem of i
On Tue, Aug 26, 2008 at 5:39 AM, Phoenix Kiula <[EMAIL PROTECTED]> wrote:
>>
>> You need to download Slony 1.2.14, which supports both 8.2 and 8.3.
>> You'll find it under Quick downloads.
>>
>
>
>
> Ok done. Slony is installed. Now what? How should I install a new
> database which is 8.3.3?
Whi
On Tue, Aug 26, 2008 at 6:31 AM, Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> On 8/26/08, Tomasz Ostrowski <[EMAIL PROTECTED]> wrote:
>>
>> I think nobody would guide you step by step. Either read documentation
>> and do it yourself or hire an expert:
>
>
> Thanks. I suppose that spirit is quite ev
[EMAIL PROTECTED] ("Phoenix Kiula") writes:
> See, this is where I get confused. I want to upgrade from 8.2.3 to
> 8.3.3. The recommendation is to try Slony. So I download Slony and try
> to configure it. The configure command gives me this:
>
>
>
> checking for correct version of PostgreSQL..
On Tue, Aug 26, 2008 at 12:10 AM, Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> On 8/26/08, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>>
>> Slony replication lets postgresql accomplish this, which is really
>> quite impressive. We just upgraded from an 8.1 server to an 8.3
>> server via slony, and
[EMAIL PROTECTED] ("Phoenix Kiula") writes:
> On 8/26/08, Tomasz Ostrowski <[EMAIL PROTECTED]> wrote:
>>
>> I think nobody would guide you step by step. Either read documentation
>> and do it yourself or hire an expert:
>
> Thanks. I suppose that spirit is quite evident in the documentation.
> Wh
On Aug 26, 2008, at 10:22 AM, Scott Marlowe wrote:
On Tue, Aug 26, 2008 at 12:10 AM, Phoenix Kiula <[EMAIL PROTECTED]
> wrote:
On 8/26/08, Scott Marlowe <[EMAIL PROTECTED]> wrote:
Slony replication lets postgresql accomplish this, which is really
quite impressive. We just upgraded from an 8
On Tue, Aug 26, 2008 at 2:41 AM, Ivan Price <[EMAIL PROTECTED]> wrote:
> If anyone knows of such a thing i'd greatly appreciate some advice..
Gedafe - http://isg.ee.ethz.ch/tools/gedafe/index.en.html
DaDaBIK - http://www.dadabik.org/
Good luck.
--
Sent via pgsql-general mailing list (pgsql-gen
I fear I have a corrupted database, and I'm not sure what to do.
Environment:
Windows Server 2003
8GB RAM
Dual processor, quad core 2.6Ghz
Postgres 8.2.3 (The IT dept wants to upgrade to 8.2.9, but they are
asking me what to do about this corrupt database before they proceed)
The
Hi -
Was wondering if anyone could help / had some thoughts. I am building
a model for a client, and right now doing customer attrition
modeling. Basically, the number of customers in this period is equal
to:
Beg # Customers
+ customers added this period
- attrition
Ending # Customers
Obviousl
>From the following link:
http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html#BACKUP-BASE-BACKUP
Step 3 says to perform the back up.
Does this mean a File System Backup of the Data directory?
OR
Does this mean performing a pg_dumpall and backing up the dump file?
--
ktr73 wrote:
Hi -
Was wondering if anyone could help / had some thoughts. I am building
a model for a client, and right now doing customer attrition
modeling. Basically, the number of customers in this period is equal
to:
Beg # Customers
+ customers added this period
- attrition
Ending # Cust
Hi Richard,
This means a file systems backup. eg.
tar -cvpf data_bakup.tar /var/lib/pgsql/data
Here's a script I use to automate this process. It may be helpful to
customize for yourself.
#!/bin/bash
#
# PostgreSQL Weekly Backup
#
DATE=$(date +%G%m%d)
MAILLOG="/backup/weekly_$DATE.log"
WALAR
On Tue, Aug 26, 2008 at 6:53 PM, Richard Broersma
<[EMAIL PROTECTED]> wrote:
> From the following link:
> http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html#BACKUP-BASE-BACKUP
>
> Step 3 says to perform the back up.
>
>Does this mean a File System Backup of the Data direct
On Tue, Aug 26, 2008 at 5:19 PM, <[EMAIL PROTECTED]> wrote:
> This means a file systems backup. eg.
>
> tar -cvpf data_bakup.tar /var/lib/pgsql/data
Thanks also for the script. I will take a close look.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
ht
On Tue, Aug 26, 2008 at 5:38 PM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> If you ever want to mess around with log
> shipping I strongly suggest you go through the motions of setting up a
> warm standby vi the pg_standby utility and practice popping the
> standby out of recovery.
Thanks for t
William Garrison wrote:
> I fear I have a corrupted database, and I'm not sure what to do.
First, make sure you have a recent backup. If your backups rotate, stop
the rotation so that all currently available historical copies of the
database are preserved from now on - just in case you need them.
Hi All
How I can connect a postgre database on another postgre database, and
manipulate the datas on both database?
Thanks!!
On Aug 26, 2008, at 7:10 PM, Anderson dos Santos Donda wrote:
How I can connect a postgre database on another postgre database,
and manipulate the datas on both database?
There is a module in contrib just for such a purpose:
http://www.postgresql.org/docs/8.3/interactive/dblink.html
Thanks man!!
I'll study this module!!
On Tue, Aug 26, 2008 at 11:19 PM, Christophe <[EMAIL PROTECTED]> wrote:
>
> On Aug 26, 2008, at 7:10 PM, Anderson dos Santos Donda wrote:
>
>> How I can connect a postgre database on another postgre database, and
>> manipulate the datas on both database?
>>
I traced a bug in our application down to this basic operation:
set timezone to 'US/Eastern';
select '11/02/2008'::timestamptz, '12:10'::time,
'11/02/2008'::timestamptz + '12:10'::time;
I have a date and a time stored separately and I want to combine them,
and use them in some timezone-aware cal
Adam Rich <[EMAIL PROTECTED]> writes:
> I traced a bug in our application down to this basic operation:
> set timezone to 'US/Eastern';
> select '11/02/2008'::timestamptz, '12:10'::time,
> '11/02/2008'::timestamptz + '12:10'::time;
> I have a date and a time stored separately and I want to combin
Hi,
Anderson dos Santos Donda wrote:
Thanks man!!
I'll study this module!!
You should also be aware that sometimes instead of
connecting two separate databases via dblink or similar,
two schemas in one database can be used instead.
It really depends on what you are really doing if
there are
35 matches
Mail list logo
