you might want to try "lock dpa in exclusive mode;"
--
Simone Tellini
E-mail: [EMAIL PROTECTED]
http://www.areabusiness.it
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I get an error like this every time I try to modify a database (with update/insert/drop
index...)
What's happened? Can I fix it? how?
It's postgres 7.1.3, btw
--
Simone Tellini
E-mail: [EMAIL PROTECTED]
http://www.areabusiness.it
---(end of
(ie. nobody,
www, apache, whatever...)
The only way I see is to use password authentication.
--
Simone Tellini
E-mail: [EMAIL PROTECTED]
http://www.areabusiness.it
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
e databases from a
cron script if you use password authentication, for instance.
It would be nice to have those fixed for good. ;-)
--
Simone Tellini
E-mail: [EMAIL PROTECTED]
http://www.areabusiness.it
---(end of broadcast)---
TIP
export PGDATA=/var/lib/pgsql/data, then
pg_upgrade -1
--
Simone Tellini
E-mail: [EMAIL PROTECTED]
http://www.areabusiness.it
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
oh, btw, the \r\n newlines are part of the content of the text field,
they were *in* the database and I expect them to stay there after I
restore the backup :-)
They were not converted after the dump had been generated, if you
suspect this.
--
Simone Tellini
E-mail: [EMAIL PROTECTED]
http://w
s working under linux: I dumped the db with pg 7.1.3 and tried
to restore it under 7.2, on the same machine.
The dump has only been gzipped by my backup script (pg_dumpall | gzip)
and then decompressed (gzip -d), but this shouldn't have modified it at
all.
--
Simone Tellini
E-mail: [E
or is it used for something?)
--
Simone Tellini
E-mail: [EMAIL PROTECTED]
http://www.areabusiness.it
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
mands at the top of the dump to lowercase,
restore it and then rename the users (if it's possible).
--
Simone Tellini
E-mail: [EMAIL PROTECTED]
http://www.areabusiness.it
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
then, as it completely
failed to recover a database following the records of that table: you
can see the error lines when it tried to create the tables in that db,
without having created it. Obviously it also skipped the rest of the
dump of the previous db.
It seems I'll stick to 7.1.3 for a w
On Sat, 09 Feb 2002 23:23:20 +0100
Simone Tellini <[EMAIL PROTECTED]> wrote:
ST> ST> will try to /connect TestMe, which will give the error "database testme
ST> ST> doesn't exists"
ST> I've forgot: the same applies to mixed case usernames.
...ok, m
On Sat, 09 Feb 2002 22:56:16 +0100
Simone Tellini <[EMAIL PROTECTED]> wrote:
ST> won't be able to restore it from a dump nor use pg_upgrade as the dump
ST> will try to /connect TestMe, which will give the error "database testme
ST> doesn't exists"
I'v
Hi,
if you have a database whose name has capital letters (eg. TestMe), you
won't be able to restore it from a dump nor use pg_upgrade as the dump
will try to /connect TestMe, which will give the error "database testme
doesn't exists"
--
Simone Tellini
E-mail: [E
s :) The error happens
after a lot of files are extracted.
I just remembered seeing a similar corruption problem reported here, so
I was asking whether anyone had succesfully unpacked all the files from
the archive found there.
--
Simone Tellini
E-mail: [EMAIL PROTECTED]
htt
d it again?
--
Simone Tellini
E-mail: [EMAIL PROTECTED]
http://www.areabusiness.it
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
r the restore.
Hopefully one shouldn't need to restore everything so often.
--
Simone Tellini
E-mail: [EMAIL PROTECTED]
http://www.areabusiness.it
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
Hi,
I'm using pg_dumpall to do periodic backups. I just changed the config
of my test machine to use password authentication instead of 'trust'
and this system doesn't work anymore, as pg_dumpall requires the
passwords for every db I have...
Is there a way to work aroun
s,
so I'm a bit clueless now (the only difference is that the working one
is using Mandrake 7.0, while my home box has 7.2)
Is there anything I could check or any switch to set?
--
Simone Tellini <[EMAIL PROTECTED]>
---(end of broadcast)---
18 matches
Mail list logo