Hi Tom,
I tried to reproduce the problem once more creating a new blank database and
some tables with constraints.
I could not reproduce the problem. I then went back and tried to reproduce the
problem with the original database.
Now I can not reproduce even that although it happened multiple ti
On Sat, 25 Jun 2005, Bruce Momjian wrote:
And here's one other question..is it safe to ignore the: pgsql_tmp directories
when doing the base backup?
Yes, those are used only by running backups, but they should have little
disk space in them.
Bruce,
Thanks! I actually ask not because of dis
Jeff Frost wrote:
> On Thu, 23 Jun 2005, Jeff Frost wrote:
>
> > I guess I forgot to ask one other question. If the archived wal files are
> > streamed in one by one, would it still be safe to leave the pg_xlog
> > directory
> > intact in the base backup? What would happen with the out of dat
Alberto <[EMAIL PROTECTED]> writes:
> I would definetely be willing to create a self contained test case but I
> am not sure what that would be. I can create a dump file from a test
> database, but that would be after using pg_dump so you could not check
> that. Do you want me to create a databa
On Thu, 23 Jun 2005, Jeff Frost wrote:
I guess I forgot to ask one other question. If the archived wal files are
streamed in one by one, would it still be safe to leave the pg_xlog directory
intact in the base backup? What would happen with the out of date log files?
Would they just stay in
Hi Tom,
thanks for answering so quickly!
The error occurs for me using pg_dump and pg_restore on postgres 8.0.3
running on RedHat ES4. But also occurs if I take the dump from the Linux
box and run restore on a winxp box with postgres 8.0.2.
I would definetely be willing to create a self conta
David Bear <[EMAIL PROTECTED]> writes:
> However, a netstat -l tells me:
> netstat -l | grep 5432
> unix 2 [ ACC ] STREAM LISTENING 732094 /tmp/.s.PGSQL.5432
> netstat -l | grep postg
> tcp0 0 localhost:postgresql*:* LISTEN
> tcp0 0 localhost:postgr
Hoping to get postgresql to listen on a tcp socket I made the
following change to postgresql.conf:
#listen_addresses = 'localhost' # what IP interface(s) to listen on;
listen_addresses = 'localhost' # what IP interface(s) to listen on;
# defaults to localhost, '*' = any
#port = 5432
port = 5432
Alberto <[EMAIL PROTECTED]> writes:
> I have tried to backup my postgres database with
>pg_dump -Fc $db > ~/backups/$db.backup.c
> and restore it with:
>createdb -U postgres -D aestel_admin -T template0 restoreTMP
>pg_restore -d restoreTMP -U postgres $db.backup.c
> I do not get any e
Hi everybody,
I have tried to backup my postgres database with
pg_dump -Fc $db > ~/backups/$db.backup.c
and restore it with:
createdb -U postgres -D aestel_admin -T template0 restoreTMP
pg_restore -d restoreTMP -U postgres $db.backup.c
I do not get any error messages but none of my indexes
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (hellz waren) would
write:
> we are designing a heavy duty database in pgsql that
> expects to grow at an average of 100 MB spread over
> tables of 250 tables.
>
> We require always on database (24 X 7) database. And
> if one fails, the ot
Sounds like slony is what you're looking for:
http://slony.info/
On Sat, 25 Jun 2005, hellz waren wrote:
Could you someone tell me if there's any open source
project that enables real time replication of data
back up.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC htt
hi,
we are designing a heavy duty database in pgsql that
expects to grow at an average of 100 MB spread over
tables of 250 tables.
We require always on database (24 X 7) database. And
if one fails, the other one needs to start up.
Could you someone tell me if there's any open source
project tha
13 matches
Mail list logo
