So it looks like the user needed to be the postgres DB user, not the wiki user. That got me to problem #2 running dumpBackup.php...
From the backtrace...
C:\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki \maintenance>........\php\php.exe dumpBackup.php --logs PHP Warning: pg_query(): Query failed: ERROR: relation "revision" does not exist LINE 1: ...LECT /* BackupDumper::dump */ MAX(rev_id) FROM revision ... ^ in C: \Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki\includes\db \DatabasePost gres.php on line 580 A database error has occurred Query: SELECT MAX(rev_id) FROM revision LIMIT 1 Function: BackupDumper::dump Error: 1 ERROR: relation "revision" does not exist LINE 1: ...LECT /* BackupDumper::dump */ MAX(rev_id) FROM revision ... ^
Backtrace: #0 C:\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki\includes \db\Database.php(616): DatabasePostgres->reportQueryError('ERROR: relatio...', 1, 'SELECT MAX(rev...', 'BackupDumper::d...', false) #1 C:\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki\includes \db\Database.php(1026): Database->query('SELECT MAX(rev...', 'BackupDumper::d. ..') #2 C:\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki\includes \db\Database.php(943): Database->select('revision', 'MAX(rev_id)', '', 'BackupD umper::d...', Array) #3 C:\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki \maintenance\backup.inc(231): Database->selectField('revision', 'MAX (rev_id)', '', 'Back upDumper::d...') #4 C:\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki \maintenance\backup.inc(184): BackupDumper->initProgress(8) #5 C:\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki \maintenance\dumpBackup.php(69): BackupDumper->dump(8) #6 {main}
Any pointers to resolving. It appears the first few tables have _revid fields. Thx
On Dec 16, 2:29 am, Mike mikelisa...@gmail.com wrote:
I did not make any PHP configuration changes from the Bitnami WAPP stack. I looked at the PHP configuration which loads php_pgsql.dll, but didn't see separate configurations for CLI and CGI you ask about. I'm not certain how I tell if the pgsql mod is being loaded for a CLI usage, except to say the reported error message appears to indicate an attempt to make a DB connection. Somebody else seamed to indicate the user/password for this function was that of the postgres server and not the wiki user. Was that the right track?
On Dec 16, 1:11 am, Q overlo...@gmail.com wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256
Mike wrote:
I'm new to MediaWiki and tried the dumpBackup.php on a WAPP stack install. I've set AdminSettings.php user and password to match those in LocalSettings.php as described in the manual. I receive the following error when executing the script:
DB connection error: Postgres functions missing, have you compiled PHP with the --with-pgsql option?
MediaWiki was installed with compiling and source; strictly dropping its source php and running the install scripts from html.
Is this a well-known installation error? The MediaWiki is operating as expected from the html server.
Thanks for any pointers.
Does your PHP install have separate configs for CLI and CGI? Is the pgsql module being loaded for both? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla -http://enigmail.mozdev.org/
iEYEAREIAAYFAksoefkACgkQ69PBoSWyJd7+GgCbBe85n5FBFuH7/3YV1niS9dUY X6MAnisI+4bt0wnPuXEKMS4vZ5dOKhN3 =g8ZG -----END PGP SIGNATURE-----
MediaWiki-l mailing list MediaWik...@lists.wikimedia.orghttps://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWik...@lists.wikimedia.orghttps://lists.wikimedia.org/mailman/listinfo/mediawiki-l