Re: [ADMIN] template1 database

2005-03-09 Thread Michael Fuhr
On Thu, Mar 10, 2005 at 08:17:03AM +, Eimantas Vai??i??nas wrote: > I've recently started using PgSQL and i must say it gose quite good as far as > i can say. Just been wondering how important is template1 database to PgSQL? > What would happen if i drop this database together with postgres

Re: [ADMIN] template1 database

2005-03-09 Thread Tom Lane
Eimantas =?utf-8?q?Vai=C4=8Di=C5=ABnas?= <[EMAIL PROTECTED]> writes: > Just been wondering how important is template1 database to PgSQL? The database server itself doesn't care, but there are enough client-side tools that assume template1 exists that you would not find life pleasant if you do thi

[ADMIN] template1 database

2005-03-09 Thread Eimantas Vaičiūnas
Hi list, I've recently started using PgSQL and i must say it gose quite good as far as i can say. Just been wondering how important is template1 database to PgSQL? What would happen if i drop this database together with postgres user. -- Eimantas VaiÄiÅnas VU SkaiÄiavimo centras --

Re: [ADMIN] template1 database...

2003-08-25 Thread Chris M
"Bruno Wolff III" <[EMAIL PROTECTED]>> > This is usually accomplished by logging in as a normal user for most > tasks and only using a superuser account when it is needed. Yes. DBAs should be careful when operating on the databases. But I have seen many people using the superuser in MS SQL Server

Re: [ADMIN] template1 database...

2003-08-25 Thread Bruno Wolff III
On Sun, Aug 24, 2003 at 00:38:35 +0800, Chris M <[EMAIL PROTECTED]> wrote: > > The link is very good. But another question. > In PostgreSQL, a superuser can modify almost everything in the > databases. But I don't think that should be the default. Maybe > adding an option is better. When a super

Re: [ADMIN] template1 database...

2003-08-24 Thread Chris M
The link is very good. But another question. In PostgreSQL, a superuser can modify almost everything in the databases. But I don't think that should be the default. Maybe adding an option is better. When a superuser want to change something owned by the system, he or she can turn the option on, th

Re: [ADMIN] template1 database...

2003-08-20 Thread Devrim GUNDUZ
Hi, On Wed, 20 Aug 2003, Thomas LeBlanc wrote: > We have accidentally added tables and other objects to this database. > > How do we return template1 back to the default setup? I think this will help you: http://techdocs.postgresql.org/techdocs/pgsqladventuresep1.php Written by Josh Berkus.

[ADMIN] template1 database...

2003-08-20 Thread Thomas LeBlanc
We have accidentally added tables and other objects to this database. How do we return template1 back to the default setup? Thomas LeBlanc _ Get MSN 8 and help protect your children with advanced parental controls. http://join.msn