[ADMIN] Data Recovery - 6.4.2 to 6.5.3 disk file translation

2000-03-23 Thread Thomas Dean
I was running version 6.4.2 when I lost all the binaries. I still have all the data/* and data/base/* files. The port for FreeBSD is 6.5.3. I have it installed, now. The disk file formats changed between version 6.4.2 and 6.5.3. Is there a tool or mechanism to translate these files into a for

[ADMIN] receiving mail in my outbox

2000-03-23 Thread Edna M. Renyolds
I have just started receiving some mail in my Outbox.  I have 2 e-mail friends whose e-mail comes into my outbox?  Can you help?

[ADMIN] pgsql-admin: disallowing CREATE TABLE

2000-03-23 Thread Keith Dreibelbis
Hello, I want to make a user that has read-only access to a database. I've read the man pages on grant and revoke for table-level permissions, but I don't see anything for database-level permissions on, say, creating tables or views. Suppose I want to deny CREATE to some user. How does postgre

Re: [ADMIN] pgsql-admin: disallowing CREATE TABLE

2000-03-23 Thread Thomas Dean
If I understand your question correctly, createuser will do this. 'man createuser' ... -D Does not allow the user to create databases.

Re: [ADMIN] pgsql-admin: disallowing CREATE TABLE

2000-03-23 Thread Oliver Elphick
Thomas Dean wrote: >If I understand your question correctly, createuser will do this. > >'man createuser' >... > -D Does not allow the user to create databases. This does not affect the ability to create tables; only databases: junk=> alter user dan nocreatedb; ALTER USER

[ADMIN] How many base

2000-03-23 Thread grzegorz . przezdziecki
Welcome How many bases I can storage on serwer. Best Regards

Re: [ADMIN] Postgres vs. Informix

2000-03-23 Thread Ron Chmara
Bruce Momjian wrote: > > Benchmarked against the champ of fast table scanning: > > > http://www.mysql.com/benchmark.html > > > > That is funny! Well, I use mySQL when I need super fast, single table, db's looking through the speed tests,