Joel Fradkin writes:
> Hi,
>
>
>
> We are in development stage of implementing postgres.
>
> Our data center is in Tampa and we are in Bardenton and I am using DSL at my
> office (384 up, 1.5 down).
>
> Data center is 2 meg ea way.
>
> When I use pgadmin to connect it is ok, but as soon as I
Daniel Rubio writes:
> Hi all!
>
> We want to obtain the size of the diferent schemas of some databases.
> We've installed dbsize and it works fine, but it returns the size of all
> the database.
> Exists some method to determine the size of a concrete schema?
>
I use
SELECT nspname,
sum(relpa
Geoffrey writes:
> guly wrote:
> > I have installed postgresql in /usr/local filesystem on RH Linux. But
> > Running for two months,the datas are growing too fast.There is no enough
> > space at /usr/local filesystem. I want to make this filesystem bigger or
> > move the database to another
Simon Riggs writes:
> >Mark Reidenbach wrote
>
> >The problem I'm having is that you need to
> > backup this wal
> > file before it's been archived to have a backup which is
> > consistent
>
> Not sure I agree. Can you explain some more?
>
> Is it that you have a very low transaction rate and lo
Mark Reidenbach writes:
> The PITR documentation recommends that a user's archive command should
> not overwrite an existing wal archive file, but it appears you need at
> least the wal archive file that matches the .backup marker for the
> recovery process to succeed. This makes sense because
Pallav Kalva writes:
>
> If I want to restore to a particular point in time lets say to the
> point in time like a day back when one of my table was dropped
> accidentally and if i want restore the archive log only to that
> particular archive log file . what is the procedure we should foll
Tom Lane writes:
Thanks for your answer Tom, and also thanks to the others, that answered.
> > The documentation says
> > ' To make use of this backup, you will need to keep around all the
> > WAL segment files generated at or after the starting time of the backup. '
> > Now I'm wondering how m
Hi,
I'm currently considering to use postgresql 8.0 online backups.
The documentation says
' To make use of this backup, you will need to keep around all the
WAL segment files generated at or after the starting time of the backup. '
Now I'm wondering how much of these WAL segment files do I re
