Re: pmt.postgresql.org to move tonight

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,

Marc when you get to a point where you can :) I want to move
pmt.postgresql.org to: 207.173.203.166

Please let me know when this DNS change can be put in place.

Sincerely,

Joshua D. Drake

P.S. In case it isn't obvious we will suffer a brief outage from this.
Pmt is an internal postgresql domain so the effects should be minimal.

- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHvGrnATb/zqfZUUQRAhd0AJ4tlusg6SyW2RYWrze/JrmheqdtYwCfWvB2
yMruDih7OLrnfxXSIkyWtT8=
=cSzL
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

whenever you are ready ...

- --On Wednesday, February 20, 2008 10:01:11 -0800 "Joshua D. Drake"
<jd(at)commandprompt(dot)com> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello,
>
> Marc when you get to a point where you can :) I want to move
> pmt.postgresql.org to: 207.173.203.166
>
> Please let me know when this DNS change can be put in place.
>
>
> Sincerely,
>
> Joshua D. Drake
>
> P.S. In case it isn't obvious we will suffer a brief outage from this.
> Pmt is an internal postgresql domain so the effects should be minimal.
>
> - --
> The PostgreSQL Company since 1997: http://www.commandprompt.com/
> PostgreSQL Community Conference: http://www.postgresqlconference.org/
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
> PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFHvGrnATb/zqfZUUQRAhd0AJ4tlusg6SyW2RYWrze/JrmheqdtYwCfWvB2
> yMruDih7OLrnfxXSIkyWtT8=
> =cSzL
> -----END PGP SIGNATURE-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

- ----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . scrappy(at)hub(dot)org MSN . scrappy(at)hub(dot)org
Yahoo . yscrappy Skype: hub.org ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHvJ/n4QvfyHIvDvMRAkvxAKCclhUq7QT4ZPyfIbDqmcjmzaA9dACgkWhS
8H6BJDaA5Cn+2XKsZLM9YaI=
=6vaJ
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 20 Feb 2008 17:47:19 -0400
"Marc G. Fournier" <scrappy(at)hub(dot)org> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> whenever you are ready ...

O.k. let me get it moved. Will ping back.

Joshua D. Drake

- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHvKKfATb/zqfZUUQRArX1AJ96v53ovLMl/xYAuIRIeA5sjoOqKwCgj/DJ
VZCMkjBIxKE//FOxdHxNViI=
=XOho
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 20 Feb 2008 13:58:55 -0800
"Joshua D. Drake" <jd(at)commandprompt(dot)com> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Wed, 20 Feb 2008 17:47:19 -0400
> "Marc G. Fournier" <scrappy(at)hub(dot)org> wrote:
>
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> >
> > whenever you are ready ...
>
> O.k. let me get it moved. Will ping back.

O.k. you can move it. It appears good. Just for clarification:

pmt.postgresql.org -> 207.173.203.166

Sincerely,

Joshua D. Drake

- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHvKWmATb/zqfZUUQRAhmRAJwK+rcTaDAdXiFHcMXiyIZFSU7mqwCeJv4G
dSaA4sVV5YoXpKvC6aaK3Yo=
=Rilg
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 20 Feb 2008 14:11:48 -0800
"Joshua D. Drake" <jd(at)commandprompt(dot)com> wrote:

> > O.k. let me get it moved. Will ping back.
>
> O.k. you can move it. It appears good. Just for clarification:
>
> pmt.postgresql.org -> 207.173.203.166
>

Marc?

Joshua D. Drake

- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHvLEcATb/zqfZUUQRAo7BAJ9KFmYWRExTHtu+L+VqP78Z38Q05gCfSVYx
pa4SJghx8brhmY7bfwK3cgg=
=xjkK
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Done ...

- --On Wednesday, February 20, 2008 14:11:48 -0800 "Joshua D. Drake"
<jd(at)commandprompt(dot)com> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Wed, 20 Feb 2008 13:58:55 -0800
> "Joshua D. Drake" <jd(at)commandprompt(dot)com> wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> On Wed, 20 Feb 2008 17:47:19 -0400
>> "Marc G. Fournier" <scrappy(at)hub(dot)org> wrote:
>>
>> > -----BEGIN PGP SIGNED MESSAGE-----
>> > Hash: SHA1
>> >
>> >
>> > whenever you are ready ...
>>
>> O.k. let me get it moved. Will ping back.
>
> O.k. you can move it. It appears good. Just for clarification:
>
> pmt.postgresql.org -> 207.173.203.166
>
> Sincerely,
>
> Joshua D. Drake
>
> - --
> The PostgreSQL Company since 1997: http://www.commandprompt.com/
> PostgreSQL Community Conference: http://www.postgresqlconference.org/
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
> PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFHvKWmATb/zqfZUUQRAhmRAJwK+rcTaDAdXiFHcMXiyIZFSU7mqwCeJv4G
> dSaA4sVV5YoXpKvC6aaK3Yo=
> =Rilg
> -----END PGP SIGNATURE-----

- ----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . scrappy(at)hub(dot)org MSN . scrappy(at)hub(dot)org
Yahoo . yscrappy Skype: hub.org ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHvMtT4QvfyHIvDvMRAvnBAJ4r75hsxLrxFYTtbK4GX07kyq09RQCg14u+
eerbhKlsaTkPBsnBPVbSg10=
=PFV2
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 20 Feb 2008 20:52:35 -0400
"Marc G. Fournier" <scrappy(at)hub(dot)org> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> Done ...
>

Excellent and verified:

[root(at)community2 public_html]# nslookup pmt.postgresql.org 4.2.2.2
Server: 4.2.2.2
Address: 4.2.2.2#53

Non-authoritative answer:
Name: pmt.postgresql.org
Address: 207.173.203.166

Sincerely,

Joshua D. Drake

- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHvNazATb/zqfZUUQRAgtuAJ4ySrpfag48qdOtUXH1ZT1YfebAQgCfYMox
+OdyGxxxOG/Kc4Tv4mn43iU=
=N5ne
-----END PGP SIGNATURE-----

Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Wed, 20 Feb 2008 20:52:35 -0400
> "Marc G. Fournier" <scrappy(at)hub(dot)org> wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>>
>> Done ...
>>
>
> Excellent and verified:

yeah but the site is now broken - it's using the wrong ssl-cert(pgweb
instead of pmt) and therefor breaking a lots of internal stuff, the
http->https redirect is gone too :-(

Stefan

Stefan Kaltenbrunner wrote:
> Joshua D. Drake wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> On Wed, 20 Feb 2008 20:52:35 -0400
>> "Marc G. Fournier" <scrappy(at)hub(dot)org> wrote:
>>
>>> -----BEGIN PGP SIGNED MESSAGE-----
>>> Hash: SHA1
>>>
>>>
>>> Done ...
>>>
>>
>> Excellent and verified:
>
> yeah but the site is now broken - it's using the wrong ssl-cert(pgweb
> instead of pmt) and therefor breaking a lots of internal stuff, the
> http->https redirect is gone too :-(

that's most likely due to the fact that pmt and pgweb are now pointo to
the SAME ip which is surely not going to work for https ...

Stefan

On Thu, Feb 21, 2008 at 9:47 AM, Stefan Kaltenbrunner
<stefan(at)kaltenbrunner(dot)cc> wrote:
> > Excellent and verified:
>
> yeah but the site is now broken - it's using the wrong ssl-cert(pgweb
> instead of pmt) and therefor breaking a lots of internal stuff, the
> http->https redirect is gone too :-(

Such as auto-backup on every server :-(

In fact, pmt seems to have completely vanished.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database company

Dave Page wrote:
> On Thu, Feb 21, 2008 at 9:47 AM, Stefan Kaltenbrunner
> <stefan(at)kaltenbrunner(dot)cc> wrote:
>> > Excellent and verified:
>>
>> yeah but the site is now broken - it's using the wrong ssl-cert(pgweb
>> instead of pmt) and therefor breaking a lots of internal stuff, the
>> http->https redirect is gone too :-(
>
> Such as auto-backup on every server :-(
>
> In fact, pmt seems to have completely vanished.
>

This is on the list for the morning.

Joshua D. Drake

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 21 Feb 2008 09:58:17 +0000
"Dave Page" <dpage(at)pgadmin(dot)org> wrote:

> On Thu, Feb 21, 2008 at 9:47 AM, Stefan Kaltenbrunner
> <stefan(at)kaltenbrunner(dot)cc> wrote:
> > > Excellent and verified:
> >
> > yeah but the site is now broken - it's using the wrong
> > ssl-cert(pgweb instead of pmt) and therefor breaking a lots of
> > internal stuff, the http->https redirect is gone too :-(
>
> Such as auto-backup on every server :-(
>
> In fact, pmt seems to have completely vanished.
>

O.k. my bad. Marc can you please fix my mistake. I need you to point:

pmt.postgresql.org -> 207.173.203.185

I have tested by changing my hosts file to

207.173.203.185 pmt.postgresql.org

When I click my lovely view cert everything appears kosher. I have also
resynced the trac with the svn.

I am able to login, I am able to co svn (and it asks me to accept the
certificate:

Certificate information:
- Hostname: pmt.postgresql.org
- Valid: from Wed, 08 Aug 2007 13:21:06 GMT until Sat, 05 Aug 2017
13:21:06 GMT

I am also able to commit.

Please let me know if I missed anything. Sorry for the noise.

Sincerely,

Joshua D. Drake

- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHvbYUATb/zqfZUUQRAkDGAJ9f78CrouvKRM2IWG2KLIuovQJqmQCeJ9JU
zoSygaLUp8s6g1wkWeB7Tq4=
=SxUE
-----END PGP SIGNATURE-----

> pmt.postgresql.org -> 207.173.203.185

Update running now ...

Dave Page wrote:
> On Thu, Feb 21, 2008 at 9:47 AM, Stefan Kaltenbrunner
> <stefan(at)kaltenbrunner(dot)cc> wrote:
>> > Excellent and verified:
>>
>> yeah but the site is now broken - it's using the wrong ssl-cert(pgweb
>> instead of pmt) and therefor breaking a lots of internal stuff, the
>> http->https redirect is gone too :-(
>
> Such as auto-backup on every server :-(
>
> In fact, pmt seems to have completely vanished.
>

This seems to work now, can you please verify?

Joshua D. Drake