[GENERAL] Building with MinGW issue
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 can I fix this issue? P.S. I use the following options for configuring call: $ ./configure --without-zlib --with-openssl --with-includes=C:/OpenSSL-Win32/include --with-libraries=C:/OpenSSL-Win32/lib /MinGW -- Best Regards, Muhammad Bashir Al-Noimi -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Partitioning V schema
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 partitioning off blocks of related datasets > completely. I would do a partition in this case for the same reason: schemas are much more logical divisions of data due to different grantings, search paths, users, and so on. Partition is more a data-level split so it does make sense when you want the data to stay in a single point but for performance reason split it across multiple tables. Luca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Number of WAL segment
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_completion_target) * checkpoint_segments + 1 http://www.postgresql.org/docs/8.3/static/wal-configuration.html Note that this is a soft limit, there could be more than 3 * checkpoint_segments + 1 for a short period. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Number of WAL segment
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 segments in > pg_xlog for at least 3h. It is not possible to keep WAL files in pg_xlog in 8.3 for such a duration as checkpoint_timeout would kick a checkpoint at least every hour even if you'd set it to its maximum value which is 1 hour. So the solution to keep 3 hours of WAL files in this case is simply to use an archive, and to delete periodically old files no longer needed based on your needs. Note that you could use wal_keep_segments with a server >= 9.1 to do that. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Re: [GENERAL] pg_upgrade unrecognized configuration parameter “unix_socket_directory”
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 the log: > > command: "/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D > "/var/lib/pgsql/data" -o "-p 50432 -b -c listen_addresses='' -c > unix_socket_permissions=0700 -c unix_socket_directory='/var/lib/pgsql'" > start >> "pg_upgrade_server.log" 2>&1 > waiting for server to startFATAL: unrecognized configuration parameter > "unix_socket_directory" > stopped waiting > pg_ctl: could not start server > > That parameter was replaced by unix_socket_directories (plural) in 9.3. But > the server version being started is 9.2: > > $ /bin/pg_ctl --version > pg_ctl (PostgreSQL) 9.2.4 > > What am I missing? Are you sure that the version of pg_upgrade you are using is from 9.3 and not 9.2? You should always use pg_upgrade from the new server version. By looking at contrib/pg_upgrade/server.c in 9.3 code, the code takes into account unix_socket_directories that has been renamed in 9.3: /* Have a sockdir? Tell the postmaster. */ if (cluster->sockdir) snprintf(socket_string + strlen(socket_string), sizeof(socket_string) - strlen(socket_string), " -c %s='%s'", (GET_MAJOR_VERSION(cluster->major_version) < 903) ? "unix_socket_directory" : "unix_socket_directories", cluster->sockdir); So no problem on this side. Regards, -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Building with MinGW issue
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 configure: error: header file is required for OpenSSL How can I fix this issue? Is openssl/ssh.h actually in the includes directory specified below? P.S. I use the following options for configuring call: $ ./configure --without-zlib --with-openssl --with-includes=C:/OpenSSL-Win32/include --with-libraries=C:/OpenSSL-Win32/lib /MinGW -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Building with MinGW issue
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 changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Building with MinGW issue
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 are more capable in that area. Also bottom posting is encouraged, it helps maintain the flow better. The only question I have left at this time is: What is the directory structure under C:/OpenSSL-Win32/include? -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
