Re: [GENERAL] Accessing pg_controldata information from SQL

2009-06-04 Thread Bruce Momjian
Massa, Harald Armin wrote: > Bruce, > > I am thinking your best solution is to create a table with a uuid column > > and reference that to sync up your data. That would also allow data > > dumps to be restored to another machine with the proper identifier > > because the identifier is really a ch

Re: [GENERAL] Accessing pg_controldata information from SQL

2009-06-04 Thread Massa, Harald Armin
Bruce, I am thinking your best solution is to create a table with a uuid column > and reference that to sync up your data. That would also allow data > dumps to be restored to another machine with the proper identifier > because the identifier is really a characteristic of the data, not of > the

Re: [GENERAL] Accessing pg_controldata information from SQL

2009-06-04 Thread Bruce Momjian
Massa, Harald Armin wrote: > Bruce, > > > would be "database system identification" - the rather unique ID of a > > > > database installation. Third line in pg_controldata output: > > > > > -- > > > Datenb

Re: [GENERAL] Accessing pg_controldata information from SQL

2009-06-04 Thread Massa, Harald Armin
Bruce, > would be "database system identification" - the rather unique ID of a > > database installation. Third line in pg_controldata output: > > > -- > > Datenbanksystemidentifikation:5293702

Re: [GENERAL] Accessing pg_controldata information from SQL

2009-06-03 Thread Bruce Momjian
Massa, Harald Armin wrote: > Hello Bruce, > > I am specifically looking for the "Datenbanksystemidentifikation" , that > would be "database system identification" - the rather unique ID of a > database installation. Third line in pg_controldata output: > > > pg_control-Versionsnummer:

Re: [GENERAL] Accessing pg_controldata information from SQL

2009-06-03 Thread Massa, Harald Armin
Hello Bruce, I am specifically looking for the "Datenbanksystemidentifikation" , that would be "database system identification" - the rather unique ID of a database installation. Third line in pg_controldata output: pg_control-Versionsnummer:833 Katalogversionsnummer:

Re: [GENERAL] Accessing pg_controldata information from SQL

2009-06-02 Thread Bruce Momjian
Massa, Harald Armin wrote: > Hello, > > is there any way to acess the pg_controldata information via SQL? > > (running pg_controldata via shell needs file access to the postgresql data > dictionary, which is usually not given) Some of the settings have read-only variables that appear in SHOW ALL

[GENERAL] Accessing pg_controldata information from SQL

2009-05-08 Thread Massa, Harald Armin
Hello, is there any way to acess the pg_controldata information via SQL? (running pg_controldata via shell needs file access to the postgresql data dictionary, which is usually not given) Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stutt