Re: [GENERAL] Building with MinGW issue

2013-09-21 Thread Adrian Klaver
On 09/21/2013 07:45 AM, Muhammad Bashir Al-Noimi wrote: Yes,I build using mingw/msys under Windows with administrator permission Please reply to list also. Building software on Windows is not one of my strong points, so keeping this conversation on the list will put it front of people who ar

Re: [GENERAL] Building with MinGW issue

2013-09-21 Thread Adrian Klaver
On 09/21/2013 07:30 AM, Muhammad Bashir Al-Noimi wrote: Yes. So does the user you are running configure as have the necessary permissions to access the directory/file? -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Building with MinGW issue

2013-09-21 Thread Adrian Klaver
On 09/21/2013 12:08 AM, Muhammad Bashir Al-Noimi wrote: Howdy, I want to build Postgresql 9.1 under Windows with MinGW but I get this error message whever I configure the project: checking openssl/ssl.h usability... no checking openssl/ssl.h presence... no checking for openssl/ssl.h... no confi

[GENERAL] Re: [GENERAL] pg_upgrade unrecognized configuration parameter “unix_socket_directory”

2013-09-21 Thread Michael Paquier
On Wed, Sep 18, 2013 at 11:35 AM, Clodoaldo Neto wrote: > I'm trying to upgrade Postgresql from 9.2 to 9.3 in Fedora 18 using this > command as the postgres user > > $ pg_upgrade -b /bin -B /usr/pgsql-9.3/bin -d /var/lib/pgsql/data -D > /var/lib/pgsql/9.3/data/ -j 2 -u postgres > > The error in th

Re: [GENERAL] Number of WAL segment

2013-09-21 Thread Michael Paquier
On Tue, Sep 17, 2013 at 9:46 PM, tdev457 wrote: > Hi, > I am using PostgreSQL 8.3.8!!! > How can I increase number of WAL segments in pg_xlog??? > Current settings are: > checkpoint_segments=10 > checkpoint_completion_target=0.5 > > WAL segments are generated every 10 min and I want to keep WAL se

Re: [GENERAL] Number of WAL segment

2013-09-21 Thread Michael Paquier
On Tue, Sep 17, 2013 at 2:35 PM, tdev457 wrote: > Thanks, > I am confused now.When checkpoint_segment is set to 3 there are 7 WAL > segments in pg_xlog.When I set checkpoint_segments to 10 there are 11 WAL > segments. The maximum number of WAL files is defined by this formula: (2 + checkpoint_comp

Re: [GENERAL] Partitioning V schema

2013-09-21 Thread Luca Ferrari
On Fri, Sep 20, 2013 at 4:38 AM, Julian wrote: > However, I tend to go with partitions when required to be generated on > demand dynamically and automatically (which probably isn't the case > here). SCHEMAs have other uses, provide a level of security (GRANT) and > useful in design when partitioni

[GENERAL] Building with MinGW issue

2013-09-21 Thread Muhammad Bashir Al-Noimi
Howdy, I want to build Postgresql 9.1 under Windows with MinGW but I get this error message whever I configure the project: checking openssl/ssl.h usability... no checking openssl/ssl.h presence... no checking for openssl/ssl.h... no configure: error: header file is required for OpenSSL How