Hello Everyone,
I am using postgres 9.2 and when executing function dblink facing a fatal
error while trying to execute dblink_connect as follows:
* SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres
password=test')*
*ERROR*: could not establish connection DETAIL: FATA
Great.. thanks a lot Laurenz Albe!
Works perfect !!
Regards - Dev
On Wed, Feb 6, 2013 at 7:00 PM, Albe Laurenz wrote:
> Dev Kumkar wrote:
> > I am using postgres 9.2 and when executing function dblink facing a
> fatal error while trying to
> > execute dblink_
s and authentication:
listen_addresses = '*'
Please suggest?
Thanks...
On Wed, Feb 6, 2013 at 11:25 PM, Dev Kumkar wrote:
> Great.. thanks a lot Laurenz Albe!
>
> Works perfect !!
>
> Regards - Dev
>
>
> On Wed, Feb 6, 2013 at 7:00 PM, Albe Laurenz wrot
olved this. Queries working fine.
So far so good..
Thanks...
On Thu, Feb 7, 2013 at 12:49 AM, Dev Kumkar wrote:
> Hey went ahead and tried to query across machines and facing following
> error:
>
> SELECT * FROM dblink_connect('host=x.x.x.x port=5432 dbname=postgres
> user=postgres
Hello Everyone,
A similar related topic is being discussed and tools are suggested for
Oracle DB to Postgresql migration.
Here my objective is migration of Sybase DB to Postgresql.
Again stored procedures, triggers and functions will be manual approach.
For schema part please provide suggestions
On Thu, May 2, 2013 at 8:12 PM, Dev Kumkar wrote:
> Hello Everyone,
>
> A similar related topic is being discussed and tools are suggested for
> Oracle DB to Postgresql migration.
>
> Here my objective is migration of Sybase DB to Postgresql.
>
> Again stored procedures
Also adding the pgsql-admin alias.
Regards...
On Wed, Jul 3, 2013 at 12:09 PM, etharani wrote:
> Hi,
>
> I am also working on sybase to postgresql. Please guide me on the same.
> send ur mail id.
> Any tool is available for migration?
>
Are you looking for data migration or porting the existing
schema's/procedures(at definition/sql level)?
