headers
Mark Corner | 1 Feb 2010 17:02
Picon

Using pg_migrator to upgrade 8.3->8.4

We are looking to upgrade out 8.3 db to 8.4.  The full dump and
restore is not very attractive due to the downtime involved.

pg_migrator is an attractive option, but we have butted up again the
integer datetime timestamp problem:

"Old and new pg_controldata date/time storage types do not match.

You will need to rebuild the new server with configure
--disable-integer-datetimes or get server binaries built
with those options."

We also noticed that the are non id rpms available for 8.3, but we
couldn't find any for 8.4 here:
https://projects.commandprompt.com/public/pgcore

So, is the best option to compile postgres from source?  Is there
anyway to change the storage of timestamps in our 8.3 db online (I am
guessing no...)?

Mostly I just need a sanity check before I waste a bunch of time :)

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Permalink | Reply | 12 comments |
headers
Bruce Momjian | 1 Feb 2010 17:12
Picon
Favicon
Gravatar

Re: Using pg_migrator to upgrade 8.3->8.4

Mark Corner wrote:
> We are looking to upgrade out 8.3 db to 8.4.  The full dump and
> restore is not very attractive due to the downtime involved.
> 
> pg_migrator is an attractive option, but we have butted up again the
> integer datetime timestamp problem:
> 
> "Old and new pg_controldata date/time storage types do not match.
> 
> You will need to rebuild the new server with configure
> --disable-integer-datetimes or get server binaries built
> with those options."

Yep, that is necessary.

> We also noticed that the are non id rpms available for 8.3, but we
> couldn't find any for 8.4 here:
> https://projects.commandprompt.com/public/pgcore

No idea if anyone is building RPMs for it.  The source and Win32
binaries are here:

	http://pgfoundry.org/frs/?group_id=1000235

> So, is the best option to compile postgres from source?  Is there
> anyway to change the storage of timestamps in our 8.3 db online (I am
> guessing no...)?

Nope.
(Continue reading)

Permalink | Reply | 8 comments |
headers
Mark Corner | 1 Feb 2010 17:24
Picon

Re: Using pg_migrator to upgrade 8.3->8.4

All good info...

With respect to RPMs, I was actually referring to postgres84 rpms with non-integer datetime prebuilt.

On Feb 1, 2010, at 11:12 AM, Bruce Momjian wrote:

> Mark Corner wrote:
>> We are looking to upgrade out 8.3 db to 8.4.  The full dump and
>> restore is not very attractive due to the downtime involved.
>> 
>> pg_migrator is an attractive option, but we have butted up again the
>> integer datetime timestamp problem:
>> 
>> "Old and new pg_controldata date/time storage types do not match.
>> 
>> You will need to rebuild the new server with configure
>> --disable-integer-datetimes or get server binaries built
>> with those options."
> 
> Yep, that is necessary.
> 
>> We also noticed that the are non id rpms available for 8.3, but we
>> couldn't find any for 8.4 here:
>> https://projects.commandprompt.com/public/pgcore
> 
> 
> No idea if anyone is building RPMs for it.  The source and Win32
> binaries are here:
> 
> 	http://pgfoundry.org/frs/?group_id=1000235
(Continue reading)

Permalink | Reply | 1 comment |
headers
Bruce Momjian | 1 Feb 2010 17:26
Picon
Favicon
Gravatar

Re: Using pg_migrator to upgrade 8.3->8.4

Mark Corner wrote:
> All good info...
> 
> With respect to RPMs, I was actually referring to postgres84
> rpms with non-integer datetime prebuilt.

Oh, I don't think anyone has made any of those, but I can see it
would be useful.

--
  Bruce Momjian  <bruce <at> momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Permalink | Reply | 0 comments |
headers
Devrim GÜNDÜZ | 1 Feb 2010 18:06

Re: Using pg_migrator to upgrade 8.3->8.4

Hi,

On Mon, 2010-02-01 at 11:02 -0500, Mark Corner wrote:

> We also noticed that the are non id rpms available for 8.3, but we
> couldn't find any for 8.4 here:
> https://projects.commandprompt.com/public/pgcore 

You can grab spec file, patches, etc from SVN repository, change

%{!?intdatetimes:%define intdatetimes 1}

to 

%{!?intdatetimes:%define intdatetimes 0}

and build packages on your server. I don't have any interest to push
non-id packages to repository, unless my boss specifically asks me to do
so ;)

Regards,
--

-- 
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com 
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
Permalink | Reply | 2 comments |
headers
Mark Corner | 1 Feb 2010 21:27
Picon

Re: Using pg_migrator to upgrade 8.3->8.4

Excuse by noobness, but where can I find the source RPMs for Centos?  I searched for a while without luck.

And which svn repository are you referring to?  I assume not the postgres CVS repo.

Thanks!
-Mark

On Feb 1, 2010, at 12:06 PM, Devrim GÜNDÜZ wrote:

> Hi,
> 
> On Mon, 2010-02-01 at 11:02 -0500, Mark Corner wrote:
> 
>> We also noticed that the are non id rpms available for 8.3, but we
>> couldn't find any for 8.4 here:
>> https://projects.commandprompt.com/public/pgcore 
> 
> You can grab spec file, patches, etc from SVN repository, change
> 
> %{!?intdatetimes:%define intdatetimes 1}
> 
> to 
> 
> %{!?intdatetimes:%define intdatetimes 0}
> 
> and build packages on your server. I don't have any interest to push
> non-id packages to repository, unless my boss specifically asks me to do
> so ;)
> 
> Regards,
(Continue reading)

Permalink | Reply | 1 comment |
headers
Devrim GÜNDÜZ | 1 Feb 2010 22:08

Re: Using pg_migrator to upgrade 8.3->8.4

On Mon, 2010-02-01 at 15:27 -0500, Mark Corner wrote:
> 
> Excuse by noobness, but where can I find the source RPMs for Centos?
> I searched for a while without luck.

http://yum.pgsqlrpms.org/srpms

> And which svn repository are you referring to?  I assume not the
> postgres CVS repo. 

https://projects.commandprompt.com/public/pgcore/repo/rpm/redhat/

Regards,
--

-- 
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com 
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
Permalink | Reply | 0 comments |
headers
Wang, Mary Y | 2 Feb 2010 07:41
Picon
Favicon

Pg_ctl with postmaster -i option

Hi,

How do configure the pg_ctl program so that when it starts postmaster it will start postmaster with the -i
option.   I want postmaster allows remote user to connect to the PostgreSQL server.

Thanks in advance
Mary

------------------------------------------------
Mary Y Wang

--

-- 
Sent via pgsql-admin mailing list (pgsql-admin <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Permalink | Reply | 4 comments |
headers
Renato Oliveira | 2 Feb 2010 09:36
Picon

Re: Pg_ctl with postmaster -i option

If I understood correctly what you want is to allow remote users or clients to connect to your postgresql server

I believe this is controlled by "pg_hba.conf"
Add a line similar to:
host    all         all         192.168.10.0/24       trust

Renato

Renato Oliveira
Systems Administrator
e-mail: renato.oliveira <at> grant.co.uk

Tel: +44 (0)1763 260811
Fax: +44 (0)1763 262410
http://www.grant.co.uk/

Grant Instruments (Cambridge) Ltd

Company registered in England, registration number 658133

Registered office address:
29 Station Road,
Shepreth,
CAMBS SG8 6GB
UK

-----Original Message-----

From: pgsql-admin-owner <at> postgresql.org [mailto:pgsql-admin-owner <at> postgresql.org] On Behalf Of
Wang, Mary Y
(Continue reading)

Permalink | Reply | 1 comment |
headers
Ian Lea | 2 Feb 2010 10:14
Picon

Re: Pg_ctl with postmaster -i option

From $ man postmaster

       -i     Allows remote clients to connect via  TCP/IP  (Internet  domain)
              connections.  Without  this  option,  only local connections are
              accepted. This option is equivalent to setting  listen_addresses
              to * in postgresql.conf or via -h.

              This  option is deprecated since it does not allow access to the
              full functionality of listen_addresses.  It's usually better  to
              set listen_addresses directly.

And you will need to set up pg_hba.conf as well, as Renato says.  But
maybe more restrictive.

--
Ian.

On Tue, Feb 2, 2010 at 8:36 AM, Renato Oliveira
<renato.oliveira <at> grant.co.uk> wrote:
> If I understood correctly what you want is to allow remote users or clients to connect to your postgresql server
>
> I believe this is controlled by "pg_hba.conf"
> Add a line similar to:
> host    all         all         192.168.10.0/24       trust
>
> Renato
>
>
>
>
(Continue reading)

Permalink | Reply | 0 comments |

Gmane