FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Installed OK - now SQL error
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Installed OK - now SQL error [message #32066 is a reply to message #30312] Tue, 06 June 2006 13:16 Go to previous messageGo to previous message
andyccn is currently offline  andyccn   United Kingdom
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

[Message index]
 
Read Message icon9.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message icon14.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Installation problems on Windows
Next Topic: v 2.7.7 Step 2: CREATE UNIQUE INDEX
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 23:34:32 GMT 2024

Total time taken to generate the page: 0.03815 seconds