Re: [ADMIN] pg Windows to PG FreeBSD

2010-04-23 Thread Scott Marlowe
On Fri, Apr 23, 2010 at 8:30 PM, herbey zepeda wrote: > I appologize, > > I did everything as stated in the manuals and more, but I did not remove the > comment character from the configuration file postgres.conf. The connection > from pg WIndows to pg Freebsd was succesful, No need for an apolog

Re: [ADMIN] pg Windows to PG FreeBSD

2010-04-23 Thread herbey zepeda
I appologize, I did everything as stated in the manuals and more, but I did not remove the comment character from the configuration file postgres.conf. The connection from pg WIndows to pg Freebsd was succesful, thanks for your reply On Fri, Apr 23, 2010 at 4:11 PM, Scott Marlowe wrote: > On

Re: [ADMIN] Postgres 8.5 partitioning

2010-04-23 Thread Devrim GÜNDÜZ
On Fri, 2010-04-23 at 13:27 -0700, Anj Adu wrote: > We are planning on deploying postgres 8.4 in a month or two to > production. From the expected feature list for 8.5, It is already 9.0. > I have seen one on simplified table partitioning. > > Will 8.5 have table partitions as first-class objec

[ADMIN] Postgres 8.5 partitioning

2010-04-23 Thread Anj Adu
We are planning on deploying postgres 8.4 in a month or two to production. From the expected feature list for 8.5, I have seen one on simplified table partitioning. Will 8.5 have table partitions as first-class objects (i.e not inheritted tables..but partitions) Also..will 8.5 have a migration o

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

2010-04-23 Thread Raúl Andrés Duque Murillo
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 un

Re: [ADMIN] pg Windows to PG FreeBSD

2010-04-23 Thread Scott Marlowe
On Fri, Apr 23, 2010 at 2:05 PM, herbey zepeda wrote: > hi > > I have one install of postgresql in Windows, and a second in FreeBSD. Both > are the 8.4 version > I am trying to connect from the windows install to the FreeBSD server > install > > > psql -h 10.10.90.125 -U myUser -d template1 > > an

[ADMIN] pg Windows to PG FreeBSD

2010-04-23 Thread herbey zepeda
hi I have one install of postgresql in Windows, and a second in FreeBSD. Both are the 8.4 version I am trying to connect from the windows install to the FreeBSD server install psql -h 10.10.90.125 -U myUser -d template1 and the result is: "Could not connect to server connection refusedis

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

2010-04-23 Thread Fernando Hevia
> -Mensaje original- > De: Luis Dominguez > > > Buenos dias, gente del software libre una vez mas necesito > de sus buenos conocimento para poder resolver un problema que > tengo presente y que a continuacion les comento, estamos en > un proceso de migracion de ms Slqserver/Window

Re: [ADMIN] register a service in Windows

2010-04-23 Thread BlackSkaven
Hello, just use pg_ctl register ;) http://www.postgresql.org/docs/8.4/interactive/app-pg-ctl.html Good luck, Peter Am 22.04.2010 20:11, schrieb Josi Perez (3T Systems): > I tried to use SC Windows command (Service Commander) with an > administrative login, but no success again: > net user *pos

Re: [ADMIN] SSL question

2010-04-23 Thread Jeffrey Gaynor
Never mind. I had misnamed the cert to root rather than server. Problem fixed. Oh and delaying posts a week sure is a great way to get people to expand their horizons. :o) - Original Message - From: "Jeffrey Gaynor" To: pgsql-admin@postgresql.org Sent: Tuesday, April 13, 2010 12:04:43

Re: [ADMIN] pg_dump: Error message from server: ERROR: compressed data is corrupt

2010-04-23 Thread Tom Lane
Achilleas Mantzios writes: > Then i did > # CREATE TABLE mail_entity2 AS SELECT * FROM mail_entity; > which went fine > but, for some crazy reason, pg_dump on mail_entity2 also results to an error: > srv:~> pg_dump -t mail_entity2 > /dev/null > pg_dump: SQL command failed > pg_dump: Error messa

[ADMIN] pg_dump: Error message from server: ERROR: compressed data is corrupt

2010-04-23 Thread Achilleas Mantzios
Hello, just coming back from a rescue marathon on this remote server i was telling you. As i said, the last problem was while doing a pg_dump dynacom (dynacom is my db'd name) i kept getting pg_dump: SQL command failed pg_dump: Error message from server: ERROR: compressed data is corrupt pg_du

Re: [ADMIN] pgsql 8.3.3 "Invalid page header" leads to "FATAL: segment too big"

2010-04-23 Thread Achilleas Mantzios
Στις Thursday 22 April 2010 19:02:00 ο/η Cédric Villemain έγραψε: > 2010/4/22 Achilleas Mantzios : > > Στις Thursday 22 April 2010 16:53:05 ο/η Cédric Villemain έγραψε: > >> 2010/4/22 Achilleas Mantzios : > >> > Hello, > >> > i have this serious problem in one of our remote vessels. (comm is done