Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #595

Re: Issue where postgres randomly gets into state where it returns hstore as string

Show all headers | View raw

On 2014-08-27, zebharadon@gmail.com <zebharadon@gmail.com> wrote:
>
> If I create a backup of the database in its broken state (using pg_dump) and restore it to a new database on another server which is not experiencing the issue (using pg_restore), then the restored database works fine and does not experience the issue.

what if you use pg_dumpall?

could it be that the problem is attached to the user account that's
accessing the database? pg_dump doesn't save that.





-- 
umop apisdn


--- news://freenews.netfront.net/ - complaints: news@netfront.net ---

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Issue where postgres randomly gets into state where it returns hstore as string zebharadon@gmail.com - 2014-08-25 11:39 -0700
  Re: Issue where postgres randomly gets into state where it returns hstore as string Jasen Betts <jasen@xnet.co.nz> - 2014-08-26 06:55 +0000
    Re: Issue where postgres randomly gets into state where it returns hstore as string zebharadon@gmail.com - 2014-08-27 14:51 -0700
      Re: Issue where postgres randomly gets into state where it returns hstore as string Jasen Betts <jasen@xnet.co.nz> - 2014-08-28 12:47 +0000
  Re: Issue where postgres randomly gets into state where it returns hstore as string mattheww@chiark.greenend.org.uk (Matthew Woodcraft) - 2014-08-28 23:05 +0100
    Re: Issue where postgres randomly gets into state where it returns hstore as string mattheww@chiark.greenend.org.uk (Matthew Woodcraft) - 2014-08-28 23:15 +0100

csiph-web