SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 01:00 PM
| ||||
| ||||
 admin82.sql I just removed 8.1.5 and installed 8.2.0 on a freeBSD server. I cannot seem to find where it placed admin82.sql, if in fact such a beast should have been created with the initdb step. Any ideas? Google has zero indexed documents with admin82.sql in it's engine, and of course all the instumentation documentation says run admin81.sql for 8.1.X psql...  -- Walter ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster      |
|
04-09-2008, 01:00 PM
| |||
| |||
| Re: admin82.sql Walter Vaughan wrote: > I just removed 8.1.5 and installed 8.2.0 on a freeBSD server. I cannot seem > to find where it placed admin82.sql, if in fact such a beast should have > been created with the initdb step. I believe said admin81.sql corresponds to functions that were included into 8.2, and that the rest of the stuff is in a contrib module aptly named "adminpack". -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
|
04-09-2008, 01:01 PM
| ||||
| ||||
| Re: admin82.sql FreeBSD specific Alvaro Herrera wrote: > Walter Vaughan wrote: >>I just removed 8.1.5 and installed 8.2.0 on a freeBSD server. I cannot seem >>to find where it placed admin82.sql, if in fact such a beast should have >>been created with the initdb step. > I believe said admin81.sql corresponds to functions that were included > into 8.2, and that the rest of the stuff is in a contrib module aptly > named "adminpack". Okay for those behind me, the next step after installing 8.2 is # cd /usr/ports/databases/postgresql-contrib && make install clean ....which puts the README's in /usr/local/share/doc/postgresql/contrib ....and the stuff in /usr/local/share/postgresql/contrib which in the case of freebsd is the location of both adminpack.sql and uninstall_adminpack.sql. The README.adminpack has slightly misleading info (at least for me) $ psql -U pgsql postgres < adminpack.sql may be more correct for you instead of "-U postgres" which is not the user created by the ports collection. However now instead of a connecting instantly, it takes almost a minute to have a connect using pgAdmin 1.6.1 on my windows box to the freeBSD server when connecting. But I don't get the nag screen about missing functionality.  Argh. Can't it be fast and accurate? -- Walter ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
Linear Mode
