From: David G. Johnston [mailto:david.g.johns...@gmail.com]
Sent: Monday, September 28, 2015 3:14 PM
To: Igor Neyman
Cc: Ramesh T ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Format
On Mon, Sep 28, 2015 at 1:59 PM, Igor Neyman
mailto:iney...@perceptron.com>> wrote:
Hi All,
H
Tom Lane wrote:
> Thom Brown writes:
> > On 28 September 2015 at 22:21, Spencer Gardner
> > wrote:
> >> Actually, yes. That's the reason for backing up. We had been playing with
> >> BDR on a custom build but have reverted to the stock Ubuntu build for the
> >> time being. So it sounds like the
Thom Brown writes:
> On 28 September 2015 at 22:21, Spencer Gardner
> wrote:
>> Actually, yes. That's the reason for backing up. We had been playing with
>> BDR on a custom build but have reverted to the stock Ubuntu build for the
>> time being. So it sounds like the issue is caused by dumping f
On 28 September 2015 at 22:21, Spencer Gardner wrote:
> Actually, yes. That's the reason for backing up. We had been playing with
> BDR on a custom build but have reverted to the stock Ubuntu build for the
> time being. So it sounds like the issue is caused by dumping from our custom
> BDR build.
Actually, yes. That's the reason for backing up. We had been playing with
BDR on a custom build but have reverted to the stock Ubuntu build for the
time being. So it sounds like the issue is caused by dumping from our
custom BDR build. It's not really a big issue - I've already rebuilt the
affected
On 28 September 2015 at 21:47, Tom Lane wrote:
> Spencer Gardner writes:
>> I'm transferring all of the databases on my old postgres server to a new
>> server. To do this I'm using pg_dump and then pg_restore:
>
>> pg_dump --host localhost --port 5432 --username "postgres" --format custom
>> --bl
Spencer Gardner writes:
> I'm transferring all of the databases on my old postgres server to a new
> server. To do this I'm using pg_dump and then pg_restore:
> pg_dump --host localhost --port 5432 --username "postgres" --format custom
> --blobs --file ~/backups/census.backup census
> --and then-
I'm transferring all of the databases on my old postgres server to a new
server. To do this I'm using pg_dump and then pg_restore:
pg_dump --host localhost --port 5432 --username "postgres" --format custom
--blobs --file ~/backups/census.backup census
--and then--
pg_restore -Cv -h localhost -p 54
>
>
> Not only, there is little of formatting, like TABs.
>
> But, even highlighting helps.
>
>
>
Since pgAdminIII does highlighting I figured the OP wanted something
more...I know what I am looking is more than just highlighting.
David J.
On Mon, Sep 28, 2015 at 1:59 PM, Igor Neyman wrote:
> Hi All,
>
> How to change sql format to look beautiful and understandable
> using pgadmin3 or else ther tools for postgres.
>
>
>
> any help appreciated..
>
>
>
>
>
> Are you looking for SQL editor?
>
> If that’s the case, take a loo
Hi All,
How to change sql format to look beautiful and understandable using
pgadmin3 or else ther tools for postgres.
any help appreciated..
Are you looking for SQL editor?
If that’s the case, take a look at contexteditor.org
Regards,
Igor Neyman
On Mon, Sep 28, 2015 at 9:12 AM, Keith Fiske wrote:
>
>
> On Mon, Sep 28, 2015 at 10:54 AM, Scott Marlowe
> wrote:
>>
>> On Mon, Sep 28, 2015 at 8:48 AM, CS DBA
>> wrote:
>> > All;
>> >
>> > We have a 3 node replication setup:
>> >
>> > Master (node1) --> Cascading Replication Node (node2) -->
CREATE FUNCTION
CREATE VIEW
As yes, I am being mostly serious - though I have been pondering seeing
what tools can do as opposed to the manual formatting I've been
performing. Even a basic linter would be helpful...
The big problem is you need to define what it means to be beautiful.
Understanda
Hi All,
How to change sql format to look beautiful and understandable
using pgadmin3 or else ther tools for postgres.
any help appreciated..
On Sun, 27 Sep 2015 20:13:17 -0500
Jim Nasby wrote:
Hi Jim, Tom
>
> Not to mention the issue of what happens when someone updates tblcontrat
> or tblagent. (It'd be cool if we had cross-table indexes, but this
> certainly isn't how to do it...)
>
I have checks in the application logic to pr
On Sun, 27 Sep 2015 14:34:24 -0700
Adrian Klaver wrote:
>
Hi Adrian
> What are your pg_dump/pg_restore commands?
>
> Are you using the 9.4 version of pg_dump to dump the 9.1 server or the
> 9.1 version?
>
Combinations of all these, always the same result.
> Hmm, just had a thought. Wonder
On Mon, Sep 28, 2015 at 08:54:54AM -0600, Scott Marlowe wrote:
> Look up WAL-E. It's works really well. We tried using OmniPITR and
> it's buggy and doesn't seem to get fixed very quickly (if at all).
Any examples? I'm developer of OmniPITR, and as far as I know there are
(currently) no unfixed bu
On Mon, Sep 28, 2015 at 10:54 AM, Scott Marlowe
wrote:
> On Mon, Sep 28, 2015 at 8:48 AM, CS DBA
> wrote:
> > All;
> >
> > We have a 3 node replication setup:
> >
> > Master (node1) --> Cascading Replication Node (node2) --> Downstream
> > Standby node (node3)
> >
> > We will be deploying WAL a
On Mon, Sep 28, 2015 at 8:48 AM, CS DBA wrote:
> All;
>
> We have a 3 node replication setup:
>
> Master (node1) --> Cascading Replication Node (node2) --> Downstream
> Standby node (node3)
>
> We will be deploying WAL archiving from the master for PITR backups and
> we'll use the staged WAL file
All;
We have a 3 node replication setup:
Master (node1) --> Cascading Replication Node (node2) --> Downstream
Standby node (node3)
We will be deploying WAL archiving from the master for PITR backups and
we'll use the staged WAL files in the recovery.conf files in case the
standbys need to
Thanks Tom! I need to read in more detail in the future, I'd hit the
function definition, and scanned to find the keyword to get WOY.
I'll switch my code to ISOYEAR per the doc.
Ben
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Friday, September 25, 2015 5:01 PM
To:
Thomas Kellerer wrote:
Mark Morgan Lloyd schrieb am 25.09.2015 um 23:41:
I'm trying to get support for PostgreSQL's listen/notify into a
development environment, but since it supports multiple database
backends: can anybody comment on how many other servers have a
comparable facility?
Minimal r
On Tue, Sep 15, 2015 at 7:19 AM, Jim Nasby wrote:
> On 9/14/15 11:59 AM, David G. Johnston wrote:
>>
>> On Mon, Sep 14, 2015 at 11:11 AM, Ingmar Brouns wrote:
>> However, when I dump the schema using pg_dump, and then load the
>> resulting sql file, suddenly 'c' does follow 'a'. So restorin
23 matches
Mail list logo