Si quieres hacer eso que dices desde Postgres simplemente no se puede. Puedes
mirar un poco con DBI-LINK no se que tanto estara avanzado o si no ha sido
abandonado, pero poder ligar en un mismo select tablas de ambos motores no
podras hacerlo, Postgres no soporta eso, pero con DBI-Link no se si
Thanks Ross and Scott. I got it to complete finally thanks to Ross' tip of
looking at pg_locks. I had to kill a few processes with exclusive locks on the
table and then presto!
Scott, the query didn't have a DEFAULT keyword with it and I've got a request
in with our sysadmins to upgrade us to
Hi Peter,
The link you mention below does not say that Operating System user
postgres, should not have Administrator privileges,
It says user postgres may not have sufficient privileges and could fail
to create the Data directory, in that case, create Data directory by
root user and change ownersh
Hello Pankaj,
well - obviously initdb wasn't run by (the operating system's user)
postgres. The owner of the server process (normally named postgres)
mustn't have any administrator privileges:
http://www.postgresql.org/docs/8.4/interactive/app-initdb.html
Good luck.
Maybe there wasn't any probl
I tried to use SC Windows command (Service Commander) with an administrative
login, but no success again:
net user *postgres* mypass /add
*sc* *create* pgsql-8.4 binpath= "C:\*postgres*\8.4\bin\pg_ctl.exe
runservice -w -N pgsql-8.4 -D C:\data5\" type=own start=auto displayname= "*
PostgreSQL* 8.4
Estimado,
Te recomiendo algo mucho mas sencillo y eficaz para tu gestion de migracion.
Kettle de pentaho.
Con este ETL , podras transportar datos e informacion de donde sea, para
donde sea.
Un saludo,
German Salinas.
El 22 de abril de 2010 10:15, Luis Dominguez escribió:
>
>
> Buenos di
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 by
>> > minicom to the remote satelite modem)
>> > I think that this server
Στις Thursday 22 April 2010 17:42:33 γράψατε:
> Achilleas Mantzios writes:
> > Then i did: (as i said i do not need the contents of msgsource - yet the
> > contents of msgno are vital)
> > dd if=/dev/zero of=/usr/local/var/lib/pgsql/data/base/125714957/125716013
> > seek=672720 bs=8192 count=1
Στις 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 by
> > minicom to the remote satelite modem)
> > I think that this server was under some sort of constant resets
Achilleas Mantzios writes:
> Then i did: (as i said i do not need the contents of msgsource - yet the
> contents of msgno are vital)
> dd if=/dev/zero of=/usr/local/var/lib/pgsql/data/base/125714957/125716013
> seek=672720 bs=8192 count=1
> However, after that, unfortunately i get constant pos
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/Windows a postgresql/linux especificamente fedora 8 + Postgres 8.4.2,
2010/4/22 Achilleas Mantzios :
> Hello,
> i have this serious problem in one of our remote vessels. (comm is done by
> minicom to the remote satelite modem)
> I think that this server was under some sort of constant resets or hardware
> failures.
> Initially,i had this problem:
> ERROR: invalid
Hello,
i have this serious problem in one of our remote vessels. (comm is done by
minicom to the remote satelite modem)
I think that this server was under some sort of constant resets or hardware
failures.
Initially,i had this problem:
ERROR: invalid page header in block 672720 of relation "pg_t
13 matches
Mail list logo
