It's a database called 'template1'. You can connect to it with: psql template1
When you use createdb, the new DB is a copy of template1. Cheers Grant On Tue, 2009-04-28 at 21:27 -0700, Luke Grimstrup wrote: > Where can this template database??? > > On Apr 29, 12:10 pm, Craig Hawkes <[email protected]> wrote: > > Hi > > > > Having plpgsql within a postgres database is optional. When you create a new > > database, it uses the contents of the template database as a template. > > It sounds like you have plpgsql defined within your template, and also when > > you restore the database it is being redefined. > > Maybe you could remove the plpgsql from the Template database, for this > > server? > > > > Craig > > > > On Wed, Apr 29, 2009 at 11:58 AM, Luke Grimstrup > > <[email protected]>wrote: > > > > > > > > > Hey, > > > > > I've got a Rails project, postgres 8.3 database, in my environment.rb > > > file I have: > > > config.active_record.schema_format = :sql > > > this is because not uncommenting this line and preparing the test > > > database doesn't create the domains or functions for the database. > > > > > But when I try and run rspec, or rake db:test:clone_structure it trips > > > up on loading the database saying that: > > > psql: /path/to/project/development_structure.sql:15: ERROR: language > > > "plpgsql" already exists > > > > > My understanding is that postgres automatically applies the language > > > to every new database created, so why it needs to create the language > > > on a restore baffles me. > > > > > Any help around this would be greatly appreciated!!! > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "WellRailed" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/WellRailed?hl=en -~----------~----~----~----~------~----~------~--~---
