Re: [GENERAL] to_json(now()) result doesn't have 'T' separator

On 21/12/13 15:27, Joe Van Dyk wrote: On Fri, Dec 20, 2013 at 4:24 PM, Joe Van Dyk > wrote: On Fri, Dec 20, 2013 at 4:18 PM, Joe Van Dyk mailto:j...@tanga.com>> wrote: # select to_json(now()); to_json

Re: [GENERAL] unexpected pageaddr error in db log

On Thu, Dec 19, 2013 at 11:56 PM, bricklen wrote: > > On Thu, Dec 19, 2013 at 1:27 AM, wd wrote: > >> >> On Thu, Dec 19, 2013 at 2:24 PM, Amit Langote wrote: >> >>> "unexpected pageaddr" log entry in this case means the standby reached >>> the end of existing WAL. >>> So, just before connecting

Re: [GENERAL] to_json(now()) result doesn't have 'T' separator

On Fri, Dec 20, 2013 at 4:24 PM, Joe Van Dyk wrote: > > > On Fri, Dec 20, 2013 at 4:18 PM, Joe Van Dyk wrote: > >> # select to_json(now()); >> to_json >> - >> "2013-12-20 15:53:39.098204-08" >> (1 row) >> >> I'd like to see it output "2013-12-20T15:5

Re: [GENERAL] pg_upgrade & tablespaces

On 12/20/2013 4:14 PM, Adrian Klaver wrote: Personally I would say at this point the relationships between versions are so confused it would seem best to start from scratch. the 80 tablespaces aren't helping this one bit. I am really curious what lead to creating that many tablespaces? rem

Re: [GENERAL] pg_upgrade & tablespaces

On 12/20/2013 02:01 PM, Joseph Kregloh wrote: Ah, nothing like taking the dog for walk to clear the mind. Led to a thought. To amend my previous post, instead of using the 9.0 cluster you have been using, why not create a minimal test cluster? In the crawl, walk, run vein, start with a datab

Re: [GENERAL] to_json(now()) result doesn't have 'T' separator

On Fri, Dec 20, 2013 at 4:18 PM, Joe Van Dyk wrote: > # select to_json(now()); > to_json > - > "2013-12-20 15:53:39.098204-08" > (1 row) > > I'd like to see it output "2013-12-20T15:53:39.098204-08" so it's > interchangeable with more systems. > Actu

Re: [GENERAL] Seems like bug in 9.1.3, need to confirm.

David Johnston wrote > Or feel free to peruse the release notes for 9.2, this behavior change > should be documented if intentional. Reading said notes it appears that the "returns NULL" behavior compensates for a concurrent DROP of an existing/known OID. Since your issue is that the object was n

[GENERAL] to_json(now()) result doesn't have 'T' separator

# select to_json(now()); to_json - "2013-12-20 15:53:39.098204-08" (1 row) I'd like to see it output "2013-12-20T15:53:39.098204-08" so it's interchangeable with more systems. http://en.wikipedia.org/wiki/ISO_8601#Combined_date_and_time_representation

Re: [GENERAL] Seems like bug in 9.1.3, need to confirm.

rummandba wrote > HI, > > I am working on Postgresql 9.1.3. > I executed the following query and got an error: > select relname, pg_size_pretty(pg_table_size(relname::text)) as s from > pg_stat_user_tables order by pg_table_size(relname::text) desc limit 10; > ERROR: relation "tab_20130206" doe

Re: [GENERAL] pg_upgrade & tablespaces

On 12/20/2013 02:01 PM, Joseph Kregloh wrote: [root@postgres-93-upgrade /usr/local/pgsql/data/drupal___dbspace]# ls -la /home/jkregloh/pg_data/data/__drupal_dbspace/ drwx-- 4 pgsql pgsql 4 Oct 20 2011 PG_9.0_201008051 So that looks like it worked,

Re: [GENERAL] Seems like bug in 9.1.3, need to confirm.

AI Rumman writes: > I executed the following query and got an error: > select relname, pg_size_pretty(pg_table_size(relname::text)) as s from > pg_stat_user_tables order by pg_table_size(relname::text) desc limit 10; > ERROR: relation "tab_20130206" does not exist Use the OID, not the relname,

Re: [GENERAL] window function and order by

=?ISO-8859-1?Q?Torsten_F=F6rtsch?= writes: > select id, buy_price, sum(buy_price) over (order by id) sum > from fmb >where 202300<=id and id<=202400 >order by id; > Do I need the ORDER BY clause at the end? Or does the ORDER BY in the > window function already define the order of th

[GENERAL] Seems like bug in 9.1.3, need to confirm.

HI, I am working on Postgresql 9.1.3. I executed the following query and got an error: select relname, pg_size_pretty(pg_table_size(relname::text)) as s from pg_stat_user_tables order by pg_table_size(relname::text) desc limit 10; ERROR: relation "tab_20130206" does not exist That table does n

Re: [GENERAL] window function and order by

Torsten Förtsch wrote > Hi, > > assuming I have a query that computes a running sum like this: > > select id, buy_price, sum(buy_price) over (order by id) sum > from fmb >where 202300<=id and id<=202400 >order by id; > > Do I need the ORDER BY clause at the end? Or does the ORDER B

[GENERAL] window function and order by

Hi, assuming I have a query that computes a running sum like this: select id, buy_price, sum(buy_price) over (order by id) sum from fmb where 202300<=id and id<=202400 order by id; Do I need the ORDER BY clause at the end? Or does the ORDER BY in the window function already define th

Re: [GENERAL] pg_upgrade & tablespaces

On 12/20/2013 10:42 AM, Joseph Kregloh wrote: So was your latest attempt where you ended up with a doubled data/ in the two or one jail scenario? The two jails scenario. The two jail scenario is the same as the mounted scenario. Can we see a directory listing for that case? Y

Re: [GENERAL] Best way to sync possibly corrupted data?

Thank you. pg_dump is what we will use. We did re-assign the LUN to a new system last night, and are monitoring. Too early to say anything, but so far, we haven't seen the corruption. And yes, we will get the dump from the new system. We do not have the hardware to move the backups to a differen

Re: [GENERAL] pg_upgrade & tablespaces

> So was your latest attempt where you ended up with a doubled data/ in the > two or one jail scenario? > > The two jails scenario. The two jail scenario is the same as the mounted scenario. Can we see a directory listing for that case? > > You say in the single jail case you got the same results.

Re: [GENERAL] pg_upgrade & tablespaces

On Thu, Dec 19, 2013 at 12:49 PM, Joseph Kregloh wrote: > [pgsql@postgres-93-upgrade ~]$ ls -l > /home/jkregloh/pg_data/data/pg_tblspc/ > lrwxr-xr-x 1 pgsql pgsql41 Dec 19 19:53 11047389 -> > /home/jkregloh/pg_data/data/stats_dbspace > lrwxr-xr-x 1 pgsql pgsql44 Dec 19 19:53 11

Re: [GENERAL] connect using quirrel sql client

2013/12/20 Adrian Klaver : > On 12/20/2013 01:08 AM, Arindam Mondal wrote: >> >> Hi , >> please let me know how I can connect postgresql using squirrel sql >> client 3.4.0. > > > Make sure you have the Postgres JDBC driver: > > http://jdbc.postgresql.org/download.html > > Configure SQuirrel: > > h

[GENERAL] client_min_messages documentation typo

Currently the documentation looks like: client_min_messages (enum) Controls which message levels are sent to the client. Valid values are DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, LOG, NOTICE, WARNING, ERROR, FATAL, and PANIC. Each level includes all the levels that follow it. The later the level,

Re: [GENERAL] pg_upgrade & tablespaces

On 12/20/2013 07:32 AM, Joseph Kregloh wrote: Case B: pg_upgrade -b /home/jkregloh/pg_bin/ -B /usr/local/bin/ -D /usr/local/pgsql_93/data -d /usr/local/pgsql/data/ -P 5452 -p 5451 In this case, the OLD cluster is in the default location and the new one

Re: [GENERAL] pg_upgrade & tablespaces

On Fri, Dec 20, 2013 at 10:26 AM, Adrian Klaver wrote: > On 12/20/2013 06:54 AM, Joseph Kregloh wrote: > >> >> >> >> On Thu, Dec 19, 2013 at 6:19 PM, Adrian Klaver > > wrote: >> >> On 12/19/2013 01:50 PM, Joseph Kregloh wrote: >> >> On Thu, Dec 19, 2013

Re: [GENERAL] pg_upgrade & tablespaces

On 12/20/2013 06:54 AM, Joseph Kregloh wrote: On Thu, Dec 19, 2013 at 6:19 PM, Adrian Klaver mailto:adrian.kla...@gmail.com>> wrote: On 12/19/2013 01:50 PM, Joseph Kregloh wrote: On Thu, Dec 19, 2013 at 4:14 PM, John R Pierce mailto:pie...@hogranch.com>

Re: [GENERAL] pg_upgrade & tablespaces

On Thu, Dec 19, 2013 at 6:19 PM, Adrian Klaver wrote: > On 12/19/2013 01:50 PM, Joseph Kregloh wrote: > >> On Thu, Dec 19, 2013 at 4:14 PM, John R Pierce > > wrote: >> >> On 12/19/2013 1:06 PM, Joseph Kregloh wrote: >> >> It's easier to keep things segregate

Re: [GENERAL] connect using quirrel sql client

On 12/20/2013 01:08 AM, Arindam Mondal wrote: Hi , please let me know how I can connect postgresql using squirrel sql client 3.4.0. Make sure you have the Postgres JDBC driver: http://jdbc.postgresql.org/download.html Configure SQuirrel: http://squirrel-sql.sourceforge.net/index.php?page=sc

Re: [GENERAL] Is it advisable to pg_upgrade directly from 9.0 to 9.3?

Hi Michael, Sorry about that. Anyway, my colleague just sent out a similar question to this mailing list right after I sent mine. The subject title is "pg_upgrade & tablespaces". If you can help us from my colleague's email, I really appreciate. Thanks! -Laurent On Fri, Dec 20, 2013 at 1:05 A

[GENERAL] connect using quirrel sql client

Hi , please let me know how I can connect postgresql using squirrel sql client 3.4.0. Thanks & Regards Arindam Mondal

Re: [GENERAL] Best way to sync possibly corrupted data?

On 12/20/2013 01:01 AM, Michael Paquier wrote: You should go with pg_dump if you are able to get a clean dump. Such block errors happen because of hardware issues, so you are not safe from additional failures that might happen while you do a copy of the existing data folder to a new system. I

Re: [GENERAL] inconsistent backup?

Ralf Schuchardt wrote: > Am 19.Dez. 2013 um 09:41 schrieb Andreas Kretschmer : >> don't ask why, but a customer created tables with foreign key constraints but >> with inconsistent data. >> >> Because of this he disabled all triggers (alter table foo disable trigger >> all). >> So far, so bad ...