On 12/20/05, Francisco Reyes <[EMAIL PROTECTED]> wrote:
> Jaime Casanova writes:
>
> > - you still have the server where these databases exists?
>
> No. I lost 3 databases.
>
> > - what version of pgsql, is this?
>
> It was 8.0.4
> I was upgrading to 8.1.
> I checked the nightly jobs had been runni
Jaime Casanova writes:
- you still have the server where these databases exists?
No. I lost 3 databases.
- what version of pgsql, is this?
It was 8.0.4
I was upgrading to 8.1.
I checked the nightly jobs had been running, then ran a manual one and
proceeded to do the upgrade.
pg_dumpall
On 12/19/05, Francisco Reyes <[EMAIL PROTECTED]> wrote:
> Michael Fuhr writes:
>
> > On Sun, Dec 18, 2005 at 11:29:13PM -0500, Francisco Reyes wrote:
> >> Any reason why a database would not get dumped by pg_dumpall?
> >> Always run pg_dumpall as the superuser.
> >
> > As the operating system super
Michael Fuhr writes:
On Sun, Dec 18, 2005 at 11:29:13PM -0500, Francisco Reyes wrote:
Any reason why a database would not get dumped by pg_dumpall?
Is there a way to check the successfull completion of pg_dumpall.
Loosing 3 databases is not an experience I want to repeat.
Perphaps it returns
Michael Fuhr writes:
On Sun, Dec 18, 2005 at 11:29:13PM -0500, Francisco Reyes wrote:
Any reason why a database would not get dumped by pg_dumpall?
Always run pg_dumpall as the superuser.
Researched what was lost. It seems that all databases after a particular
database, called test, were no
Michael Fuhr writes:
On Sun, Dec 18, 2005 at 11:29:13PM -0500, Francisco Reyes wrote:
Any reason why a database would not get dumped by pg_dumpall?
Always run pg_dumpall as the superuser.
As the operating system superuser or as a database superuser?
There's a difference.
As the database sup
On Sun, Dec 18, 2005 at 11:29:13PM -0500, Francisco Reyes wrote:
> Any reason why a database would not get dumped by pg_dumpall?
> Always run pg_dumpall as the superuser.
As the operating system superuser or as a database superuser?
There's a difference.
> I do a nightly dump and have checked sev
Any reason why a database would not get dumped by pg_dumpall?
Always run pg_dumpall as the superuser.
I do a nightly dump and have checked several days so far and the database is
missing in all so far. :-(
The only thing, for that DB, that got backed up was the database, but not a
single tabl
