473,325 Members | 2,816 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

7.4 -> 7.4.1 upgrade with customization on freebsd


I installed 7.4 from the FreeBSD ports collection (I'm running 4.9-RELEASE).
Did nothing special, just make && make install and all was well.

I now have updated my ports collection via cvsup and see that the 7.4.1 port
is available. So now I have several, very specific needs:

1) having now done some development in 7.4, I've decided I need to be able
to exceed the default limit of 16 arguments for plpgsql functions

2) I would like to upgrade to 7.4.1 without having to re-edit any config
files or change any paths.

3) I would like to prevent the database shown by "pkg_version -v" from
having one entry for 7.4 and another for 7.4.1

Suggestions? Caveat: I'm a java + sql centered coder and makefiles make me
wince.
Bill McMilleon
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 22 '05 #1
8 1565
Hello,

Well... 7.4 to 7.4.1 is a direct upgrade. You do not have to do a
reinitdb which means you do
not have to reconfigure the system. I can't help you with your BSD
specific issues (I don't know much about it)
but from the PostgreSQL perspective, you should be abble to just upgrade.

One note would be to backup your data/ directory, and then remove
postgresql in whichever manner
BSD does. Then install 7.4.1, and restore your data directory.

Any people using BSD want to help on this one a little?

Sincerely,

Joshua D. Drake

bi*******************@mcmilleon.com wrote:
I installed 7.4 from the FreeBSD ports collection (I'm running 4.9-RELEASE).
Did nothing special, just make && make install and all was well.

I now have updated my ports collection via cvsup and see that the 7.4.1 port
is available. So now I have several, very specific needs:

1) having now done some development in 7.4, I've decided I need to be able
to exceed the default limit of 16 arguments for plpgsql functions

2) I would like to upgrade to 7.4.1 without having to re-edit any config
files or change any paths.

3) I would like to prevent the database shown by "pkg_version -v" from
having one entry for 7.4 and another for 7.4.1

Suggestions? Caveat: I'm a java + sql centered coder and makefiles make me
wince.
Bill McMilleon
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 22 '05 #2
On Fri, 16 Jan 2004 bi*******************@mcmilleon.com wrote:

I installed 7.4 from the FreeBSD ports collection (I'm running 4.9-RELEASE).
Did nothing special, just make && make install and all was well.

I now have updated my ports collection via cvsup and see that the 7.4.1 port
is available. So now I have several, very specific needs:

1) having now done some development in 7.4, I've decided I need to be able
to exceed the default limit of 16 arguments for plpgsql functions
Then you will have to recompile the server, as well as dump / initdb /
restore it.
2) I would like to upgrade to 7.4.1 without having to re-edit any config
files or change any paths.
Just backup the config files in $PGDATA to another directory, and toss
them back into $PGDATA after the initdb
3) I would like to prevent the database shown by "pkg_version -v" from
having one entry for 7.4 and another for 7.4.1


Not a clue here, I'm not a debian user.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 22 '05 #3
On Sat, 17 Jan 2004, Joshua D. Drake wrote:
Hello,

Well... 7.4 to 7.4.1 is a direct upgrade. You do not have to do a
reinitdb which means you do


You may have missed where bill said he wanted to change a default limit
for plpgsql function args from 16 to something else. that will require a
reinitdb...

And Bill, in my other reply, I meant to say I'm not a BSD user, not that I
wasn't a debian user. My brain hurts... :-)
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 22 '05 #4
En un mensaje anterior, scott.marlowe escribió:
2) I would like to upgrade to 7.4.1 without having to re-edit any config
files or change any paths.


Just backup the config files in $PGDATA to another directory, and toss
them back into $PGDATA after the initdb
3) I would like to prevent the database shown by "pkg_version -v" from
having one entry for 7.4 and another for 7.4.1


As Scott said, backup /usr/local/pgsql/data, pkg_delete the old version, make &&
make install the new one and the restore your old data directory. For package
upgrades, take a look at sysutil/portupgrade (you still need to backup the data
dir).

Good luck.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 22 '05 #5
En un mensaje anterior, scott.marlowe escribió:
On Sat, 17 Jan 2004, Joshua D. Drake wrote:
Hello,

Well... 7.4 to 7.4.1 is a direct upgrade. You do not have to do a
reinitdb which means you do


You may have missed where bill said he wanted to change a default limit
for plpgsql function args from 16 to something else. that will require a
reinitdb...


I missed that too. Instead of backing up the data directory, pg_dump and backup
the *.conf files. After the port upgrade, initdb, the replace the *.conf files
with the backuped up versions and pg_restore your DB.

Regards.

Fernando.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 22 '05 #6
> On Fri, 16 Jan 2004 bi*******************@mcmilleon.com wrote:

[snip]
1) having now done some development in 7.4, I've decided I need to be

able to exceed the default limit of 16 arguments for plpgsql functions

Then you will have to recompile the server, as well as dump / initdb /
restore it.


Where can I go to get guidance on exactly how to do this. It would be ideal
to be able to simply change my typical ports command of:

make && make install

....into...

make --max-args-option=32 && make install

but I doubt it will be that simple. And, at this point, I have no idea what
that make option would be. I'd like to try building this from ports if at
all possible. I could fall back to download source and run ./configure,
etc. but prefer not to.

Thanks everyone for your help so far.

Bill McMilleon


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 22 '05 #7

--- bi*******************@mcmilleon.com wrote:
On Fri, 16 Jan 2004

bi*******************@mcmilleon.com wrote:

[snip]
1) having now done some development in 7.4, I've

decided I need to be
able to exceed the default limit of 16 arguments

for plpgsql functions

Then you will have to recompile the server, as

well as dump / initdb /
restore it.


Where can I go to get guidance on exactly how to do
this. It would be ideal
to be able to simply change my typical ports command
of:

make && make install

...into...

make --max-args-option=32 && make install

but I doubt it will be that simple. And, at this
point, I have no idea what
that make option would be. I'd like to try building
this from ports if at
all possible. I could fall back to download source
and run ./configure,
etc. but prefer not to.

Thanks everyone for your help so far.


You will need to start over. You can preserve your
data by either of the two previously suggested
methods, i.e. pg_dumpall, or copy the $PGDATA
directory off to the side, then restore it later.

Remove the port with pkg_delete or whatever the
correct command on FreeBSD is these days (haven't done
it for a while). Do a "make fetch" to get your 7.4.1
source.

In your port directory you should now have a "work"
directory, under which will be the Postgres source,
starting at the "src" directory. Go to the file
src/include/pg_config.h, and change the settings for
FUNC_MAX_ARGS and INDEX_MAX_KEYS to 32 (they have to
have the same value).

Next "make install", restore your data, and you should
be good. Note that I am pulling this from the list
archives and have never done this myself (and working
from memory a good bit besides), so caveat emptor.

__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 22 '05 #8
Jeff Eckermann <je************@yahoo.com> writes:
--- bi*******************@mcmilleon.com wrote:
1) having now done some development in 7.4, I've
decided I need to be
able to exceed the default limit of 16 arguments
for plpgsql functions

Bill, you do realize that the default limit is not 16? It's been 32
for a good while ...
You will need to start over. You can preserve your
data by either of the two previously suggested
methods, i.e. pg_dumpall, or copy the $PGDATA
directory off to the side, then restore it later.


He had better pg_dumpall, because the modified server won't be able to
use the old $PGDATA tree.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 22 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

35
by: Will Stuyvesant | last post by:
Here is a question about list comprehensions . The question is dumb because I can do without ; but I am posing the question because I am curious. This: >>> data = ,,] >>> result = >>> for...
0
by: sanjay gupta | last post by:
Dear All, I want to upgrade my mysql ver 3.20.32a-3 on my Red Hat linux 6.2 machine to mysql 3.23 version. Presently i have glib-1.2.6-3 and libc-5.3.12-3.1. How can i upgrade to version 3.23....
4
by: Mattbooty | last post by:
I'm beginning to think this isn't doable within VB.NET Deployment projects, but I wanted to ask before I went and spent the money on a seperate installer. I have a program that runs off of an...
4
by: Ksenia Marasanova | last post by:
Hi, I have python2.3, installed from port /lang/python long time ago. The current version is 2.4, but I'd rather have two python versions, instead of upgrading. Is there maybe a way to somehow...
1
by: Robert Fitzpatrick | last post by:
I get this error after doing the upgrade on FreeBSD 5.2.1: The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.2 Should I just re-initdb...
0
by: Bill Moran | last post by:
I'm having some problems. Hopefully there are some FreeBSD folks here that can help me out, if not, I'll try the FreeBSD lists next. I'm running Postgres 7.4 installed from a just cvsupped...
3
drhowarddrfine
by: drhowarddrfine | last post by:
FreeBSD will be upgrading soon to 7.0. This includes upgraded, strong support for multiprocessing, among many other things. Here is a preview in a .pdf for those interested.
2
by: Ruslan A Dautkhanov | last post by:
Hello ! I'm about to install O9i on FreeBSD box. uname -a: FreeBSD stat2.scn.ru 5.2.1-RELEASE-p3 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23 19:19:43 KRAST 2004...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.