Had to do some migration from Oracle to PostgreSQL and did a write-up on
the complete process. Hope someone finds it useful:
http://wiki.kandalaya.org/cgi-bin/twiki/view/Main/MigratingOracleToPostgreSQL
Feedback welcome,
Regards,
-- Raju
--
Raj Mathurr...@kandalaya.org
since that
ships with PgSQL by default with Red Hat, but are there any reasons to
choose one over the other?
Regards,
-- Raju
--
Raj Mathur[EMAIL PROTECTED] http://kandalaya.org/
It is the mind that moves
---(end of
Hi Thomas,
>>>>> "Thomas" == Thomas Swan <[EMAIL PROTECTED]> writes:
Thomas> Raj Mathur wrote:
>> Hi,
>>
>> Writing a web-based application using PostgreSQL as the
>> back-end database. The master create functions lo
>>>>> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Raj Mathur <[EMAIL PROTECTED]> writes:
>> ... However, the complementary process, determining all the
>> users in group administrators, isn't so clean.
Tom>
re whether the user is an administrator or not rather
than have another table keeping that information. However, I'd change
that if the structure of the pg_ tables is subject to change from time
to time.
Regards,
-- Raju
--
Raj Mathur[EMAIL PROTECTED] http://kandalaya.org/
I tried an "update pg_shadow set passwd=... where usename=..."
Regards,
-- Raju
--
Raj Mathur[EMAIL PROTECTED] http://kandalaya.org/
GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F
It is the mind that moves
--
Erhm, the last line of the earlier mail should read:
I tried an "update pg_shadow set passwd=... where usename=..." but
that doesn't do the trick: Postgresql does not authenticate the user.
Regards,
-- Raju
--
Raj Mathur[EMAIL PROTECTED] http://kandalaya.
>>>>> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Raj Mathur <[EMAIL PROTECTED]> writes:
>> Using Postgresql 7.2.3 on Linux, is there an easy way to
>> transfer user passwords from one database to another?
Tom> You co
>>>>> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Raj Mathur <[EMAIL PROTECTED]> writes:
>> mdu=# alter user raju with encrypted password 'raju'; ALTER
>> USER mdu=# se
ls I can use to figure out what's going on with the
client/server? pgmonitor doesn't give any additional information
(except ``no query is being executed'').
Regards,
-- Raju
--
Raj Mathur[EMAIL PROTECTED] http://kandalaya.org/
GPG: 78D4 FC67 367F
>>>>> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Raj Mathur <[EMAIL PROTECTED]> writes:
>> I'm consistently getting into a situation where the database
>> client just goes to sleep in a query after some number of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
>>>>> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Raj Mathur <[EMAIL PROTECTED]> writes:
>> I'm consistently getting into a situation where the database
>> client just goes t
12 matches
Mail list logo
