| Re: Installed OK - now SQL error [message #32066 is a reply to message #30312] |
Tue, 06 June 2006 13:16   |
andyccn
Messages: 14
Registered: February 2006
Location: UK
Karma:
|
Junior Member |
|
|
I think this is the same problem I had - if your admin has installed PostgreSQL for you, it's doubtful they'll have modified your config file.
VPSs normally have root access. Login as root (using PuTTY or similar SSH-tools.)
Type the command "find / -name postgresql.conf"
You'll get a path like /usr/local/etc/postgresql.conf or similar shown.
Type "vi <path>" (e.g. "vi /usr/local/etc/postgresql.conf".
Use PgDown to get to the bottom of the file where you'll find a line "#default_with_oids = off" (somewhere in the file.)
Press INSERT.
Remove the hash and change off to on, so it reads "default_with_oids = on"
Then press ESC, type ":w" <ENTER> followed by ":q" <ENTER>
Type "killall -HUP postmaster" to reload the postgresql config.
Then type "logout" and press enter.
Drop your FUD database, recreate it and re-install.
You should be OK then. Or if you're uneasy about this, send these details to your admin and kindly ask if he'll modify the PostgreSQL config for you.
--
Andy Shellam
the mail network - server support
[Updated on: Wed, 07 June 2006 06:31] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]