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
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
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
--
"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
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
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
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.
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