Re: [ADMIN] when does postgresql read from pg_hba.conf ??

2010-04-26 Thread Julius Tuskenis
2010.04.26 19:33, Alvaro Herrera rašė: Do you want to say that on windows postgresql acts differently? Yes. Thank you, Alvaro, Your answer was a big surprise for me. On the other hand now I at least know there is nothing wrong with postgresql server. -- Julius Tuskenis Programavimo

Re: [ADMIN] when does postgresql read from pg_hba.conf ??

2010-04-26 Thread Alvaro Herrera
Julius Tuskenis wrote: > Hello, Alvaro Herrera > > 2010.04.26 18:38, Alvaro Herrera rašė: > >Hmm, isn't the file read every time a backend starts on Windows? > >This would explain the problem if the file was edited between 13:56:45 > >and 13:57:38. > > > Do you want to say that on windows postgres

Re: [ADMIN] [pgsql-es-ayuda] REF: Migracion de Sqlserver a Postgresql

2010-04-26 Thread Raúl Andrés Duque
Parece que estás con suerte: la versión 1.0 de odbc-link para Postgresql acaba de ser lanzada. http://www.cybertec.at/en/postgresql_downloads Es un conector de Postgres hacía otras bases a través de odbc y en tu caso amerita lo pruebes. Interesante. No tengo muy claro como se instalaría una l

Re: [ADMIN] Postgres 8.5 partitioning

2010-04-26 Thread Greg Smith
Anj Adu wrote: Will 8.5 have table partitions as first-class objects (i.e not inheritted tables..but partitions) What was originally going to be 8.5 was renumbered to be 9.0. None of the planned partitioning improvements are included in it. The changes planned there aren't a large as yo

Re: [ADMIN] when does postgresql read from pg_hba.conf ??

2010-04-26 Thread Julius Tuskenis
Hello, Alvaro Herrera 2010.04.26 18:38, Alvaro Herrera rašė: Hmm, isn't the file read every time a backend starts on Windows? This would explain the problem if the file was edited between 13:56:45 and 13:57:38. Do you want to say that on windows postgresql acts differently? The pg_hba.conf

Re: [ADMIN] when does postgresql read from pg_hba.conf ??

2010-04-26 Thread Alvaro Herrera
Julius Tuskenis wrote: > Hello, list > > from the postgresql documentation I know, that "The pg_hba.conf file > is read on start-up and when the main server process receives a > SIGHUP signal. If you edit the file on an active system, you will > need to signal the server (using pg_ctl reload or ki

Re: [ADMIN] Installation issue

2010-04-26 Thread Devrim GÜNDÜZ
On Mon, 2010-04-26 at 06:51 +, debajyoti pal wrote: > > I was trying to install 8.4.3 , when i ran gmake after configure , i > got this error .. > gmake[3]: *** No rule to make target `utf8_and_euc_jis_2004.o', needed > by `utf8_and_euc_jis_2004.so'. Stop. > I am using following version of

[ADMIN] when does postgresql read from pg_hba.conf ??

2010-04-26 Thread Julius Tuskenis
Hello, list from the postgresql documentation I know, that "The pg_hba.conf file is read on start-up and when the main server process receives a SIGHUP signal. If you edit the file on an active system, you will need to signal the server (using pg_ctl reload or kill -HUP) to make it re-read th

[ADMIN] Installation issue

2010-04-26 Thread debajyoti pal
Hello , I was trying to install 8.4.3 , when i ran gmake after configure , i got this error .. gmake[3]: *** No rule to make target `utf8_and_euc_jis_2004.o', needed by `utf8_and_euc_jis_2004.so'. Stop. gmake[3]: Leaving directory `/tmp/postgresql-8.4.3/src/backend/utils/mb/conversion_procs/ut