; question when receiving an error after sending a
multi-statement query string that contains a COMMIT in it?
Thank you very much,
- Andrei
ansfer all data from A into B.
Can I daisy-chain streaming replication? In other words, temporarily
setup replication like this:
A ==> B ==> C
And after the transfer is done, just remove A from the scheme.
--
Florin Andrei
http://florin.myip.org/
--
Sent via pgsql-general mailing lis
Nevermind, this was fixed with:
ssl_renegotiation_limit = 0
--
Florin Andrei
http://florin.myip.org/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
his in the logs:
###
2015-11-03 21:45:31.885 UTC,,,3391,,56391e57.d3f,19,,2015-11-03 20:51:35
UTC,,0,LOG,0,"checkpoint starting: xlog",""
2015-11-03 21:45:35.400 UTC,,,4773,,56392a26.12a5,1,,2015-11-03 21:41:58
UT
amd64development files for PostgreSQL-BDR 9.4 server-side
programming
ii postgresql-client-common 169.pgdg14.04+1
all manager for multiple PostgreSQL client versions
ii postgresql-common169.pgdg14.04+1
all PostgreSQL database-cluster manager
--
Florin Andrei
http://florin.myip.org/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
er rebuilding it from
scratch, under the old name?
Do I have to change the name every time I re-join a node?
--
Florin Andrei
http://florin.myip.org/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
http://packages.2ndquadrant.com/bdr/apt/pool/main/b/bdr-plugin/
Looks like the repo has not caught up to the latest 0.9.3 release. Would
it be possible to push updated packages to the repo, please? It would be
a great help with testing BDR.
Thanks,
--
Florin Andrei
http://florin.myip.org
_nodes;
TRUNCATE TABLE bdr.bdr_connections;
BEGIN;
SET LOCAL bdr.permit_unsafe_ddl_commands = true;
SET LOCAL bdr.skip_ddl_locking = true;
SECURITY LABEL FOR 'bdr' ON DATABASE bdrdemo IS '{"bdr": false}';
COMMIT;
-- Restart PG service.
-- To drop test database:
DRO
ty
postgresql-bdr-contrib-9.4 9.4.4-1trusty
postgresql-bdr-server-dev-9.4 9.4.4-1trusty
It's very useful to have these packages available, helps a lot with
testing, kudos to everyone involved.
--
Florin Andrei
http://florin.myip.org/
--
Sent via pgsql-general mailing list (pgsql-g
it a while
bdrdemo=# DROP TABLE t1bdr;
ERROR: No peer nodes or peer node count unknown, cannot acquire DDL
lock
HINT: BDR is probably still starting up, wait a while
--
Florin Andrei
http://florin.myip.org/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
mpletely, so that those workers are laid to
rest and never respawn?
Basically, how do I reset BDR completely? It seems to retain the memory
of the bdrdemo database somewhere.
--
Florin Andrei
http://florin.myip.org/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 2015-09-15 16:45, Florin Andrei wrote:
On 2015-08-25 18:29, Craig Ringer wrote:
On 26 August 2015 at 07:19, Florin Andrei
wrote:
What do I need to do to start over? I want to delete all traces of
the BDR
configuration I've done so far.
you need to DROP the database you removed,
On 2015-08-25 18:29, Craig Ringer wrote:
On 26 August 2015 at 07:19, Florin Andrei
wrote:
What do I need to do to start over? I want to delete all traces of the
BDR
configuration I've done so far.
you need to DROP the database you removed, then re-create it as a new
empty database
sly, TRUNCATE is blocked until the long
SELECT finishes.
I'm looking for ways to avoid the conflict. One way would be to do
incremental updates to the users table - that's not an option yet.
What if I rename the users table to users_MMDD? Would that still be
blocked by SELECT? If
is already a member of a BDR group
HINT: Connect to the node you wish to add and run bdr_group_join from
it instead
What do I need to do to start over? I want to delete all traces of the
BDR configuration I've done so far.
--
Florin Andrei
http://florin.myip.org/
--
Sent via pgsql-gene
so).
As load balancer, PgPool-II might be what you're looking for.
Would there be any issues if I just used an ELB pointing at two masters?
Let's say I use sticky sessions to avoid clients switching masters too
much.
--
Florin Andrei
http://florin.myip.org/
--
Sent via pgsql
On 2015-08-23 06:56, Martín Marqués wrote:
El 21/08/15 a las 20:45, Florin Andrei escribió:
The single instance scheme is not very reliable. I need to build a new
DB backend. I'll set up Postgres 9.4. Ideally, I'd like to setup 2
instances, each instance placed in a different availab
g all analytics on
the other node, what would be the best replication technique in this
case?
(We are also considering a migration from the batch update model to a
more continuous stream.)
--
Florin Andrei
http://florin.myip.org/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
such... but that's a very gimmicky solution.
Thank you,
Andrei Prodan
--
Awinta Consulting S.R.L.
Canaluluistr. 44
505600 Sacele
Brasov, Romania
Tel. +40368 / 441024
Fax. +40368 / 441024
--
-
*557064617465207472616E73616374696F6E7320736574206465736372697074696F6E3D27546573742056616C75657364C387272077686572652069643D313133
Raimon Fernandez wrote:
On 19/11/2009, at 18:13, Raimon Fernandez wrote:
On 19/11/2009, at 17:27, Kovalevski Andrei wrote:
Hi
could it be that you have errors
Hi
could it be that you have errors in your UTF8 string? For example you
might use UTF16 encoding, it can explain why some characters force
errors but others are not. Can you post here the string and its' encoded
version?
Raimon Fernandez wrote:
Hello,
I'm trying to send some strings that
You can try
If (IsNumeric(varToTest) And 0 = CDbl(varToTest)) Then IsNothing = True
Bret wrote:
This may not be the right group, if so, just let me know.
I have a table with a type [numeric].
When executing queries, I get the data which happens to
be (6.5) in this case, but my VB6 function w
Hi;
also you can try this query which should work for any version
SELECT
a.userid, a.data, max(f.data), a.data - max(f.data)
FROM
(SELECT userid, data FROM foo EXCEPT SELECT userid, min(data) FROM
foo GROUP BY userid) a LEFT JOIN foo f ON (f.userid = a.userid AND
f.data < a.data) GROUP B
replicate the whole DB). I'm I wrong on this?
And finally a question related with the instalation: are there debian
binaries to install replicator?
TIA
--
Andrei Kovalevski
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosti
toring any card and card holder info, and you definitely
shouldn't keep in DB the whole data required to authorize transaction.
Just take in mind how dangerous this info could be in case of security leak.
--
Andrei Kovalevski
PostgreSQL Replication, Consulting, Custom Development, 24x7 suppo
h&oum l;rt?
Der kann`s mit allen: *http://www.produkte.web.de/messenger/?did=3123*
--
Andrei Kovalevski
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/
specially to authenticate the connection.
Opening your access to everyone without crypto sounds like something you don't
want to do. Specially if users can change their own passwords...
Does anybody ever measured performance slowdown for SSL connections?
--
Andrei Kovalevski
PostgreSQL Replicat
ill not work since I'm using "no" in the second statement to
define the blob size, and no is not set yet.
I could solve it by using 2 different select statemen (once for the
size and one for the blob) but that seems to be a bad solution.
Sorry again!
/Paul
--
Andrei Kovalevsk
e other
unique values in this column? ;)
Regards,
Jeff Davis
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
Andrei Kovalevski
PostgreSQL Replication, Consul
M mytable;
...if you don't need uid in the result set.
Regards,
Jeff Davis
--
Andrei Kovalevski
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/
-
suggestions?
Thanks,
Roger
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
Andrei Kovalevski
Postg
I'm wondering - what kind of problems do you expect with such port? By
the way, are there any benchmark results to compare 32 and 64 bit
version on Linux?
Thanks,
Andrei.
---(end of broadcast)---
TIP 9: In versions below 8.0, the
only learned a lot more about databases, but especially that Postgres is
superior to MySQL ;-)
Thanks,
Andrei.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
7;foo'::TEXT, 'bar'")
While Not rs.EOF
rs.MoveNext
Wend
End Sub
Thanks,
Sam
---(end of broadcast)---
TIP 6: explain analyze is your friend
Thanks,
Andrei.
---(end of broadcast)---
Hello,
If you use ODBC - you should devide error from ODBC driver and errors
from PostgreSQL, ODBC driver return it's own error codes, and composes
error Description depending on Error Code and Text from PostgreSQL
server. So you should have numbers:
1) ODBC error code - described in MSDN;
2
(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Andrei
---(end of broadcast)---
TIP 4: Have
Hi!
[EMAIL PROTECTED] wrote:
Hi all.
I post it again, not sure to have posted it correctly the last time.
My problem is about installing PostgreSQL 8.2.3 on WIndows XP Mediacenter.
At the end of the installation, I get the following error: "unable to start
the service. Administrator right req
Phoenix Kiula wrote:
On 16/08/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
--- Phoenix Kiula <[EMAIL PROTECTED]> wrote:
On 16/08/07, Rodrigo De León <[EMAIL PROTECTED]> wrote:
On Aug 15, 11:46 pm, [EMAIL PROTECTED] ("Phoenix Kiula") wrote:
Appreciate any tips, b
Bob Pawley wrote:
Can anyone tell me why a table developed through the PG Admin
interface isn't found by SQL when accessing it through the SQL interface??
Bob Pawley
1) Are you sure you are connecting to the same database?
2) What kind of SQL interface you are using?
A
Tony Caduto wrote:
Andrei Kovalevski wrote:
Hi all!
Everyone who use PostgreSQL server on Windows knows - it would be
nice to have some tray management and monitoring tool for PostgreSQL
server which is running as NT Service (for example - MS SQL already
have such tool). I have
://pgfoundry.org/projects/pgtray. I'm opened for any ideas how can
we improve this tool and what features whould be helpful.
Thanks, Andrei.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
leged user. You can use
runas /user:username "initdb -D ..."
Andrei.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
HRASE=[string] - your SSL password phrase
You can either use these parameters in connection string or
configure DSN.
Andrei.
Andreas wrote:
Hi,
is there a way to have MS-Access use ODBC and still use a passphrase
encrypted private-key?
Right now ODBC works with unencrypted key.
For sec
Joshua wrote:
I checked the table and found that none of my fields in the SELECT
statement contain NULLs.
Any other suggestions?
Why are you using such constructions in your query: ',' || ',' || ',' ?
May be this set of commas makes you think that some of your fields are
empty? Do you have e
Hi!
First of all, be sure you have PostgreSQL ODBC driver installed. To
do this - follow:
start ->control panel -> administrative tools -> data sources (ODBC)
-> drivers
If you see in a list "PostgreSQL ANSI" or "PostgreSQL Unicode" -
this means driver is installed, otherwise - you s
Islam Hegazy wrote:
Hi all
I have postgresql server installed on a windows machine and I want to
retrieve data using C functions. I followed the steps in the
documentation but it didn't work for windows. I created a .dll
projects for my functions but postgres.h calls .h files that I can't
f
You can try this one.
SELECT
table2.*
FROM
(SELECT string_to_array(ids, ', ') FROM table1 WHERE name =
'Peter') AS a(a),
(SELECT generate_series(1,array_upper(string_to_array(ids,
', '),1)+1,1)FROM table1 WHERE name = 'Peter') c(n),
[EMAIL PROTECTED] wrote:
Original Message
Subject: Re: [GENERAL] SQLConnect failure
From: Bill Moran <[EMAIL PROTECTED]>
Date: Mon, April 02, 2007 2:54 pm
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
In response to [EMAIL PROTECTED]:
We have code that has be
Hi!
Why when I prepare statement by parsing such query: 'SELECT * FROM
"test" WHERE "ind" < $1 + 1' ("ind" is of type REAL) $1 is interpreted
by backend as INTEGER? Parse completed successfully, but trying to bind
parameter as '20.20' resulted in "ERROR C22P02 Minvalid input syntax for
intege
w are the extra characters in 1252 treated
by the server with LATIN1 encoding?
The error message is a little missleading, it's a character that is
represented on 3 bytes, the first one is 0xe2.
Andrei
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Viru
.
So, any ideas?
Andrei
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.9 - Release Date: 5/12/2005
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unreg
ect * from tkp.TranslationDictionary where cKeyDictionary = 'Strasse';
ckeydictionary | cvalue
+
(0 rows)
Andrei
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 5/10/2005
--
IMMUTABLE;
Andrei
Jake Stride wrote:
Is there a way to convert in interval into hours? I have a table that
records the amount of time worked by a person and want to sum up all the
hours, however with the column being an interval once you reach more
than 24 hours it turns that into a day. This is not
On Mon, 2005-04-11 at 03:28 +0200, Daniel Verite wrote:
> Florin Andrei wrote:
>
> > On MySQL, it's enough to do this:
> >
> > GRANT ALL PRIVILEGES ON dbname.* TO username [IDENTIFIED BY 'password'];
> >
> > On PostgreSQL, you have to g
relname||' TO
username;' FROM pg_class c JOIN pg_namespace n ON (n.oid=c.relnamespace)
WHERE c.relkind='S' AND n.nspname='public';" | psql -d dbname
It seems to work fine on pgsql version 8.
Of course, after creating new tables and stuff, you may have to re-run
which the data was taken from and where
everything was working fine with php, but I was having troubles with java
displaying the characters wrong... now I'm trying to see if with the data
converted to unicode works.
Thanks.
On Wed, 14 Jan 2004, Tom Lane wrote:
> Andrei Ivanov <
You will find more info attached.
What about the invalid UNICODE data ? How can I fix it ? In the attachment
there is the line that gives the error...
Thanks.
On Tue, 13 Jan 2004, Tom Lane wrote:
> Andrei Ivanov <[EMAIL PROTECTED]> writes:
> > I have a dump created with pg
I've recompiled without the patch and all is fine now. I'm sorry for
waisting your time...
On Thu, 11 Dec 2003, Tom Lane wrote:
> Andrei Ivanov <[EMAIL PROTECTED]> writes:
> > It's an almost clean build (it has
> > http://gppl.terminal.ru/hier-Pg7.4-0
This happend again, but now, postgresql tells me where it happens:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: did not find '}' at end of
input node
pg_dump: The command was: select (select usename from pg_user where
usesysid = datdba) as dba, pg_encoding_to_char(enc
On Thu, 20 Nov 2003, Tom Lane wrote:
> Andrei Ivanov <[EMAIL PROTECTED]> writes:
> > select * from pg_rewrite where ev_class = 'pg_user'::regclass gives
> > [ lots of cruft ]
>
> Well, that's interesting, because I get exactly the same data from my
Hello,
it seems my postgresql data has somehow become corrupted (by a forced
shutdown I think):
psql template1 -U shadow
Password:
ERROR: nodeRead: did not find '}' at end of plan node
Welcome to psql 7.3.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\
61 matches
Mail list logo
