Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

On Thu, 19 Jan 2006, Rodrigo Gonzalez wrote: Disable php on Apache if you dont use itLoadModule php4_module There are a couple of apps that require it, even though I don't use them often. Anywho, I'll just rebuild php --with-pgsql and make my own Slackware package with it. Thanks

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

Disable php on Apache if you dont use itLoadModule php4_module Rich Shepard wrote: On Thu, 19 Jan 2006, Joshua D. Drake wrote: If it is slackware I have no idea but on fedora it would be something like php-pgsql. Josh, I've searched the Slackware package repository and there i

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

On Thu, 19 Jan 2006, Joshua D. Drake wrote: If it is slackware I have no idea but on fedora it would be something like php-pgsql. Josh, I've searched the Slackware package repository and there is no php-pgsql. Patrick puts mysql.so in php, but not pgsql.so. If you are not using PHP then y

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

Sure enough. There is no pgsql.so on the system. I have php-4.4.1-i486-2 installed here; just upgraded from the -1 build. A Google search suggests that pgsql.so should be with either php or postgres; probably the former. If it is slackware I have no idea but on fedora it would be something

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

On Thu, 19 Jan 2006, Joshua D. Drake wrote: What does your apache error log say? I am guess that DBD::Pg can no longer find libpq and you need to recompile DBD::Pg. Josh, No, that's not quite right. I re-installed DBD::Pg and was told that it's up to date. Then I stopped and restarted ht

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

On Thu, 19 Jan 2006, Joshua D. Drake wrote: What does your apache error log say? I am guess that DBD::Pg can no longer find libpq and you need to recompile DBD::Pg. Joshua, Yup. That seems to be the case. I'll dig in my stored messages for how to re-install DBD::Pg. Thanks, Rich -- Richa

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

No more server conflicts. Whew! It seems that I have postgres properly -- and fully -- upgraded. However, I'm still getting a 500 server error from httpd when I try to log in to sql-ledger (http://localhost/sql-ledger/login.pl). What do I need to do to identify the reason? What does y

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

On Thu, 19 Jan 2006, Rich Shepard wrote: However, I'm still getting a 500 server error from httpd when I try to log in to sql-ledger (http://localhost/sql-ledger/login.pl). What do I need to do to identify the reason? I stopped and restarted httpd. No relief there. Rich -- Richard B. Shep

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

On Thu, 19 Jan 2006, Joshua D. Drake wrote: What happens when you psql -U postgres template1 ? Josh, OK. Now it's all straightened out on this side: [EMAIL PROTECTED]:/var/lib/pgsql$ psql -U postgres template1 Welcome to psql 8.1.2, the PostgreSQL interactive terminal. Type: \copyright f

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

On Thu, 19 Jan 2006, Rich Shepard wrote: I've attached the serverlog. Oops! Let me try this again. Rich -- Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental Applied Ecosystem Services, Inc. (TM) | Impact Assessments Using Fuzzy Logic"

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

On Thu, 19 Jan 2006, Tom Lane wrote: This looks like you are trying to use an 8.1 psql to talk to a 7.4 postmaster. Database "postgres" should exist by default in an 8.1 installation but it would not in 7.4. Better check which postmaster is really running. Tom, Yes. That seems to have been

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

Rich Shepard <[EMAIL PROTECTED]> writes: > psql -f /var/tmp/backup.sql > I see: > psql: FATAL: database "postgres" does not exist This looks like you are trying to use an 8.1 psql to talk to a 7.4 postmaster. Database "postgres" should exist by default in an 8.1 installation but it would not in

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

Rich Shepard wrote: On Thu, 19 Jan 2006, Doug McNaught wrote: Yes, as I said before, 'pg_dumpall' only produces SQL format dumps, which you restore using 'psql'. 'pg_restore' is only for binary dumps. Doug, I read the backup/restore web page to which you pointed me. I think that the new da

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

On Thu, 19 Jan 2006, Doug McNaught wrote: Yes, as I said before, 'pg_dumpall' only produces SQL format dumps, which you restore using 'psql'. 'pg_restore' is only for binary dumps. Doug, I read the backup/restore web page to which you pointed me. I think that the new database is not initiat

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

Rich Shepard <[EMAIL PROTECTED]> writes: >Using the 8.1.2 pg_dumpall from the 2004 data directory produces a 819K > file. But, when I then cd to the new data directory and run: > > [EMAIL PROTECTED]:/var/lib/pgsql/data$ pg_restore /var/tmp/backup.sql > pg_restore: [archiver] input file does no

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

On Thu, 19 Jan 2006, Joshua D. Drake wrote: What happens when you psql -U postgres template1 ? A-ha! Welcome to psql 8.1.2 (server 7.4.3), the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql command

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

On Thu, 19 Jan 2006, Doug McNaught wrote: pg_dumpall writes to standard output, so you should have seen an enormous spew of data at your terminal. I'm surprised you didn't. The manpages in the official Postgres documentation are quite clear about the behavior of these utilities; your book doesn'

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

On Thu, 19 Jan 2006, Doug McNaught wrote: Did you tell pg_restore to read from a file? Otherwise it will try to read from your terminal, which probably isn't what you want. Doug, Here's what I have in /var/lib/: drwxr-x--- 3 postgres postgres 104 2006-01-19 12:49 pgsql/ drwx-- 3 p

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

On Thu, 19 Jan 2006, Doug McNaught wrote: Did you tell pg_restore to read from a file? Otherwise it will try to read from your terminal, which probably isn't what you want. Doug, No, I didn't. I've no idea where the file was dumped, so I've no idea of the name or location. Reading in Dougl

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

On Thu, 19 Jan 2006, Doug McNaught wrote: Furthermore, whenever you use pg_dump or pg_dumpall, you need to redirect it to a file: $ pg_dumpall > /var/tmp/backup.sql I was just about to try this; it seemed the way to go. I highly suggest you read: http://www.postgresql.org/docs/8.1/static/

[GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

It's time for me to stop procrastinating and upgrade postgres from -7.4.3 to -8.1.2. Unfortunately, I think that I got it wrong. Here's what I did on my Slackware-10.2 box: 1) cd to /usr/local/pgsql 2) su'd to postgres 3) ran 'pg_dumpall' 4) as root, ran 'upgradepkg slackware-8.1.2*.tgz

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

Rich Shepard <[EMAIL PROTECTED]> writes: >Well, so much for the book. It did seem to be rather sparse on the upgrade. > Hmmm-m-m. Wonder what is the most efficient way to get going again. Think > I'll try the 'pg_dumpall -format=c' from the old directory and see if there's > a new file there.

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

Rich Shepard <[EMAIL PROTECTED]> writes: > On Thu, 19 Jan 2006, Doug McNaught wrote: > >> Did you tell pg_restore to read from a file? Otherwise it will try to read >> from your terminal, which probably isn't what you want. > > Doug, > >No, I didn't. I've no idea where the file was dumped, so

Re: [GENERAL] Upgrade Problem: 7.4.3 -> 8.1.2

Rich Shepard <[EMAIL PROTECTED]> writes: >7) back to /usr/local/pgsql; as postgres ran 'pg_restore' >8) I see nothing in the virtual terminal. The cursor sits on the following > line. Did you tell pg_restore to read from a file? Otherwise it will try to read from your terminal, which pro