On Tue, 2008-07-29 at 16:03 -0500, Chris Bovitz wrote:
> As I mentioned earlier, we are doing major upgrades to our database
> servers from 8.1.3 which necessitates the use of pg_dumpall. But what
> do we do with the WALs? Should we delete them? Or should we leave them
> there, and the new ver
As I mentioned earlier, we are doing major upgrades to our database
servers from 8.1.3 which necessitates the use of pg_dumpall. But what
do we do with the WALs? Should we delete them? Or should we leave them
there, and the new version of PostgreSQL will pick up where they left
off? Should w
Carol Walter <[EMAIL PROTECTED]> writes:
> How do you make a user that can only create temporary tables?
Well, you grant them TEMP privilege on the database, and you revoke
everything else. I suspect the key bit you're missing is to revoke
public CREATE privilege on the "public" schema.
Hello,
I'm running PostgreSQL 8.2.3 on Solaris 10.
I'm still trying to give my users the access they want without
"giving away the store". They want to be able to create temporary
tables in a specified database. I created a test role and a test
database. The database has two tables. I
