[GENERAL] Postgres 9.5 and windows and desktop heap?

Hi, Does Postgresql 9.5 still have the same limitations with the desktop heap under windows? Thanks H.F. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] comparison between Postgresql and Microsoft SQL Server

Hi, I know there is a manual but it is quite a large and heavy document. Does anyone know of a document that compares and shows the differences between SQL Server and Postgres? That will be a substantial shortcut for me. Thanks H.F. -- Sent via pgsql-general mailing list (pgsql-general@postgr

[GENERAL] workarounds for ci_text

Hi, As far as I can tell, you can't restrict the length of a ci_text field like char(5) or varchar(5)? Let's say you got a stock table and you want an alphanumeric stock code that is the primary key but it must be case insensitive can I do something like this: create table stock(stock code varcha

[GENERAL] troubleshooting Postgresql on Windows

Hi I recently read some of your windows docs on the wiki. They mentioned that some people experience problems with Postgresql and firewalls and/or anti-virus programs on windows. I know that a software firewall is usually not a problem. I have used a couple of different software firewalls at diffe

[GENERAL] newbie question

Hi Does Postgresql utilize hyperthreading and multiple cores on the relevant processors on windows? Thanks H.F.

[GENERAL] windows vista and windows 7

Hi Does Postgres run on the Starter Edition of Windows Vista and Windows 7? Thanks H.F.

[GENERAL] case sensitivity?

Hi I posted a similar question before. I was told that Postgres is always case sensitive. I was actually referring to text data not identifiers. I mean char and varchar fields. I basicically want to avoid using upper in comparisons. With some databases you can use a utf8 characterset and a unicode

[GENERAL] citext question

Hi I have played around a bit with the citext extention. It looks like it is a lot like the text data type - allmost like a memo field. Is there any way to restrict the length of citext fields, like char and varchar fields? Thanks H.F.

[GENERAL] database corruption questions

Hi Are there any best practices for avoiding database corruption? I suppose the most obvious one is to have a ups if it's a desktop machine. How do you detect corruption in a Postgresql database and are there any ways to fix it besides restoring a backup? Thanks H.F.

[GENERAL] Postgresql on Windows 8

Hi Do you have any plans to put the Windows version of Postgresql on the Windows 8 app store? Also for PGAdmin and database drivers? Aparantly there are major issues with sideloading in windows 8. Thanks H.F.

[GENERAL] downgrading a database

Hi Is it possible to downgrade a Postgresql database from a newer to an older version? If so how do you do it? Let's assume you are not using any features in the newer version. Say from 9.2 to 9.1. Thanks H.F.

[GENERAL] Postgresql 9.0 and desktop heap and Windows

Hi Does Postgresql 9.0 still have the problem with the desktop heap on windows? I know you can extend the desktop heap on windows but Microsoft says on their web site you musn't extend it beyond 20K. That allows for about 300 connections on a windows server. I see there is now also a 64 bit window

[GENERAL] windows 7 compatiblity?

Hi I recently bought Windows 7 32 bit professional. Unfortunately Postgresql 8.4.3 did not install or work. I started searching Google and found that a lot of other people have the same problem. Will there be a minor release to fix the problem? Will it be fixed in the upcoming version 9.0? Thanks

[GENERAL] desktop heap usage in windows

Hi In the latest release 8.4.3 is the desktop heap still a problem in Windows? I found some articles on the web that said on Windows xp the desktop heap is rather small. Apparantly under xp it's limited to 45 connections. They also said that the desktop heap is larger on windows servers and that g

[GENERAL] can't connect to server on localhost

Hi Last night i mailed a message about me not being able to install Postgresql 8.4.3 successfully on windows 7 professional. I have since temporary quitted my antivirus and firewall programs and I could install successfull. In the installation it askes you for a password which it uses for for the

[GENERAL] Postgres 9.0 and desktop heap usage in windows

Hi Will desktop heap usage in windows still be a problem in the upcoming 9.0 release? H.F.

[GENERAL] can't connect to server on localhost - solved

Hi I have been experimenting with Postgresql on windows since version 8.3. However I never read much documentation. Previously I was always using Windows XP Prof. with older versions of Kaspersky Internet Security. Recently I bought Windows 7 Prof. 32 bit and also the 2010 version of Kaspersky. I

[GENERAL] can't find data type CIText or CI_Text

Hi I was told by someone that in order to store text that isn't case sensitive in comparisons I must use CIText or CI_Text. I can't find the data type? Also is this char or varchar data type? Can you create an index on this data type? Thanks H.F.

[GENERAL] how to make text fields accent insensitive?

Hi Recently you answered my question on how to make a field case insensitive. You showed me how to do it with the extension and data type citext. How do I make the same field accent insensitive as well? I managed to install the extension "unaccent" in Postgres 9.1.2 using create extension. Unfort

[GENERAL] 2 very newbie questions

Hi The Postgresql manual is rather huge so I would appreciate it if you could help me with the following 2 questions: What is an oid when creating tables and what is the purpose of it? What is a toast table? Thanks H.F.

[GENERAL] schema question

Hi I saw with PGAdmin that there is a public schema in the default postgres database. Does every database have a public schema? What is a schema and can you create your own? Thanks H.F.

[GENERAL] Postgresql logging questions

Hi I am still a big newbie as far as Postgresql is concerned. I got some questions about logging. Most RDBMS's log all sql changes. When the server crashes or a power failure occurs and the server comes back up the rdbms rolls back to the nearest checkpoint and does a roll forward from the log.

[GENERAL] running multiple versions

Hi Is it possible to run more than one instance of Postgresql on Windows? Can you run different versions simultaneously? If so can you run different minor versions or only different major versions? If possible how do you do this? Thanks H.F.

[GENERAL] converting older databases

Hi When you install a newer version of Postgres how do you upgrade your database to the new format? Apparantly you can't just backup the old database and restore it on the new software. How do you do this on Windows? Thanks H.F.