On Mon, 2004-04-26 at 23:43, Bruce Momjian wrote:
> David Garamond wrote:
> > >>Now suppose /disk1 fails, one of the shadow can be configured to
> > >>immediately take over as the master database, without any down time. We
> > >>can then add /disk4/dbname.fdb, for instance, to become a new shadow
SELECT oid,relname FROM pg_class WHERE oid>=1;
gives me this output.
oid| relname . . .
-
125538806 | tmp_table1 . . .
125538808 | pg_toast_125538806
125538810 | pg_toast_125538806_index . .
It seems that triggers are not inherited, so to get the functionality I
want I'll have to create a trigger for each table. If anyone knows
another way, please let me know!
After you pointed me in the right direction, I was able to create a
trigger procedure which can be called from triggers on
Robert Treat wrote:
> On Mon, 2004-04-26 at 23:43, Bruce Momjian wrote:
> > David Garamond wrote:
> > > >>Now suppose /disk1 fails, one of the shadow can be configured to
> > > >>immediately take over as the master database, without any down time. We
> > > >>can then add /disk4/dbname.fdb, for in
what's wrong with this?
create type tSession
as ( ty_found boolean, ty_Session char(32) );
create or replace function GetSessionID( integer )
returns tSession as '
declare
thisSession tSession;
begin
--HERE!!!
thisSession := ( ''t'', md5( now( ) || rand( )
At 09:53 AM 4/27/2004 -0400, Bruce Momjian wrote:
> > > Actually, what is needed is:
> > >
> > > - an exact mirror at all times;
> > > - a very simple, straightforward, and fast way to failover;
> > >
> > > done by software.
They can do hardware mirroring, or software/OS mirroring. Why put that
in
Dear group,
I would like to know where I could find rpms for
Redhat 7.3. I have looked at the downloads page and I see only source
rpms and rpms for Redhat 9 and FC1. I did download the src rpm and when
I run the rpm -ba postgresql.spec I get the following error message:
On Apr 26, 2004, at 3:12 PM, Timothy Perrigo wrote:
I'm trying to set up some basic rules to log inserts, updates, and
deletes to tables in an inheritance hierarchy (by inserting records
into a log table), and I've got a couple of questions.
(1) Is it possible to create a rule on a base table a
On 4/26/04 3:25 PM, "Glen Parker" <[EMAIL PROTECTED]> wrote:
> Sounds an aweful lot like RAID level one :-) Why would a DB system need to
> do what RAID already does quite well?
One case I can think of is where the shadow is on a separate system (e.g. a
SAN or NetApps, another linux box, etc.).
[EMAIL PROTECTED] wrote:
> pg_dumpall > backup
> from 7.4 trying: pg_restore backup
> results in postgres' [Archiver]s suspicion that "backup"
> was not a valid archive.
What you backup by pg_dumpall is to be restored using psql, not
pg_restore. Read the man pages of pg_dump and pg_dumpall to co
David Garamond wrote:
> Actually, what is needed is:
>
> - an exact mirror at all times;
> - a very simple, straightforward, and fast way to failover;
>
> done by software.
http://www.drbd.org/ works well for us and can be set up quickly and
from commodity parts.
---(end
On Mon, 26 Apr 2004 10:22:36 -0700 Andrew Ayers <[EMAIL PROTECTED]> sat down,
thought long and then wrote:
> Bill Moran wrote:
> > Stephen Salbod wrote:
> >
> >> My background is Windows and I just switched, yesterday to, Suse Linux
> >> Professional 9.0. And I have a class project due Monday, w
Ivan Sergio Borgonovo wrote:
what's wrong with this?
create type tSession
as ( ty_found boolean, ty_Session char(32) );
create or replace function GetSessionID( integer )
returns tSession as '
declare
thisSession tSession;
begin
--HERE!!!
thisSession := ( ''t
William Sweet wrote:
> support is enabled. Now, I'd like to only store Unicode chars in my
> PostgreSQL dbs. I hear there are 3 ways to accomplish this:
>
> 1) during PostgreSQL configure/build (installation level)
> 2) during initdb (cluster level)
> 3) CREATE DATABASE (db level)
Each one of thes
We’re implementing our first PostgreSQL database, and
enjoying it very much. However, we have a table that will store binary
image files (pie charts, etc.) for later display on a dynamic webpage. While
we’re putting together our prototype application, I’ve been asked
by the programmers (I
Ron St-Pierre wrote:
Ivan Sergio Borgonovo wrote:
what's wrong with this?
create type tSession
as ( ty_found boolean, ty_Session char(32) );
create or replace function GetSessionID( integer )
returns tSession as '
declare
thisSession tSession;
begin
--HERE!!!
thisSession := ( ''
If you are using php, the two functions below should help.
http://ca.php.net/manual/en/function.pg-escape-bytea.php
http://ca.php.net/manual/en/function.pg-unescape-bytea.php
Taber, Mark wrote:
We’re implementing our first PostgreSQL database, and enjoying it very
much. However, we have a table th
On Tue, 27 Apr 2004 19:08:12 +0200 Frank Finner <[EMAIL PROTECTED]> sat down,
thought long and then wrote:
> After having installed the SuSE shipped PostgreSQL packages, you simply have
> to start the database as root with "rcpostgresql start". If the database is
> not initialized, the startup scr
On Tue, 27 Apr 2004 10:12:13 -0700
Ron St-Pierre <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo wrote:
> > --HERE!!!
> > thisSession := ( ''t'', md5( now( ) || rand( ) ) );
> >
> - md5 takes TEXT as an argument, not a numeric type
Since it works you surely fixed my code but this shou
Ivan Sergio Borgonovo wrote:
On Tue, 27 Apr 2004 10:12:13 -0700
thisSession := ( ''t'', md5( now( ) || rand( ) ) );
- md5 takes TEXT as an argument, not a numeric type
Since it works you surely fixed my code but this should't be an issue
since I tried
test1=# select md5( now( ) || r
Hi
I want to be preserve a log of all SQL actions that change a database, (ie
INSERT, UPDATE, DELETE, CREATE), to provide a full audit trail of the date,
and to allow the recreation of a database at any time.
I can achieve this wth ORACLE(recover and others) and MySQL(mysqlbinlog) quite
easily
On Fri, 23 Apr 2004, Jerry Robertson wrote:
> We have been running Postgre for over a year and are very pleased with its ease of
> use and performance.
>
> We have encountered one problem that has been minor until today and that is:
>
> Occasionally a row in a table get populated with #Deleted
"scott.marlowe" <[EMAIL PROTECTED]> writes:
> When postgresql "deletes" a tuple prior to it being vacuumed, it simply
> sets a time stamp on it that vacuum can use to see it is "deleted" and no
> longer visible. If you are actually getting back tuples with the words
> #Deleted in them, then I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I've just upgraded a production database from 7.3.4 to 7.4.2.
I 'sometimes' get the following error while executing a PHP code:
"mdfd_getrelnfd cannot open relation pg_cast_source_target_index"
Quoted 'sometimes', since I really get this error
I have a question about locks.
I have a stats table that get updated when some other table changes.
Sometimes that other table is updated a 2nd time before the first stats
update is finished which causes an error. I've tried using 'SET
TRANSACTION ISOLATION LEVEL SERIALIZABLE' but get 'could
Hi,
i wrote a php skript to test this, works beautiful,
you can download the script at
http://www.erdtrabant.de/index.php?i=500200104
volker
Guy Fraser wrote:
If you are using php, the two functions below should help.
http://ca.php.net/manual/en/function.pg-escape-bytea.php
http://ca.php.net/manual
Jerry:
I bet you are using Microsoft Access to view the data. From what I
remember, Access prints #Deleted if the record that you try to update
gets deleted (or if the primary key for the record gets updated) while
you are looking at it. In other words, if you are looking at the
record that
Alvaro Herrera wrote:
On Mon, Apr 26, 2004 at 12:48:45PM -0700, Dann Corbit wrote:
Maple output:
y := 123456789012345678901234567890 mod 123;
y := 117
PgSQL 7.3.6 gives the right answer (117), 7.4 gets it wrong (-6). Most
likely a bug was introduced when NUMERI
Simon Windsor wrote:
> Hi
>
> I want to be preserve a log of all SQL actions that change a database, (ie
> INSERT, UPDATE, DELETE, CREATE), to provide a full audit trail of the date,
> and to allow the recreation of a database at any time.
>
> I can achieve this wth ORACLE(recover and others) a
Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> I've just upgraded a production database from 7.3.4 to 7.4.2.
> I 'sometimes' get the following error while executing a PHP code:
> "mdfd_getrelnfd cannot open relation pg_cast_source_target_index"
There is no such message text in 7.4.*. Better double-c
[EMAIL PROTECTED] wrote:
died it caused corruption elsewhere. I have also seen (a couple of times) a
controller go bad and proceed to write garbage all over the disks. The
mirroring worked quite well - we had a very nice file system full of
mirrored garbage.
Does this mean software RAID is actual
On 4/27/04 11:48 PM, "David Garamond" <[EMAIL PROTECTED]> wrote:
> Does this mean software RAID is actually safer than hardware RAID?
> (Since the OS and processor is usually more reliable than a disc
> controller).
I'm not sure I would jump to that conclusion. If a controller went bad and
trash
32 matches
Mail list logo