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)?
Also adding the pgsql-admin alias.
Regards...
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
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
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
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
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_
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
. I'm also able to get
acls granted in a particular database table using
information_schema.role_table_grants. Is it possible to do this kind of
querying across all databases hosted on the cluster without having to connect
to each and query them. ?
/Dev
create database command and specify
mytemplate
i.e
create database testdb template mytemplate;
Everything works fine except that the table in the newly created testdb is
still the user postgres, the one who created the template database.
Is this expected behavior or am I missing something?
/Dev
Well! answering my own question using " works !
/Dev
--- On Thu, 7/10/08, Dev <[EMAIL PROTECTED]> wrote:
From: Dev <[EMAIL PROTECTED]>
Subject: [ADMIN] create role syntax
To: pgsql-admin@postgresql.org
Date: Thursday, July 10, 2008, 10:30 AM
Hi,
Is it possible to hav
Hi,
Is it possible to have numbers as role names? I tried doing something
like
create role 1 login createdb
but I get a syntax error, however if I have an alphabet before the number it
seems to work.
For example like
create role x1 login createdb
/Dev
Thanx for all the suggestions. I'm planning to go ahead with the trigger
approach and locking databases for writes when it goes over the threshold!
Setting hard limits looks like a bad idea !
cheers
/Dev
--- On Thu, 7/3/08, Tino Schwarze <[EMAIL PROTECTED]> wrote:
From: Tino Schwa
yes, thats an option but currently the last resort! Doesn't it get difficult to
manage so many instances of servers ? Also don't we then need to keep track of
different port numbers for each user/group ?
/Dev
--- On Thu, 7/3/08, Kevin Grittner <[EMAIL PROTECTED]> wrote:
From
w informing the admin about db's
getting over the threshold size.
Is there anyone who has tried a better way to limit the db sizes ?
cheers
/Dev
Hi All,
Is there any utility available to compare two tables
Regards,
Sachdev
16 matches
Mail list logo
