FW: [ADMIN] Error in logfile on DB startup

2004-07-26 Thread Nigel Bishop
Any help would be much appreciated especially with the first problem Thanks, Nigel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nigel Bishop Sent: 20 July 2004 14:50 To: [EMAIL PROTECTED] Subject: [ADMIN] Error in logfile on DB startup Hi Solaris 8,

Re: [ADMIN] Utilizing multiple disks

2004-07-26 Thread Gaetano Mendola
Steve wrote: Gaetano, Thanks for your reply. Gaetano Mendola wrote: Are you performing queries using the like operator? If yes did you define an index on it using the right operator class ? Yes I do use the like operator to perform queries on a few 'varchar' and 'text' fields. I have indexed

[ADMIN] Ayuda con pg_resotre

2004-07-26 Thread Christian Hache
Hola, quiero restaurar un dump con pg_restore, cada que que lo quiero usar, marca algun tipo de error como pg_restore: [archivador] el archivo de entrada no parece ser un archivo valido lo empleo del siguiente modo pg_restore -d mibase mibase.dump o pg_resotre mibase.dump -d mibase

Re: [ADMIN] How do I grant access to entire database at

2004-07-26 Thread Randall Perry
Thanks, I'll use it. But, if the developer's are listening -- this is really obtuse. MySQL administration is much easier. Please consider simplifying the GRANT process for future revs. BTW, I prefer postgresql for all my own development. on 7/18/04 4:41 PM, Oliver Elphick at [EMAIL PROTECTED]

Re: [ADMIN] How do I grant access to entire database at

2004-07-26 Thread Sam Barnett-Cormack
On Mon, 26 Jul 2004, Randall Perry wrote: Thanks, I'll use it. But, if the developer's are listening -- this is really obtuse. MySQL administration is much easier. Please consider simplifying the GRANT process for future revs. I do agree with this, actually - in fact, let me expand. GRANT

Re: [ADMIN] How do I grant access to entire database at

2004-07-26 Thread Jean-Luc Lachance
I have been thinking about this problem for quite a while. Proper administration require creation of groups. Adding a new user to a database is as simple as adding the user to the group that has the required privileges to the database. But, I think one new command would be very usefull. CREATE

Re: [ADMIN] How do I grant access to entire database at

2004-07-26 Thread Sam Barnett-Cormack
On Mon, 26 Jul 2004, Jean-Luc Lachance wrote: I have been thinking about this problem for quite a while. Proper administration require creation of groups. Adding a new user to a database is as simple as adding the user to the group that has the required privileges to the database. But, I

Re: [ADMIN] How do I grant access to entire database at

2004-07-26 Thread Tom Lane
Sam Barnett-Cormack [EMAIL PROTECTED] writes: GRANT out to have a varying degree of granularity, IMO. So you can specify individual sequences or tables, a glob (handy for table+sequence), possibly an intelligent way of including anything requisite for a given table, a whole DB, a whole

[ADMIN] Max varchar size

2004-07-26 Thread Chris Hoover
I need to know what the max size of a varchar field is allowed to be in 7.3.4. I have a table that someone created with a varchar(1000) field (before I started here). We are noticing that when we try to view that field we only end up with ~255 characters. This is making me think that