[GENERAL] postgres maintenance db

2012-07-26 Thread hartrc
I'm using postgres 9.1.4 on Suse Linux Enterprise Server 11. After successful installation I by default have one database installed called postgres. I'm starting the process of migrating some database schemas off Oracle and mysql onto postgres but I want to understand how to best set up the "datab

Re: [GENERAL] postgres maintenance db

2012-07-26 Thread Ondrej Ivanič
Hi, On 27 July 2012 08:07, hartrc wrote: > What is the purpose of the postgres database? I try and drop it and get > "maintenance database can't be dropped" error. 'postgres' database is something like 'mysql' database in MySQL. You should be able to see additional database like 'template0' and

Re: [GENERAL] postgres maintenance db

2012-07-27 Thread Guillaume Lelarge
On Thu, 2012-07-26 at 15:07 -0700, hartrc wrote: > I'm using postgres 9.1.4 on Suse Linux Enterprise Server 11. > After successful installation I by default have one database installed > called postgres. > > I'm starting the process of migrating some database schemas off Oracle and > mysql onto po

Re: [GENERAL] postgres maintenance db

2012-07-27 Thread Steve Crawford
On 07/26/2012 03:07 PM, hartrc wrote: I'm using postgres 9.1.4 on Suse Linux Enterprise Server 11. After successful installation I by default have one database installed called postgres. I'm starting the process of migrating some database schemas off Oracle and mysql onto postgres but I want to