Re: PGSQL manager password lost.

If you do a pgdump -s will dump out schema only from the Postgres database.
Much of this will be usable in SQL server to at least create your basic
database and objects. You will then need to interpret the remianing more
complex structures and build them / adapt the DDL, to work in SQL Server.

If you have PGAdmin you should be able to login to the Postgres database as
a superuser and change the admin password, but be careful to change any
applications that may be using that login to access Postgres.

On 11/23/06, Paul Lambert, Help Desk Team Leader, BSD, Infomedia Ltd <
plambert(at)bsd(dot)infomedia(dot)com(dot)au> wrote:
>
> Hi folks, new to this mailing group and here are my first questions.
>
> We've been running a PGSQL database for a while now on a Weenblows 2K
> server, on version 8.0.something.
>
> Our resident DBA has been shown the door and has taken with himself the
> admin password to get into the databases we run in PostGreSQL.
>
> Question 1: Is there any way to recover and/or reset the administrator
> password in a database or do I have to recreate the db from scratch?
>
> Question 2: One of the DB's we run in PGSQL for reasons outside my control
> needs to be moved to M$-SQL server. Is there any way that anyone is aware of
> that I can export the database definition and data (table structures, views
> etc) into a format usable by SQL server - I know M$ speaks it's own version
> of SQL which I've run into problems with in the past. Just looking for some
> suggestions on what I can do, otherwise I have to wade through a few
> thousand lines of SQL to make it workable in M$. Is is possible to pipe
> table structures/views through an ODBC connection? Is this something I
> should be asking on M$ forums?
>
> --
> Paul Lambert
> Database Administrator
> Infomedia Ltd. - Business Systems Division
> Email: *plambert(at)infomedia(dot)com(dot)au* <plambert(at)infomedia(dot)com(dot)au> <*
> http://www.infomedia.com.au* <http://www.infomedia.com.au/>>
>
>
>