Re: [ADMIN] Renaming a DB

2003-07-20 Thread Bruce Momjian
Oh, I forgot that the backends are reading the raw disk files to find database names. Thanks. --- Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom, why was a VACUUM FULL required? > > I doubt that it was

Re: [ADMIN] Renaming a DB

2003-07-20 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom, why was a VACUUM FULL required? I doubt that it was; a VACUUM would have sufficed to fix the tuple commit bits. What I forgot to recommend was a CHECKPOINT to make sure the fixed pages got dumped to disk. (Until they're written out to the kernel,

Re: [ADMIN] Renaming a DB

2003-07-20 Thread Bruce Momjian
Tom Lane wrote: > "Mendola Gaetano" <[EMAIL PROTECTED]> writes: > > I'm running a Postgres 7.3.3 and I had the necessity to > > rename a DB, I did this by updating the pg_database > > table. > > If I perform psql -l I'm able to see that is reported the > > correct name ( I guess because a select o

[ADMIN] PG_dump fatal error (second post)

2003-07-20 Thread Nick Fankhauser
Hello- I'm reposting this problem because I didn't receive any responses to the first post that led to a resolution- Perhaps this is a bug, but I'll give it another chance here before promoting it to the bugs list. Since sending the information below, I've set up a nearly identical system on anot

Re: [ADMIN] news.us.postgresql.org

2003-07-20 Thread The Hermit Hacker
no, so far, we ahven't been able to get teh news2mail gateway to work ... On Sun, 20 Jul 2003, Mendola Gaetano wrote: > Hi all, > Are the messages posted to this new server sended to > mailing list too ? > > Thank you > Gaetano > > > > ---(end of broadcast)---

Re: [ADMIN] Help with privilege or pg_hba.conf

2003-07-20 Thread Daniel Seichter
Hello, > I've been trying to modify "pg_hba.conf" but with no luck as user > "cool", after I connect to the DB server via psql and I do "\c anotherdb", > user "cool" can still connect to "anotherdb". > my "pg_hba.conf" can be found at http://ahouans.sh.cvut.cz/pg_hba.txt I think, you should n

[ADMIN] news.us.postgresql.org

2003-07-20 Thread Mendola Gaetano
Hi all, Are the messages posted to this new server sended to mailing list too ? Thank you Gaetano ---(end of broadcast)--- TIP 8: explain analyze is your friend