Re: [ADMIN] creating a circular replication in postgres

[Jayesh Nambiar]

Thank you.

--- Jayesh
On Jul 5, 2013 9:59 PM, "bricklen"  wrote:

> On Thu, Jul 4, 2013 at 11:59 PM, Jayesh Nambiar wrote:
>
>> I am trying to achieve a circular replication with postgres; meaning two
>> postgres servers are slaves of each other.
>>
>
> Are you looking to do Multi-Master replication?
>
>
>> I went through Bucardo which uses perl scripts to achieve this, but I am
>> looking at something more native if available.
>>
>
> PostgreSQL does not support multimaster replication in the core product,
> but there are 3rd party tools that support it.
> Some other options are listed at:
>
> https://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C_and_Connection_Pooling
>
>

[ADMIN] PG wiki updated with query to show unindexed foreign keys

[bricklen]

https://wiki.postgresql.org/wiki/Unindexed_foreign_keys

Suggestions and feedback welcome on the query referenced in the link above.

Re: [ADMIN] pg_upgrade / postgis issue

[Sergey Konoplev]

On Thu, Jul 4, 2013 at 7:12 AM, Marcos Cano  wrote:
> yes i did the soft upgrade (seems to work) but when doing the pg_upgrade part 
> it seems to no work... ok thanks for your advice.. i will try.
>
> so i came up with an idea and it seems to work just wanna make sure what you 
> think?
>
> - do a custom pg_dump of postgres 8.3.2+postgis 1.3
> - do restore (with the perl script of postgis) within the postgres 
> 9.2.4+postgis 2.0.4

I have never tried it between two major postgres versions, but IMHO it
might work it you are talking about the hard postgis upgrade.

However I suggest you to try pg_upgrade with dump/delete/restore of
geography_columns first, because you will not face the full
dump/restore process in this case.

>
>
> On Wed, Jul 3, 2013 at 7:12 PM, Sergey Konoplev  wrote:
>>
>> On Mon, Jul 1, 2013 at 9:20 AM, Marcos Cano  wrote:
>> > content of the file tables_using_names.txt:
>> > Database: dev
>> >   public.geography_columns.f_table_schema
>> >   public.geography_columns.f_table_name
>> >   public.geography_columns.f_geography_column
>>
>> Hm... have you performed soft upgrade to PostGIS 1.5.8?
>>
>> If so then try to pg_dump the geography_columns table, then drop it,
>> do pg_upgrade, and restore the dump of geography_columns. It is just
>> my guess but it could help.
>>
>> --
>> Kind regards,
>> Sergey Konoplev
>> PostgreSQL Consultant and DBA
>>
>> Profile: http://www.linkedin.com/in/grayhemp
>> Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
>> Skype: gray-hemp
>> Jabber: gray...@gmail.com
>
>



--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray...@gmail.com


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Starting psql without connection

[Peter Eisentraut]

On Sun, 2013-07-07 at 10:11 +0200, Thorsten Kampe wrote:
> is it possible to start psql in interactive mode without connecting to
> a database (similar to "sqlplus /nolog" for Oracle databases)? 

No, that's not possible.



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] Starting psql without connection

[Thorsten Kampe]

Hi,

is it possible to start psql in interactive mode without connecting to a 
database (similar to "sqlplus /nolog" for Oracle databases)?

>From research I think it's not possible but I might have overlooked a 
simple thing...

Thorsten




-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin