Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > pgsql.interfaces.pgadmin.support > #1

Template0 missing from list of templates

X-Received by 2002:a24:2f05:: with SMTP id j5-v6mr2009419itj.37.1531462959806; Thu, 12 Jul 2018 23:22:39 -0700 (PDT)
X-Received by 2002:aca:eb15:: with SMTP id j21-v6mr1015561oih.6.1531462959384; Thu, 12 Jul 2018 23:22:39 -0700 (PDT)
Path csiph.com!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!d7-v6no2254744itj.0!news-out.google.com!l67-v6ni2516itl.0!nntp.google.com!d7-v6no2254736itj.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups pgsql.interfaces.pgadmin.support
Date Thu, 12 Jul 2018 23:22:39 -0700 (PDT)
Complaints-To groups-abuse@google.com
Injection-Info glegroupsg2000goo.googlegroups.com; posting-host=124.170.148.216; posting-account=YzCPJQoAAACBWGaw6pU-hiDCAXtaZ5TR
NNTP-Posting-Host 124.170.148.216
User-Agent G2/1.0
MIME-Version 1.0
Message-ID <736ce64a-d501-42c1-84b8-65386ac244f2@googlegroups.com> (permalink)
Subject Template0 missing from list of templates
From mattlmoyle@gmail.com
Injection-Date Fri, 13 Jul 2018 06:22:39 +0000
Content-Type text/plain; charset="UTF-8"
Lines 8
Xref csiph.com pgsql.interfaces.pgadmin.support:1

Show key headers only | View raw


Hi, novice user here with hopefully a basic question.

I'm trying to create a temporary database to restore a backup in pgAdmin. But when creating the database, under the"definition" tab I have to select a template and "template0" is missing from the dropdown menu.

If I try to create a database called template0 I get an error message saying that "database "template0" already exists".

How do I make template0 the definition template for me new database?

I'm sure I'm making a simple mistake but if someone could point me in the right direction it would be greatly appreciated.

Back to pgsql.interfaces.pgadmin.support | Next | Find similar


Thread

Template0 missing from list of templates mattlmoyle@gmail.com - 2018-07-12 23:22 -0700

csiph-web