On 03/28/2014 07:02 PM, Tom Lane wrote:
> I wrote:
>> Honza writes:
>>> after a months I've found a time to make test-case for this bug, probably:
>
>> Confirmed that this reproduces a problem on HEAD. Will look into it,
>> thanks!
>
> I believe I u
Hi,
after a months I've found a time to make test-case for this bug, probably:
I've got my custom type and a table stores historical data of the main table.
The problem occurs at our production servers, version 9.2.6. We've found it
after our backups wasn't
complete because of selection from "c
don't forget your laptop.
See the links for details:
G+ hackfest event:
https://plus.google.com/u/0/events/cqb5364p4377vd8lp6gvmqqtk6c
DevConf web:
http://www.devconf.cz/
DevConf schedule:
http://developerconference2013.sched.org/
Contact person:
Honza Horak (hho...@redhat.com)
Feel fre
On 07/02/2012 09:45 PM, Tom Lane wrote:
Honza Horak writes:
On 06/15/2012 05:40 PM, Honza Horak wrote:
I realized the patch has some difficulties -- namely the socket path in the
data dir lock file, which currently uses one port for socket and the same for
interface. So to allow users to
On 06/15/2012 05:40 PM, Honza Horak wrote:
I realized the patch has some difficulties -- namely the socket path in the
data dir lock file, which currently uses one port for socket and the same for
interface. So to allow users to use arbitrary port for all unix sockets, we'd
need t
> On 06/13/2012 03:25 PM, Honza Horak wrote:
> A draft patch is attached. It renames unix_socket_directory to
> unix_socket_directories and allows to use directory:port to be able
> to
> create more sockets in one directory with different port number in
> the
> socket name.
On 06/13/2012 03:25 PM, Honza Horak wrote:
Going through the thread, I'd like to sum it up choosing approach with
less potential issues and would like to find a consensus if possible.
It seems unix_socket_directory could be turned into list and probably
renamed to unix_socket_directories,
configuration option, so it seems better to add a new configuration
option to distinguish the primary listening port from additional ports.
Regards,
Honza
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ted with
simply patching pg_config_manual.h, same as Debian does it already? For
example, is there any piece of software, that simply rely on /tmp
location of the socket and doesn't use libpg for the communication?
Regards,
Honza
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresq
kets of various postmasters in the same
directory. In that scenario every client should know which port to
connect and also which one is primary.
Regards,
Honza
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
Going back to the original problem (inaccessible /tmp directory), it is
the case (2) -- a client uses the default path. So any additional
client-side socket option won't probably help here, but we would
probably need a second hard-coded path e.g. at /var/run/postgresql.
Regards,
Honza
On 06/06/2012 04:50 PM, Andres Freund wrote:
On Wednesday, June 06, 2012 04:38:42 PM Tom Lane wrote:
Florian Pflug writes:
If we're going to have this at all, we should go all the way and
support an arbitrary number of sockets.
Well, that's what I wanted to discuss before Ho
it's enough to have the location
hard-coded? What are your opinions?
Regards,
Honza
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
ED]>
ftp://ftp2.zf.jcu.cz/users/zakkr/pg/
--
----
Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/
.project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ...
Only self-confident people can be si
exception you
get, _continuing_ with your transaction. This way, large part of the
application logic is shifted to the server and to the database schema.
The client just tries if the command will run OK.
--
----
Honza Pazdziora |
, do update of the existing record
It should be upto the application to decide if the failed insert
should lead to abortion of the transaction, or if it should be
silently ignored and based on the return value of the insert proceed
with update.
--
---
or OTHERS.
--
----
Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/
.project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ...
Only self-confident people can be simple.
---(end of
mpt.
Will the version information in log break anything?
--
----
Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/
.project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ...
pecifying datadirectory in the configuration file, or even defaulting
to the same directory where the .conf file is stored when no
datadirectory option is used.
--
----
Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/
ewhere else and in it the location of
the data directory is specified. It does not mandate there will only
be one cluster and it does not mean that each cluster cannot have
completely different configuration file.
--
----
Honza
ion instructions can be found
at
http://www.fi.muni.cz/~adelton/l10n/
--
----
Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/
.project: Perl, mod_perl, DBI, Oracle, large Web s
each and every setting in
:-) I never used that "feature" so was never bitten by it. Anyway,
Apache HTTP server seems to do it the right way, doesn't it?
--
----
Honza Pazdziora | [EMAIL PROTECTED] | http://w
f configuration, or separate them in any way.
--
----
Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/
.project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ...
Only self-confident people can be simple.
---(end of
shouldn't it make elementary checks
(upon startup, perhaps) that the current locale settings and the
current locale version produces results compatible with the existing
indexes? And if it does not, reindex?
--
----
Honza P
distribution.
I'd appreciate comments about the viability of the goal, name,
and / or solution presented.
Yours,
--
----
Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/
.project: Perl, mod_perl, DBI,
25 matches
Mail list logo