[ADMIN] Starting psql without connection

2013-07-07 Thread 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@postg

Re: [ADMIN] Starting psql without connection

2013-07-07 Thread 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

Re: [ADMIN] pg_upgrade / postgis issue

2013-07-07 Thread 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

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

2013-07-07 Thread bricklen
https://wiki.postgresql.org/wiki/Unindexed_foreign_keys Suggestions and feedback welcome on the query referenced in the link above.

Re: [ADMIN] creating a circular replication in postgres

2013-07-07 Thread 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 replicati