Re: [GENERAL] pgsql and asciidoc output

2014-02-11 Thread Gabriele Bartolini
I second Bruce. I massively use asciidoc. I guess adding both asciidoc and md would not be too hard. Thanks, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it 2014-02-12 6:02 GMT+01:00 Pavel St

Re: [GENERAL] Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp'

2014-02-11 Thread Adarsh Sharma
Hi Peter, Thanks for your reply. I Complied xlogdump successfully with Pg-9.2 and now i am using it to parse EDB's pg_xlog files and i am able to do that. Below are the details : [cur:1835/26FAE218, xid:471303469, rmid:9(Heap2), len/tot_len:24/6900, info:24, prev:1835/26FAD6D8] bkpblock[1]: s/d/r

Re: [GENERAL] pgsql and asciidoc output

2014-02-11 Thread Pavel Stehule
2014-02-12 0:25 GMT+01:00 Vik Fearing : > On 02/11/2014 11:56 PM, Bruce Momjian wrote: > > Someone suggested that 'asciidoc' > > (http://en.wikipedia.org/wiki/AsciiDoc) would be a good output format > > for psql, similar to the existing output formats of html, latex, and > > troff. > > > > Would t

Re: [GENERAL] pgsql and asciidoc output

2014-02-11 Thread Steve Atkins
On Feb 11, 2014, at 2:56 PM, Bruce Momjian wrote: > Someone suggested that 'asciidoc' > (http://en.wikipedia.org/wiki/AsciiDoc) would be a good output format > for psql, similar to the existing output formats of html, latex, and > troff. > > Would this be useful? Less so than Markdown[1], IMO.

Re: [GENERAL] pgsql and asciidoc output

2014-02-11 Thread Vik Fearing
On 02/11/2014 11:56 PM, Bruce Momjian wrote: > Someone suggested that 'asciidoc' > (http://en.wikipedia.org/wiki/AsciiDoc) would be a good output format > for psql, similar to the existing output formats of html, latex, and > troff. > > Would this be useful? > Perhaps, but if we're going to add a

[GENERAL] pgsql and asciidoc output

2014-02-11 Thread Bruce Momjian
Someone suggested that 'asciidoc' (http://en.wikipedia.org/wiki/AsciiDoc) would be a good output format for psql, similar to the existing output formats of html, latex, and troff. Would this be useful? -- Bruce Momjian http://momjian.us EnterpriseDB http:

Re: [GENERAL] Streaming Replication - Error on Standby

2014-02-11 Thread Adrian Klaver
On 02/11/2014 10:12 AM, bobJobS wrote: Postgres 9.3.2. RHEL 5 After performing all of the Streaming Replication setup steps, I get the following error message in my standby DB log file. database system identifier differ between the primary and standby I've double checked the recovery.conf f

Re: [GENERAL] Streaming Replication - Error on Standby

2014-02-11 Thread Adrian Klaver
On 02/11/2014 10:12 AM, bobJobS wrote: Postgres 9.3.2. RHEL 5 After performing all of the Streaming Replication setup steps, I get the following error message in my standby DB log file. database system identifier differ between the primary and standby I've double checked the recovery.conf f

Re: [GENERAL]

2014-02-11 Thread John R Pierce
On 2/11/2014 1:35 AM, Nedal Slman wrote: i want to ask if there is any problem or fees to using Postgesql in commercial application like develop not open source application using Postgresql database and sell it . http://www.postgresql.org/about/licence/ you need to include the specified copyr

Re: [GENERAL] Streaming Replication - Error on Standby

2014-02-11 Thread bricklen
On Tue, Feb 11, 2014 at 11:25 AM, bobJobS wrote: > > To get the standby server to a point, I tool a globals dump and a data dump > of the primary server and build the standby. > > Then I executed pg_startbackup, rsync data dir to standby data dir (to > catch > any changes made while I was buildin

Re: [GENERAL] Streaming Replication - Error on Standby

2014-02-11 Thread bobJobS
To get the standby server to a point, I tool a globals dump and a data dump of the primary server and build the standby. Then I executed pg_startbackup, rsync data dir to standby data dir (to catch any changes made while I was building the standby) and finally pg_stopbackup... all on the primary

Re: [GENERAL] Streaming Replication - Error on Standby

2014-02-11 Thread bricklen
On Tue, Feb 11, 2014 at 10:12 AM, bobJobS wrote: > Postgres 9.3.2. > RHEL 5 > > After performing all of the Streaming Replication setup steps, > What replication steps? > database system identifier differ between the primary and standby > How did you take the initial backup of the master? D

[GENERAL] Streaming Replication - Error on Standby

2014-02-11 Thread bobJobS
Postgres 9.3.2. RHEL 5 After performing all of the Streaming Replication setup steps, I get the following error message in my standby DB log file. database system identifier differ between the primary and standby I've double checked the recovery.conf file and it contains the correct hostname,

Re: [GENERAL] Simple Web-based alternative to PgAdmin

2014-02-11 Thread Pavel Stehule
2014-02-11 17:17 GMT+01:00 AlexK : > I would like to give my users the ability to invoke read-only functions and > select statements, so that they can easily see the data. Both me and the > users have experience mostly with SQL Server, so anyone can keep like 30 > connections without much thinking

Re: [GENERAL] Simple Web-based alternative to PgAdmin

2014-02-11 Thread Adrian Klaver
On 02/11/2014 08:17 AM, AlexK wrote: I would like to give my users the ability to invoke read-only functions and select statements, so that they can easily see the data. Both me and the users have experience mostly with SQL Server, so anyone can keep like 30 connections without much thinking. T

[GENERAL] Simple Web-based alternative to PgAdmin

2014-02-11 Thread AlexK
I would like to give my users the ability to invoke read-only functions and select statements, so that they can easily see the data. Both me and the users have experience mostly with SQL Server, so anyone can keep like 30 connections without much thinking. Since too many open connections seems to

[GENERAL] Why there is an empty err log statememt?

2014-02-11 Thread Prakash Itnal
Hi, Recently our customer reported an issue with empty error log statement from postgres server. I have printed the log snapshot below. The last line is an empty line. I know this is stupid question but just wanted to understand if there is any specific reason or it is just a miss. Jan 29 13:07:2

[GENERAL]

2014-02-11 Thread Nedal Slman
 hi i want to ask if there is any problem or fees to using Postgesql in commercial application like develop not open source application using Postgresql database and sell it .   Best Wishes Nedal Slman