Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9C82F632335 for ; Thu, 15 Jan 2009 10:21:56 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 11033-02 for ; Thu, 15 Jan 2009 10:21:48 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n1b.bullet.mail.ac4.yahoo.com (n1b.bullet.mail.ac4.yahoo.com [76.13.13.71]) by mail.postgresql.org (Postfix) with SMTP id DC95F632332 for ; Thu, 15 Jan 2009 10:21:48 -0400 (AST) Received: from [76.13.13.26] by n1.bullet.mail.ac4.yahoo.com with NNFMP; 15 Jan 2009 14:21:46 -0000 Received: from [76.13.10.181] by t3.bullet.mail.ac4.yahoo.com with NNFMP; 15 Jan 2009 14:21:46 -0000 Received: from [127.0.0.1] by omp122.mail.ac4.yahoo.com with NNFMP; 15 Jan 2009 14:21:46 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 310955.13733.bm@omp122.mail.ac4.yahoo.com Received: (qmail 49406 invoked by uid 60001); 15 Jan 2009 14:21:46 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=Wmwou8J0/+iyyXuiRarkgQUrhIDj+pI7Z7A54eL9gfJA32HLJNptu3VnIcbeaDgSIv9CQxupeVEXBqP0v4Xli/lWLyibZomMIPlWubNV9enaI7mo5FCah1DaEES/L4Jeenq8AzluaWMb+DrcNlsfQzDgrbohbmsdiTXTf9dwVkA=; X-YMail-OSG: sJaoKKUVM1n7jvwoAEIKj0eD59XODW20kFpkxyKtRGipLRPzfFBI3.JTkbrXG9J_mIfBagfKKgRJ8cPCXsPm0fmfRgZ3Hc961_9YgpA3u8e1LzZzxuhbf2.f3tayweyJMr50fKf3xXWF9NDRyefo7N4pqjQIgbYe2RQwequ315J9lqnLcXxCtKFcqwFDR0dFKVm8jRqzAs91aqzD Received: from [161.196.9.65] by web59504.mail.ac4.yahoo.com via HTTP; Thu, 15 Jan 2009 06:21:45 PST X-Mailer: YahooMailWebService/0.7.260.1 Date: Thu, 15 Jan 2009 06:21:45 -0800 (PST) From: Lennin Caro Reply-To: lennin.caro@yahoo.com Subject: Re: postgresql-postGIS problem detected in pgadmin To: pgsql-admin@postgresql.org, m zyzy In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <105527.48915.qm@web59504.mail.ac4.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/47 X-Sequence-Number: 31094 > From: m zyzy > Subject: [ADMIN] postgresql-postGIS problem detected in pgadmin > To: pgsql-admin@postgresql.org > Date: Thursday, January 15, 2009, 8:03 AM > I am using pgadminIII 1.8.4 (tar.gz -built from source) , > postgresql > 8.3.4(rpm from default packages repo) and postgis > (postgis-1.3.3-4.fc10.i386.rpm) (installed using fedora10 > rpm -i / -ivh > command) . These 3 have been installed successfully. > > But to my horror , when I trying to create a new database , > UTF8, using > postGIS template in pgadmin , the option is not even there > in the template's > dropdown list . Which I am suspecting a faulty postGIS > installation . Prior > to installing the postgis rpm version, I tried many times > to install from > source but to no avail with error message ' PostgreSQL > is required' when > POstgreSQL is already installed months before .... create the database in pgsql CREATE DATABASE db2 ENCODING 'utf8';