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 #31414 is a reply to message #30324] Fri, 21 April 2006 10:10 Go to previous messageGo to previous message
andyccn is currently offline  andyccn   United Kingdom
Messages: 14
Registered: February 2006
Location: UK
Karma:
Junior Member
FINALLY discovered the answer!!

PostgreSQL 8.1 installs, by default, have OID support turned off.
To turn it back on - find the line:

#default_with_oids = off

in the postgresql.conf file, and change it to:

default_with_oids = on

Then do "kill -HUP postmaster" to re-read your PostgreSQL configuration, THEN create your FUD database - and it installs fine and dandy!

Very Happy


--
Andy Shellam
the mail network - server support
[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 21:27:24 GMT 2024

Total time taken to generate the page: 0.05227 seconds