schema references in the schema you did dump.
Ken
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
efore hand you are flying blind.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ste into message.
Thanks
2017-06-05 16:02 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>:
On 06/05/2017 11:55 AM, tel medola wrote:
show?
/Yes/
Yes, what?
Please run the command as shown:
select * from
@lists.sourceforge.net=subscribe> to
learn more about AGENCY or
follow the discussion.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
for something official and found
in the site in postgres the reference that the delete could be done
(https://www.postgresql.org/docs/9.1/static/release-7-4-2.html) and I
ended up doing it. Now I'm running a vacuum analyze across the base./
2017-06-05 15:41 GMT-03:00 Adrian Klaver <adrian.
= 5214489;
show?
I read in the forum to run the command:
Delete from pg_statistic;
Reindex table pg_statistic;
Vacuum analyze;
Is it okay to delete the pg_statistic table?
Do not delete the pg_statistic table. I would not even delete from it.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
S
https://aws.amazon.com/windows/resources/amis/
Neil Anderson
n...@postgrescompare.com
https://www.postgrescompare.com
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgres
?
For 01052016.repositorio with current pg_class entry of relfilenode of
13741352, change that back to the old entry of 5214489.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
lcome. I have a part of the production stopped and some
jobs are at risk.
Thanks
Roberto.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
dl -lm
VERSION = PostgreSQL 9.6.2
From the above, the LIBS doesn't indicate the presence of xml or xslt
(i.e -lxslt -lxml2).
Could someone point me to what I am doing wrong.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
#postgresql_import
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 05/28/2017 11:54 AM, Michelle Konzack wrote:
On 2017-05-28 11:23:47 Adrian Klaver hacked into the keyboard:
On 05/28/2017 10:53 AM, Michelle Konzack wrote:
SELECT * FROM products WHERE category IN
(SELECT categories.cat FROM categories WHERE
categories.serial = products.category
roducts.category which is an integer. The above is crying out for
FOREIGN KEYS. For the time being I going to assume products.category is
a faux FK to categories.serial so;
SELECT * FROM products WHERE products.category = categories.serial;
--
Adrian Klaver
adrian.kla...@aklaver.com
-
binaries (they are pretty
well hidden) I tested with those, and everything works fine there.
For those following along, where would that be?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
production cluster.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 05/26/2017 02:30 PM, Tom Lane wrote:
Adrian Klaver <adrian.kla...@aklaver.com> writes:
Well Thomas is using pg_upgrade from a BigSQL 10beta1 install to upgrade
from a 9.6 instance of unknown provenance. pg_upgrade is complaining
that the 9.6 cluster has pgxml.dll whereas the 10beta1 c
1 install to upgrade
from a 9.6 instance of unknown provenance. pg_upgrade is complaining
that the 9.6 cluster has pgxml.dll whereas the 10beta1 cluster does not
even though xml2 is installed on both clusters. The question is this a
packaging oops on the part of BigSQL or something else?
esql-archive.org/COPY-row-is-too-big-tp5936997p5963385.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://ww
e the auth method in pg_hba.conf on the publisher server from
md5 to trust and reload the server.
Neither is optimal, still it is a starting point.
I reported my problem as a bug (bug# 14669), but so far it doesn't seem to
attract any interest.
Regards,
Igor Neyman
--
Adrian Klaver
On 05/24/2017 08:30 AM, Igor Neyman wrote:
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, May 24, 2017 10:00 AM
To: Igor Neyman <iney...@perceptron.com>; George Neuner <gneun...@comcast.net>;
pgsql-general@postgresql.org
Subject:
On 05/24/2017 07:18 AM, Igor Korot wrote:
On Wed, May 24, 2017 at 10:14 AM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
On 05/24/2017 06:58 AM, Igor Korot wrote:
Adrian,
On Wed, May 24, 2017 at 12:09 AM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
It would help
On 05/24/2017 06:58 AM, Igor Korot wrote:
Adrian,
On Wed, May 24, 2017 at 12:09 AM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
It would help to know what you plan to do with the library.
I am still developing. There fore everything is build in Debug mode.
While o
On 05/24/2017 06:31 AM, Igor Neyman wrote:
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, May 23, 2017 7:42 PM
To: Igor Neyman <iney...@perceptron.com>; George Neuner <gneun...@comcast.net>;
pgsql-general@postgresql.org
Subject:
On 05/23/2017 08:03 PM, Igor Korot wrote:
Adrian,
On Tue, May 23, 2017 at 10:45 PM, Igor Korot <ikoro...@gmail.com> wrote:
Adrian,
On Tue, May 23, 2017 at 7:28 PM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
On 05/23/2017 04:15 PM, Igor Korot wrote:
Adrian,
On Tue, May 2
On 05/23/2017 07:45 PM, Igor Korot wrote:
Adrian,
On Tue, May 23, 2017 at 7:28 PM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
On 05/23/2017 04:15 PM, Igor Korot wrote:
Adrian,
On Tue, May 23, 2017 at 5:52 PM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
On 05/23/2
On 05/23/2017 05:54 PM, Ken Tanzer wrote:
On Tue, May 23, 2017 at 5:34 PM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote:
Sorry, not sure I follow what is the trailing part here?
Does the compile stage specify where a module is to
that could be interfering?
I didn't see anything that would apply. I've attached a dump of
environment variables and also a re-run of the compile/install process.
Try without the trailing:
PATH=/usr/local/pgsql96/bin:$PATH make USE_PGXS=1 clean all
Cheers,
Ken
--
Adrian Klaver
.net?body=subscribe> to
learn more about AGENCY or
follow the discussion.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
local line out of pg_hba. Then from the machine that is the
subscriber do:
psql -d repl -h pub_machine -p 5432 -U repl_user
Regards,
Igor
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
On 05/23/2017 04:15 PM, Igor Korot wrote:
Adrian,
On Tue, May 23, 2017 at 5:52 PM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
On 05/23/2017 09:12 AM, Igor Korot wrote:
Yes, I mean libpq.
Now yes, I can install it from the package manager or from source by
just running
../con
, if I am misunderstanding can you be more specific?
Thank you.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 05/23/2017 08:15 AM, Igor Neyman wrote:
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver
Sent: Tuesday, May 23, 2017 10:04 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication
BSCRIPTION, and foreign server works fine, which to me proves that there is
no issues with pg_hba.conf.
What are the contents of the pg_hba.conf file?
What are the CREATE PUBLICATION and CREATE SUBSCRIPTION commands you are using?
Regards,
Igor
--
Adrian Klaver
adrian.kla...@a
and PUBLICATION
and SUBSCRIPTION settings, to see what is actually being requested?
Regards,
Igor
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
/docs/10/static/logical-replication-quick-setup.html
--
Adrian Klaver
adrian.kla...@aklaver.com
___
Yes. All parameters mentioned in the docs configured properly.
CREATE PUBLICATION works fine
_log.c: In function ‘table_log’:
table_log.c:134:3: warning: implicit declaration of function
‘RelationGetNamespace’ [-Wimplicit-function-declaration]
Though in both cases the extension did not actually compile due to errors.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general m
stuck in my head.
Any other ideas?
Have you gone through these sections of the docs?:
https://www.postgresql.org/docs/10/static/logical-replication-config.html
https://www.postgresql.org/docs/10/static/logical-replication-quick-setup.html
Regards,
Igor Neyman
--
Adrian Klaver
adrian.kla...
on from the pg_ctl command. As I mentioned earlier, in Postgres
10+ this is going to be the default behavior for pg_ctl anyway. The
bottom line is, as you stated earlier, it does not affect the outcome of
the switch over.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general
(fdw_server) I can create foreign
tables to access tables on the “source” server, and see select from
these foreign tables.
Please let me know if my description is not clear.
Regards,
Igor
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general
FYI in Postgres 10+ -w is the default for pg_ctl.
Here is the complete output:
/------- /
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
le to log in
anyway. For more detailed information see:
https://www.postgresql.org/docs/9.3/static/sql-createrole.html
Great, thank you for the clarification!
Thank you for the help Adrian, I really appreciate it!
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-gener
, I'm just wondering
if someone can give me tips on where to focus my attention in terms of
trouble shooting?
Thanks so much!
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
do "something", I just
don't know what exactly.
It is not an internal Postgres job. Something external to Postgres is
making a change to postgresql.conf reloading the server conf files,
undoing the change and then reloading the server conf files again.
We have WAL replication set up,
On 05/18/2017 08:49 AM, Martin Goodson wrote:
On 18/05/2017 15:20, Adrian Klaver wrote:
If I remove that link then I can compile. Have no idea why.
Hi! OP here, and here's the feedback on what I'm getting after unlinking
as suggested yesterday:
I tried removing/unlinking as suggested
On 05/17/2017 02:03 PM, Tom Lane wrote:
> Adrian Klaver <adrian.kla...@aklaver.com> writes:
>> I could build repmgr against Postgres source and on Ubuntu install of
>> EDB Postgres. The issue seems to be a combination of RH and EDB Postgres
>> installation. To me
that. If not then the only thing I can find is this:
https://www.enterprisedb.com/general-inquiry-form
PF attached logfile.
Thanks and Regards,
Rakesh Mamidala
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On 05/17/2017 01:28 PM, Martin Goodson wrote:
On 17/05/2017 20:11, Adrian Klaver wrote:
I thought you where working on VM you had access/rights to.
That is not the case?
I have sudo access on the redhat box we're working on so technically I
could do this, yup. But whilst our Unix team
On 05/17/2017 12:01 PM, Martin Goodson wrote:
On 17/05/2017 17:19, Adrian Klaver wrote:
Spun up a RH 7.3 instance and tried the compile and got the same error.
Good to know it's reproducible, and not just me :)
I'll have a word with our UNIX team about unlinking this (and relinking
On 05/17/2017 09:46 AM, Adrian Myers wrote:
Ah I should have mentioned, the pager is off.
Is that by choice and if so why?
With the pager off you have to wait for the entire output to write to
the screen. For anything but a small dataset that is going to take time.
--
Adrian Klaver
On 05/17/2017 09:22 AM, Adrian Myers wrote:
Please reply to list also
Ccing list
Hi Adrian, it is running locally.
In addition to Pavel's suggestions:
In psql what does \pset show for the pager setting?
On Wed, May 17, 2017 at 12:21 PM, Adrian Klaver
<adrian.kla...@aklaver.
and poking around the data take longer
than I would like as a result. Is there any way to improve just the
display/write performance in the console?
Is this a psql client local to the server machine or across a network?
Thanks for any insight,
Adrian
--
Adrian Klaver
adrian.kla...@aklaver.com
On 05/17/2017 07:26 AM, Martin Goodson wrote:
On 16/05/2017 18:46, Adrian Klaver wrote:
Per Tom's suggestion try
ldd /db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2
Hello. Apologies for the delay in replying - medical appointment this
morning :) Anyway, executed that command
On 05/17/2017 07:26 AM, Martin Goodson wrote:
On 16/05/2017 18:46, Adrian Klaver wrote:
Per Tom's suggestion try
ldd /db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2
Hello. Apologies for the delay in replying - medical appointment this
morning :) Anyway, executed that command
On 05/16/2017 10:44 PM, reem wrote:
postgres 9.3 in ubuntu OS.
Meant to add to previous post.
What is the full version number of Postgres e.g. 9.3.x?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
pared transactions."
Might want to take a look at what is in pg_prepared_xacts:
https://www.postgresql.org/docs/9.3/static/view-pg-prepared-xacts.html
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
On 05/16/2017 08:39 AM, Martin Goodson wrote:
On 16/05/2017 15:58, Adrian Klaver wrote:
For completeness what does:
ls -al /usr/lib64/libssl.so
show?
(Trimming things down a bit to keep things a little bit more readable,
now we've got the package dependencies issue sorted. Hopefully
utovacuume is turned on.
Please , I need help or any suggestion?
--
View this message in context:
http://www.postgresql-archive.org/database-is-not-accepting-commands-tp5961831.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 05/16/2017 07:22 AM, Martin Goodson wrote:
On 16/05/2017 14:42, Adrian Klaver wrote:
On 05/16/2017 04:36 AM, Martin Goodson wrote:
On 15/05/2017 00:17, Martin Goodson wrote:
That list would be:
systemd
libxslt-devel
pam-devel
openssl-devel
readline-devel
libmemcached-devel
libicu-devel
. Something to show that is probably not on the Postgres end.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
me. I just tested inserting an 11MB file using
psycopg2(Python) and it was less then a second.
I do have the Sequelize ORM and the pg driver in between my code and the
database.
Thanks,
Eric
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql
, preparing the statement in
advance, ANALYZEing the table, none of these change the behavior.
Why does the query planner choose to ignore the index when the command
is parameterised?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
Regards,
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the packages for you,
was that on the host or the virtual machine?
Any ideas? Is this a new thing, an existing issue that's popped up
before, or (yet again! :) ) a case of me missing something that is
blindingly obvious to everyone else?
Regards,
Martin.
--
Martin Goodson
--
Adrian Klaver
mouth, I'd have higher
expectations than that. Only because of the great work y'all do! ;)
Might want to file an issue here:
https://redmine.postgresql.org/projects/pgrpms/
You will need a Postgres community account, which you can sign up for on
the same page.
Cheers,
Ken
--
Adr
ibyte
encodings.
"
So:
production=# show max_identifier_length ;
max_identifier_length
---
63
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.or
will look for duplicates?
Without actual information, the only thing that can be said is that it
is slow.
Information needed:
Postgres version
Table schema for tableA and tableC
The view query
The output of the explain for the view query.
Thanks
Patrick.
--
Adrian Klaver
adrian.kla...@a
sql: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
* Pass -h /tmp to 9.6's psql, so that it connects to 9.2 instance.
-HTH
Regards,
--
Adrian Klaver
adria
bit outdated but:
>
> http://raghavt.blogspot.com/2015/01/configuring-automatic-failover-using.html
https://www.postgresql.org/message-id/4ff25277-cfb6-4dbc-0f98-13c031dd4181%40aklaver.com
The OP followed the procedure in the above to get to Round 3:)
>
>
> JD
>
--
Adrian Kl
usr/bin/install -c -m 644 .//repmgr.sql .//uninstall_repmgr.sql
'/opt/PostgreSQL/9.6/share/postgresql/contrib/'
Regards,
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
h
On 05/14/2017 01:21 PM, Devrim Gündüz wrote:
Hi,
On Sun, 2017-05-14 at 12:59 -0700, Adrian Klaver wrote:
We don't support OpenSuSE, that might be the reason.
Who is we
EnterpriseDB.
and what don't you support?
OpenSuSE, as I wrote in the previous email.
You might need to rewrite
On 05/14/2017 11:31 AM, Devrim Gündüz wrote:
Hi Adrian,
On Sun, 2017-05-14 at 09:00 -0700, Adrian Klaver wrote:
I understand. I just installed EDB Postgres 9.6.3 on my openSUSE Leap
42.2 machine and tried to compile repmgr against it. No joy.
We don't support OpenSuSE, that might
stgresql/software/9.6.2/lib/libpgport.a(path.o):
relocation R_X86_64_32 against `.rodata.str1.1' can not be used when
making a shared object; recompile with -fPIC
(apologies if you did this already, I did not read the whole thread):
Makefile: line 33
sql/Makefile: line 13
and run
USE_PGXS=1 m
On 05/14/2017 02:43 AM, Martin Goodson wrote:
On 12/05/2017 18:57, Adrian Klaver wrote:
On 05/12/2017 09:19 AM, Martin Goodson wrote:
On 12/05/2017 16:59, Adrian Klaver wrote:
To make things easier I would remove the deb installed Postgres, it
just adds complexity to the situation without
On 05/14/2017 02:43 AM, Martin Goodson wrote:
On 12/05/2017 18:57, Adrian Klaver wrote:
On 05/12/2017 09:19 AM, Martin Goodson wrote:
On 12/05/2017 16:59, Adrian Klaver wrote:
Progress of a sort. Kinda.
On a clean Ubuntu server 17.04 virtual machine I've installed PostgreSQL
9.6 using
On 05/12/2017 09:19 AM, Martin Goodson wrote:
On 12/05/2017 16:59, Adrian Klaver wrote:
Configuring Automatic failover using Replication Manager 2.0 on
PostgreSQL 9.3.5
http://raghavt.blogspot.com/2015/01/configuring-automatic-failover-using.html
"In this post, am demonstr
On 05/12/2017 09:14 AM, Martin Goodson wrote:
On 12/05/2017 16:48, Adrian Klaver wrote:
On 05/12/2017 08:30 AM, Martin Goodson wrote:
On 12/05/2017 16:18, Joshua D. Drake wrote:
The EDB installer allows you to specify where to install PostgreSQL, and
uses /opt/PostgreSQL/ for the default
L 6.5 - PostgreSQL 9.3.5. In order to achieve an
easy and good understanding of concept I have compiled repmgr with
EnterpriseDB One Click Installer(a pre-build binary package) instead of
PG source."
Regards,
Martin.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-gener
in this post is still correct:
https://www.postgresql.org/message-id/CAG7mmozd7VAtdGLyE8pMaxu2KRmJxNTvLTyA0N92nEhXZ4k6hQ%40mail.gmail.com
the EDB pg_config should be in:
/opt/PostgreSQL//bin/
Regards,
Martin.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list
us would be
greatly appreciated.
Regards,
Martin.
--
Martin Goodson
"Have you thought up some clever plan, Doctor?"
"Yes, Jamie, I believe I have."
"What're you going to do?"
"Bung a rock at it."
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent
On 05/11/2017 07:26 AM, Igor Korot wrote:
Adrian et al,
On Thu, May 11, 2017 at 9:54 AM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
On 05/11/2017 06:24 AM, Igor Korot wrote:
Thank you.
Will take a look and modify to use in my program.
I presume I'm allowed to do that, right?
On 05/11/2017 10:55 AM, Ron Ben wrote:
any news on that?
Did you ask on --hackers or file a bug report?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
| NO
--
Greg
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 05/11/2017 07:32 AM, Vibhor Kumar wrote:
On May 11, 2017, at 10:17 AM, Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>> wrote:
Not sure how deep you are into your present situation. The only thing
I can think of is to install Postgres using th
while
you do the migration. This way you could use the packaging system
without resorting to work-arounds.
Many thanks.
Martin.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
=18be08fead5762970e7a9718422c6fd0835bd209;hb=ca9cfed88d5801716eb01cf28b6b5be2b5cd
is not possible?
Thank you.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
On 05/10/2017 12:46 PM, Paul Hughes wrote:
Adrian Klaver Wrote:
Many on this list(myself included) will want to know how you came to that
conclusion and I am speaking as someone who uses Python, Django and Postgres.
I came to that conclusion when I saw a list of the top 15 websites
(based
before doing this on
live data.
Thanks
sandeep
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
;LAMP" or "LAPP" stack: i.e. Linux, Apache, MySQL or Postgresql,
PHP or Python.
There needs to be a compelling *application* reason to install
something else: a JVM (or Apache-Tomcat vs regular Apache),
Ruby/Rails, Groovy/Grails, etc.
--
Adrian Klaver
adrian.kla...@aklaver.c
be considered suspect. If you are concerned then take another pg_dumpall
before rolling back.
How do I do that?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
On 05/09/2017 07:03 PM, Armand Pirvu (home) wrote:
On May 9, 2017, at 7:11 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
On 05/09/2017 05:02 PM, armand pirvu wrote:
Well
Jt1 is prod and jt2 is dev
You are talking schemas, not databases, correct?
Correct
Before someone
to say the type of load or users
doing something in each schema.
The issue being that if you are pushing data from jt2 --> jt1 you are
also pushing the load in the same direction.
So my questions still remain
Sent from my iPhone
On May 9, 2017, at 6:52 PM, Adrian Klaver <adri
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
iable ?
- I recall data transformation can be used in Bucardo but did not see
any examples on that. Any pointers ?
Thanks
Armand
On May 8, 2017, at 4:49 PM, Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>> wrote:
On 05/08/2017 12:46 PM, Armand P
Postgres and Python seem to be attached I would say that is
because about the time people started looking for an alternative to
MySQL/PHP, Python reached the state and breadth of distribution to
became the language to pair with Postgres.
On Mon, May 8, 2017 at 3:50 PM, Adrian Klaver
ICT LOG: all server processes terminated;
reinitializing
2017-05-08 10:08:29 ICT FATAL: pre-existing shared memory block is
still in use
2017-05-08 10:08:29 ICT HINT: Check if there are any old server
processes still running, and terminate them.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Se
sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=icon>
Virus-free. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=link>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
--
Adrian
for it on table B
Now, how could I do that in a Select? Can you please provide some examples?
If you can provide some information:
1) The table schema
2) How the data is related between the two tables.
I'm using PostgreSQL 9.1.
Thanks
Patrick
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent
e ? If so any pointers as to where to look about it ?
Many thanks
Armand
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lm
[/code]
Thank you.
P.S.: Server is running and I can successfully connect to it.
FWIW, I'm running OSX 10.8.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general
101 - 200 of 4904 matches
Mail list logo