Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id AA686785C56
	for <pgsql-admin@postgresql.org>; Wed, 23 Nov 2011 00:29:09 -0400 (AST)
Received: from sam.nabble.com ([216.139.236.26])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <presley@umangsoftware.com>) id 1RT4SI-00064t-Ua
	for pgsql-admin@postgresql.org; Wed, 23 Nov 2011 04:29:08 +0000
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <presley@umangsoftware.com>) id 1RT4S5-0001PB-AW
	for pgsql-admin@postgresql.org; Tue, 22 Nov 2011 20:28:53 -0800
Date: Tue, 22 Nov 2011 20:28:53 -0800 (PST)
From: PresleyDias <presley@umangsoftware.com>
To: pgsql-admin@postgresql.org
Message-ID: <000901cca998$5885ab20$09910160$@com>
In-Reply-To: <jagpim$ikk$2@dough.gmane.org>
References: <1321862090073-5009739.post@n5.nabble.com>
	<jagpim$ikk$2@dough.gmane.org>
Subject: Re: Postgres database creation using batch files
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_20770_11311875.1322022533320"
X-Archive-Number: 201111/115
X-Sequence-Number: 38709

------=_Part_20770_11311875.1322022533320
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

 

Hello,
the solution just works fine for me using the batch file J

 

 

From: Thomas Kellerer [via PostgreSQL]
[mailto:ml-node+s1045698n5014311h58@n5.nabble.com] 
Sent: Wednesday, November 23, 2011 12:01 AM
To: PresleyDias
Subject: Re: Postgres database creation using batch files

 

PresleyDias wrote on 21.11.2011 08:54: 


> i want to create a postgres database using batch file, now the normal way
of 
> doing this is 
> 
> "C:\Program Files\PostgreSQL\9.0\bin\createdb.exe" -U Myadmin
MydatAbseName 
> 
> this create a database with the default database parameters, but i want to

> create a database with the following parameter 
> 
>     WITH OWNER = Myadmin 
>     TEMPLATE = template0 
>     ENCODING = 'SQL_ASCII' 
>     TABLESPACE = pg_default 
>     LC_COLLATE = 'C' 
>     LC_CTYPE = 'C' 
>     CONNECTION LIMIT = -1; 
> 
> Please tell me how to create a database with the above parameter using
Batch 
> files. 
> 
> also how to use a .sql file to do the same, like this "C:\Program 
> Files\PostgreSQL\9.0\bin\createdb.exe" -U Myadmin -f C:\createDB.sql; 
> 


What's wrong with the answer you got on Stackoverflow? 

http://stackoverflow.com/questions/8208181/create-posgtres-database-using-ba
tch-file-with-template-encoding-owner-an



-- 
Sent via pgsql-admin mailing list ([hidden email]) 
To make changes to your subscription: 
http://www.postgresql.org/mailpref/pgsql-admin



  _____  

If you reply to this email, your message will be added to the discussion
below:

http://postgresql.1045698.n5.nabble.com/Postgres-database-creation-using-bat
ch-files-tp5009739p5014311.html 

To unsubscribe from Postgres database creation using batch files, click
<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsu
bscribe_by_code&node=5009739&code=cHJlc2xleUB1bWFuZ3NvZnR3YXJlLmNvbXw1MDA5Nz
M5fDExODk2NzQ1MTI=>  here.
 
<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=macr
o_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.B
asicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.templ
ate.InstantMailNamespace&breadcrumbs=instant+emails%21nabble%3Aemail.naml-in
stant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
NAML 



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Postgres-database-creation-using-batch-files-tp5009739p5015520.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
------=_Part_20770_11311875.1322022533320
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit




<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->

<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1" />
 </o:shapelayout></xml><![endif]-->




<div class=Section1>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hello,<br>
the solution just works fine for me using the batch file </span><span
style='font-size:11.0pt;font-family:Wingdings;color:#1F497D'>J</span><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>

<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Thomas Kellerer
[via PostgreSQL] [mailto:<a href="/user/SendEmail.jtp?type=node&node=5015520&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>] <br>
<b>Sent:</b> Wednesday, November 23, 2011 12:01 AM<br>
<b>To:</b> PresleyDias<br>
<b>Subject:</b> Re: Postgres database creation using batch files<o:p></o:p></span></p>

</div>

<p class=MsoNormal><o:p>&nbsp;</o:p></p>

<p class=MsoNormal>PresleyDias wrote on 21.11.2011 08:54: <o:p></o:p></p>

<div>

<p class=MsoNormal><br>
&gt; i want to create a postgres database using batch file, now the normal way
of <br>
&gt; doing this is <br>
&gt; <br>
&gt; &quot;C:\Program Files\PostgreSQL\9.0\bin\createdb.exe&quot; -U Myadmin
MydatAbseName <br>
&gt; <br>
&gt; this create a database with the default database parameters, but i want to
<br>
&gt; create a database with the following parameter <br>
&gt; <br>
&gt; &nbsp; &nbsp; WITH OWNER = Myadmin <br>
&gt; &nbsp; &nbsp; TEMPLATE = template0 <br>
&gt; &nbsp; &nbsp; ENCODING = 'SQL_ASCII' <br>
&gt; &nbsp; &nbsp; TABLESPACE = pg_default <br>
&gt; &nbsp; &nbsp; LC_COLLATE = 'C' <br>
&gt; &nbsp; &nbsp; LC_CTYPE = 'C' <br>
&gt; &nbsp; &nbsp; CONNECTION LIMIT = -1; <br>
&gt; <br>
&gt; Please tell me how to create a database with the above parameter using
Batch <br>
&gt; files. <br>
&gt; <br>
&gt; also how to use a .sql file to do the same, like this &quot;C:\Program <br>
&gt; Files\PostgreSQL\9.0\bin\createdb.exe&quot; -U Myadmin -f C:\createDB.sql;
<br>
&gt; <o:p></o:p></p>

</div>

<p class=MsoNormal style='margin-bottom:12.0pt'><br>
What's wrong with the answer you got on Stackoverflow? <br>
<br>
<a
href="http://stackoverflow.com/questions/8208181/create-posgtres-database-using-batch-file-with-template-encoding-owner-an"
target="_top" rel="nofollow" link="external">http://stackoverflow.com/questions/8208181/create-posgtres-database-using-batch-file-with-template-encoding-owner-an</a><br>
<br>
<br>
<br>
-- <br>
Sent via pgsql-admin mailing list (<a
href="/user/SendEmail.jtp?type=node&amp;node=5014311&amp;i=0" target="_top" rel="nofollow" link="external">[hidden
email]</a>) <br>
To make changes to your subscription: <br>
<a href="http://www.postgresql.org/mailpref/pgsql-admin" target="_top" rel="nofollow" link="external">http://www.postgresql.org/mailpref/pgsql-admin</a><br>
<br>
<o:p></o:p></p>

<div class=MsoNormal align=center style='text-align:center'>

<hr size=1 width="100%" noshade style='color:#CCCCCC' align=center>

</div>

<div>

<div>

<p class=MsoNormal><b><span style='font-size:9.0pt;font-family:"Tahoma","sans-serif";
color:#444444'>If you reply to this email, your message will be added to the
discussion below:<o:p></o:p></span></b></p>

</div>

<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Tahoma","sans-serif";
color:#444444'><a
href="http://postgresql.1045698.n5.nabble.com/Postgres-database-creation-using-batch-files-tp5009739p5014311.html" target="_top" rel="nofollow" link="external">http://postgresql.1045698.n5.nabble.com/Postgres-database-creation-using-batch-files-tp5009739p5014311.html</a>
<o:p></o:p></span></p>

</div>

<div style='margin-top:4.8pt'>

<p class=MsoNormal style='line-height:18.0pt'><span style='font-size:8.5pt;
font-family:"Tahoma","sans-serif";color:#666666'>To unsubscribe from Postgres
database creation using batch files, <a
href="" target="_top" rel="nofollow" link="external">click
here</a>.<br>
<a
href="http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&amp;id=instant_html%21nabble%3Aemail.naml&amp;base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.InstantMailNamespace&amp;breadcrumbs=instant+emails%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" target="_top" rel="nofollow" link="external"><span
style='font-size:7.0pt;font-family:"Times New Roman","serif"'>NAML</span></a> <o:p></o:p></span></p>

</div>

</div>





	
<br/><hr align="left" width="300" />
View this message in context: <a href="http://postgresql.1045698.n5.nabble.com/Postgres-database-creation-using-batch-files-tp5009739p5015520.html">RE: Postgres database creation using batch files</a><br/>
Sent from the <a href="http://postgresql.1045698.n5.nabble.com/PostgreSQL-admin-f2076596.html">PostgreSQL - admin mailing list archive</a> at Nabble.com.<br/>
------=_Part_20770_11311875.1322022533320--