Re: [GENERAL] Re: PostgreSQL 7.0 a success

On Wed, 24 May 2000, Gustavo Henrique wrote:

> First of all,
> Let me say I dont have much experience with postgresql and I've
> done only few tests, so excuse me for any wrong comments i make.
>
> I think the following things should be improved in postgresql now:
>
> - reliability
> - Documentation
>
> Sometimes a table doesnt exist anymore but it's still listed in
> pg_class table, or the opposite, or you did a physical backup and you
> wanna restore the db, and other things that could be improved and more
> documented.

example? some way to recreate for debugging?

> Some crashes we tested (like powering down the system while running
> with flush off) were just fatal to some tables, and after restart we
> got the 'backend terminated...' message when trying to use the table.
> We also tried a dump after restarting, but other processes that
> started after the dump were frozen, waiting for the dump to complete.

operating system? I've had 'hard crashes' on my servers in the past, with
older versions of PostgreSQL, and not seen this :(

> I also miss something like mysql's isamchk and a better control of the
> security, with 1 system table controlling passwords, hosts allowed and
> denied, and anything for the users of all databases.

pg_hba.conf?