[SQL] HowTo change encoding type....

[Andrew M]

Hi,
how do I change the encoding type in postgreSQL (8) from UTF-8 to ISO-8859-1?


many thanks


Andrew
<>
 +The home of urban music
+ http://www.beyarecords.com

---(end of broadcast)---
TIP 8: explain analyze is your friend

[SQL] Failed system call was shmget(key=1, size=1155072, 03600).

[Andrew M]

Hi,
when building postgreSQL 8 I get the following error message:
DETAIL:  Failed system call was shmget(key=1, size=1155072, 03600).
HINT:  This error usually means that PostgreSQL's request for a shared 
memory segment exceeded available memory or swap space. To reduce the 
request size (currently 1155072 bytes), reduce PostgreSQL's 
shared_buffers parameter (currently 50) and/or its max_connections 
parameter (currently 10)

What is the best way to resolve this? max_connections = 10? Does that 
figure auto increase as more users request data?

regards
Andrew
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]