Re: [GENERAL] Why lots of temp schemas are being created

Thank you for your response. Dear all, Our software use postgres as backend database. It works fine, strange thing is that, it creates so many temporary schemas under schema tab, names like pg_toast, pg_toast_temp_1 like this upto pg_toast_temp40. This schemas also reflected in "pg_names

[GENERAL] Why lots of temp schemas are being created

dy tell me, is there anything wrong in it? Should I get rid of these temporary schemas? Any suggestion on this, please. --- Thanks & Reagrds ---- Anirban Pal Disclaimer :- This e-mail and any attachment may contain confidential, proprietary or legally privileged infor

[GENERAL] How to know the indexes on a Table

Hi all, Is there any way, to know the name of indexes on a table, defined in a database. I mean can I query something like Select Index_name from pg_class where relname = "Table_name" . Thanks in advance. --- Thanks & Reagrds ---- Anirban Pal | Software Engineer N

Re: [GENERAL] Postgres registry access using java

ly. I have opened every system table, to find base directory location. I didn't find, may be I am missing something. Can you enrich me with the table name, where home directory (or installed directory not the data directory) location is mentioned.RegardsAnirban Anirban Pal wrote: 1st

Re: [GENERAL] Postgres registry access using java

linux, but I have OS checking part in my code. So, registry part will not run while on linux. I have different logic (sompe file reading/scanning) for linux , solaris. Regards Anirban Anirban Pal wrote: Can any body tell me how to fetch directory path for lib or data directory for postgres

Re: [GENERAL] How to Install Postgres 8.3 in Solaris 10 as a service

@Merlin, @Emanuel Thank you for your reply. It will surely solve my problem. Dear all members, I have been working on postgres (windows), for last 8 months. Recently, a client requrement requires me to install postgres in solaris 10. What I did is this. Untar the deliverables from postgres

Re: [GENERAL] Postgres registry access using java

Thanks Josh for your kind reply. In the pg_settings table all reference to the folder is with reference to data directory. Like "config_file" "C:/Program Files/PostgreSQL/8.3/data/postgresql.conf""data_directory" "C:/Program Files/PostgreSQL/8.3/data""hba_file" "C:/Program Files/PostgreSQ

Re: [GENERAL] Postgres registry access using java

Thanks Josh for your kind reply. In the pg_settings table all reference to the folder is with reference to data directory. Like "config_file" "C:/Program Files/PostgreSQL/8.3/data/postgresql.conf""data_directory" "C:/Program Files/PostgreSQL/8.3/data""hba_file" "C:/Program Files/PostgreSQL/8.

[GENERAL] Postgres registry access using java

Hi all, Can any body tell me how to fetch directory path for lib or data directory for postgres installation in windows using registry. Solution using Java language will be highly solicited. --- Thanks & Reagrds ---- Anirban Pal | Software Engineer Disclaimer :- This e-mail and

[GENERAL] How to Install Postgres 8.3 in Solaris 10 as a service

run postgres as a service, in Solaris 10 (64 bit) also, like windows. Waiting for positive reply. Regards Anirban Pal Disclaimer :- This e-mail and any attachment may contain confidential, proprietary or legally privileged information. If you are not the original intended recipient and have