<div dir='rtl'><div>Hi,</div>
<div>I'm using PostgreSQL 9.3.2</div>
<div>I'm running the command:</div>
<div> </div>
<div>
<p>psql -h testserver -U ronb -f backup.sql -q -d foldertest 2>error.txt >output.txt</p>
<p>This should generate my database in foldertest</p>
<p>However this doesn't work. It's unable to create schemas</p>
<p>in the error.txt i see "permission denied for database foldertest".</p>
<p>I know this is not an access permission issue because there is a public schema which is buildin and it does create the tables/data in there.</p>
<p>It just cant create new schemas.</p>
<p> </p>
<p>The intresting thing is that if I do:</p>
<p>psql -h testserver -U postgres -f backup.sql -q -d foldertest 2>error.txt >output.txt</p>
<p> </p>
<p>Everything works. It create all schemas and generate the database correctly.</p>
<p>I don't see any diffrent in the hba.conf between postgres and ronb users.</p>
<p>What can be the problem?</p>
</div></div>