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

Groups > comp.databases.postgresql > #594

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

Show all headers | View raw

On Monday, August 25, 2014 11:55:21 PM UTC-7, Jasen Betts wrote:
> On 2014-08-25, zebharadon@gmail.com <zebharadon@gmail.com> wrote:
> 
> >
> 
> > The problem is that it is returning an hstore array as a string.
> 
> > From a non-working instance, here is some text from an irb session:
> 
> 
> 
> can the brokenness be dumped by pg_dumpall and restored and produce a
> 
> broken restore. or is this feature something that pg_dump can't access.
> 
> 
> 
> -- 
> 
> umop apisdn
> 
> 
> 
> 
> 
> --- news://freenews.netfront.net/ - complaints: news@netfront.net ---

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.

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