PGSQL manager password lost.

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 <mailto:plambert(at)infomedia(dot)com(dot)au>
<http://www.infomedia.com.au <http://www.infomedia.com.au/> >