[ADMIN] Data Recovery - 6.4.2 to 6.5.3 disk file translation
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 format acceptable to version 6.5.3? The only way I see is to download version 6.4.2, install it, dump the databases, install version 6.5.3, and, load the dumped data. There must be a better (simpler) way. tomdean
[ADMIN] receiving mail in my outbox
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
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 postgres do this? I'm using 6.5.3-12 on debian linux. I thought maybe I could fake it by doing a REVOKE on a system table (say, pg_class or pg_tables) but that doesn't seem to work. I have a suspicion that it may be unimplemented and planned for a future version; http://www.postgresql.org/docs/todo.html says a planned enhancement for admin is "More access control over who can create tables and access the database". I'm hoping this is not the same as what I am talking about, but thought someone here might know for certain. Thanks, -kd
Re: [ADMIN] pgsql-admin: disallowing CREATE TABLE
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
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 junk=> \connect - dan connecting as new user: dan junk=> create table (id integer); CREATE -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID 32B8FAA1 "Jesus said unto her, I am the resurrection, and the life; he that believeth in me, though he were dead, yet shall he live; And whosoever liveth and believeth in me shall never die.John 11:25,26
[ADMIN] How many base
Welcome How many bases I can storage on serwer. Best Regards
Re: [ADMIN] Postgres vs. Informix
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, it's easier to see _when_ a db is a good fit for a given task, and when it's not. Sometimes it's even more effective to have data replication to different db vendors built in programmatically, as I sure wouldn't want to build a massive multi-tiered inventory system in mySQL, but if that same system needed to quickly retrieve prices from a flat 360K-row table, I'd stick the pricing info in mySQL to get, well, fast table scanning. -Bop -- Brought to you from boop!, the dual boot Linux/Win95 Compaq Presario 1625 laptop, currently running RedHat 6.1. Your bopping may vary.
