Stroring data in PostgreSQL ... create anew?

Colin Law clanlaw at gmail.com
Mon Sep 1 05:16:26 EDT 2014


On 1 September 2014 09:05, Matěj Cepl <mcepl at cepl.eu> wrote:
> On 2014-09-01, 06:15 GMT, Colin Law wrote:
>> Does it work if there is no existing database of that name?
>
> Let me try. Hmm, dropped the database, and then File/Save As
> ended with
>
>     The server at URL postgres://matej@localhost/gnucash
>     experienced an error or encountered bad or corrupt data.
>
> Does anybody have to grant to some role right to CREATE
> databases (GRANT CREATE ON DATABASE according to
> http://www.postgresql.org/docs/8.4/static/sql-grant.html "allows
> new schemas to be created within the database.")

If you have not already done so then check that the user and password
you are supplying when you Save As is able to create dbs, add tables
and so on via another postgres tool.

>
>> This seems to be fixed in 2.6.3.
>
> Which is what I have though.

In the first post I understood you were seeing the problem with an
older version.

Colin



More information about the gnucash-user mailing list