Stroring data in PostgreSQL ... create anew?

[Colin Law]

On 31 August 2014 23:05, Matěj Cepl <mcepl at cepl.eu> wrote:
> Hi,
>
> I want to make it possible to work on the shared home accounting
> between me and my wife (do I have to have the exact same version
> of GnuCash on both systems? I have RHEL-7 with 2.6.3 and she has
> still RHEL-6 with 2.4.15). I promise I will be careful not to
> access the data simultaneously, but playing with SQL database
> seems to me more simple than setting up NFS or Samba to share an
> XML file (BTW, what's better: XML or SQLite?)
>
> I have created a database gnucash on the server and I can access
> it with psql from my workstation. group 'dbusers' (of which both
> of us are members) has ALL privilegis granted on the database.
>
> Now, when I try to Save As data to postgresql (on RHEL-7) I get
> an error message "The file postgres://matej@localhost/gnucash
> already exists. Are you sure you want to overwrite it?" (why?
> I have just created an empty database) and when I say "Yes" it
> fails with "The server at URL postgres://matej@localhost/gnucash
> experienced an error or encountered bad or corrupt data."

Does it work if there is no existing database of that name?  At one
time there was a problem trying to overwrite an existing db using Save
As which gave exactly that problem.  This seems to be fixed in 2.6.3.

Colin


>
> The psql shows this:
>
> gnucash=> \dt
> List of relations
> Schema |  Name   | Type  | Owner
> --------+---------+-------+-------
> public | gnclock | table | matej
> (1 row)
>
> gnucash=> select * from gnclock;
> hostname |  pid  ----------+-------
> wycliff  | 11741
> (1 row)
>
> gnucash=>
>
> Any idea, what's wrong?
>
> Best,
>
> Matěj
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.