for, then I would suspect there will tables/functions/etc that do
not exist in the community version you could query for.
On 07-Jul-2017 7:28 PM, "Adrian Klaver" <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>> wrote:
On 07/07/2017 06:52 AM, Kr
.
--
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
d during PostgreSQL 8.4
installation [scenario 3].
Thanks and Regards,
Mayank Agrawal
.
On Fri, Jul 7, 2017 at 4:56 AM, Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>> wrote:
On 07/04/2017 10:23 PM, Mayank Agrawal wrote:
Hello,
I
nstalling PostgreSQL 9.5?*
Thanks and Regards,
Mayank Agrawal
--
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
tored in the database and is not affected by -R. Note that
your generated sql file will contain both the main table and overview
tables."
In addition it is going to produce an SQL file that contains the changes
for you to look at.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent
On 07/05/2017 08:31 AM, Hans Schou wrote:
2017-07-05 15:41 GMT+02:00 Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>:
[scheme[<+>dsn]]://[[username[:[password]]@][host][:port][/[dbname][/[[table[/[column[,
where and when the issues appear may help with
determining the source.
--
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 07/04/2017 11:56 PM, Rainer J.H. Brandt wrote:
Tom Lane writes:
Adrian Klaver <adrian.kla...@aklaver.com> writes:
On 07/04/2017 01:29 PM, Rainer J.H. Brandt wrote:
Good to know. I removed those options and tried again.
Did you run make clean before re-running ./configure?
Pers
...]*]]]|sql]]]
^
The thing is that in a quick search on this I did not find a reference
implementation of this to compare against.
Yours,
Laurenz Albe
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@po
https://yum.postgresql.org/repopackages.php#pg95
I have download pgdg-redhat95-9.5-3.noarch.rpm from the above link and
install successfully on my server.
"
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
see how Perl can make the difference,
but I guess it's not relevant that I can't see it ;-(
Thanks for taking the time to answer.
Rainer
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
3) 1) and 2) could be moot if Daniel's hardware corruption theory is
correct.
4) This is probably not going to be solved until you are able to access
the actual file(s) in question.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-g
On 07/04/2017 10:13 AM, Moreno Andreo wrote:
Il 04/07/2017 18:25, Adrian Klaver ha scritto:
On 07/04/2017 09:02 AM, Moreno Andreo wrote:
Il 04/07/2017 17:39, Adrian Klaver ha scritto:
So what you are saying is "in the last 5 years you've been
extremely lucky?" :-)
Your original
On 07/04/2017 09:02 AM, Moreno Andreo wrote:
Il 04/07/2017 17:39, Adrian Klaver ha scritto:
So what you are saying is "in the last 5 years you've been extremely
lucky?" :-)
Your original post went back and forth on whether you where lucky in
the past:
"... that's be
e stored/read as binary
format rather than as text. It is somewhat faster than the text and CSV
formats, but a binary-format file is less portable across machine
architectures and PostgreSQL versions.
Thanks
Moreno
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-gene
), so my
backup is made up by 2 files, one with "normal data" and one with the
result of COPYing this table to a file.
A question that comes while I'm writing: but pg_dump with custom format
is not using COPY with binary format?
Thanks
Moreno
--
Adrian Klaver
adrian.kla...@aklav
ndrives we get often this error)."
Thanks
Moreno.
--
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
corrupted data (when using cheap pendrives we get often this
error). Should it be reasonable or I have to search elsewhere?
Thanks in advance
Moreno.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
/jr
Sent from my iPhone
--
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
-
View this message in context:
http://www.postgresql-archive.org/Need-help-on-compiling-postgres-source-code-from-cloned-repo-tp5969667.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing
in context:
http://www.postgresql-archive.org/have-trouble-understanding-xmin-and-xmax-with-update-operations-from-two-different-sessions-tp5969629.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing
be helpful though:
Postgres version?
OS and version?
The pg_basebackup command line invocation?
Why you don't think it is index corruption?
2017-07-01 7:30 GMT+08:00 Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>:
On 06/30/2017 07:33 AM, Timokhin
.
https://www.postgresql.org/docs/9.6/static/pgupgrade.html
"pg_upgrade supports upgrades from 8.4.X and later to the current major
release of PostgreSQL, including snapshot and alpha releases."
after that server starts normally.
--
Timokhin 'maf' Maxim
--
Adrian Klaver
ne: DIRELIANT2, Thread Name:
Process Name: C:\Program Files\Dynamic Instruments, Inc\Digital
Recorder\DICSInterface\DICSInterface.exe
Niel Smith - Support Technician
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
okhin 'maf' Maxim
--
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
3.1?
Also where are you getting Postgres from? I ask because 9.6.3.1 is not
a community version or was that just a typo?
Everything would be not bad if in the table weren't appeared duplicated
records in url column.
Any idea how is it possible?
Thank you!
--
Timokhin 'maf' Maxim
--
Adrian K
fe, eso me bastará.
Rozvo Ware Solutions
--
View this message in context:
http://www.postgresql-archive.org/postgres-dbname-dbuser-9-9-9-9--PARSE-waiting-tp5968923p5969262.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
10672
The only thing I understand in the above is:
"...the free memory (89677824 bytes) is less than 5% of total memory."
Whatever it is wants more memory.
if anyone can help me out with these errors that would be very much
appreciated.
Thank you
Niel Smith - Support Technic
Niel Smith - Support Technician
Equature
--
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
data.
In fact in most cases that I have run across ERROR's are more
informational then data affecting.
Cheers,
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.postgre
On 06/28/2017 06:52 AM, Merlin Moncure wrote:
On Wed, Jun 28, 2017 at 8:37 AM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
On 06/28/2017 06:27 AM, gmb wrote:
CREATE TABLE inventory_item_table AS ( SELECT some_func( ) limit 0);
I think it's better to use the (somewhat
bles excepted).
Maybe it is worth to enhance the documentation for this, at least for
synchronous_commit=true? The asynchronous behavior is well documented
here: https://www.postgresql.org/docs/current/static/wal-async-commit.html.
Again, thanks David and Adrian for your help
Kind Regards
Dan
type
<http://www.postgresql-archive.org/CREATE-TABLE-composite-type-tp5969032.html>
Sent from the PostgreSQL - general mailing list archive
<http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html> at
Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql
urces to be
used must be installed in the system and reflected in the
/etc/odbcinst.ini file."
See also:
https://github.com/CartoDB/odbc_fdw/issues/45
I would ask there, by either responding to existing issue or starting a
new issue.
Thanks,
Swapnil Vaze
On Tue, Jun 27, 2017 at 6:38 PM, Adr
the
data dir is Environment=PGDATA=/opt/PostgreSQL/9.4/data
What is going wrong?
I am no systemd expert by any means, but I have to believe that it
should be:
Environment=PIDFILE=/opt/PostgreSQL/9.4/data/postmaster.pid
TIA
Marcelo
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent
etter able to do that is going to require some detective work to
determine what is generating the connections and for what purpose.
Thanks for your help!
-
Dame un poco de fe, eso me bastará.
Rozvo Ware Solutions
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-gener
On 06/27/2017 03:41 PM, Melvin Davidson wrote:
On Tue, Jun 27, 2017 at 6:32 PM, Adrian Klaver
*His problem is NOT 'idle in transaction' per se. It is all connections
are used up.*
Not following. The 'idle in transaction' queries are coming in through a
connection so having them around
pointer process
\_ postgres: writer process
\_ postgres: wal writer process
\_ postgres: autovacuum launcher process
\_ postgres: stats collector process
\_ postgres: bgworker: pglogical supervisor
AFAIK the wal writer process.
>
> Thanks
> Daniel
>
>
--
://www.postgresql-archive.org/postgres-dbname-dbuser-9-9-9-9--PARSE-waiting-tp5968923.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
to prefix some settings with odbc_.
In your example that would be odbc_database 'TESTV9' instead of database
'TESTV9'.
How can I access DB2 LUW or zOS database tables from postgres?
--
Thanks & Regards,
Swapnil Vaze
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-gen
On 06/26/2017 01:10 PM, Paul A Jungwirth wrote:
On Mon, Jun 26, 2017 at 12:47 PM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
On 06/26/2017 12:03 PM, Paul Jungwirth wrote:
Perhaps
you should see what is line 85 when you do `\sf words_skip_game` (rather
than line 85 in your own sourc
On 06/26/2017 01:10 PM, Paul A Jungwirth wrote:
On Mon, Jun 26, 2017 at 12:47 PM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
On 06/26/2017 12:03 PM, Paul Jungwirth wrote:
Perhaps
you should see what is line 85 when you do `\sf words_skip_game` (rather
than line 85 in your own sourc
`INTO`. I see from your gist that your function *does* have some queries
that are `INTO STRICT`, so I would focus on those.
That page also describes how to use `print_strict_params` to get a
little more info about the details of the error.
I hope that helps!
Paul
--
Adrian Klaver
ad
On 06/25/2017 01:34 PM, Andreas Joseph Krogh wrote:
På søndag 25. juni 2017 kl. 17:04:02, skrev Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>:
On 06/25/2017 07:34 AM, Fabiana Zioti wrote:
> I'm creating an extension to PostgreSQL, with use
.
Not seeing how Qt will work in a Postgres extension?
PostgreSQL provides the tutorial for working with eclipse:
https://wiki.postgresql.org/wiki/Working_with_Eclipse#
Is there any tutorial for Qt? Or are the setup steps similar to Eclipse?
Thank you very much in advance.
--
Adrian Klaver
/members.id/>= 1
ONmissions.id <http://missions.id/>= submissions.mission_id
WHERE missions.track_id = 7
--
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
of
the buttons you will be taken to 9.6.3 binaries for the OS/Arch.
Thanks,
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
>>>>>> --
>>>>>> Please see .kitchen/logs/kitchen.log for more details
>>>>>> Also try running `kitchen diagnose --all` for configuration
-Server type: VMware
OS: Redhat 6 or Redhat 7
PostgreSQL Version: 9.5.7
-Pawan
not to be true, right? Why do I need the wal_writer at all
then when synchronous_commit is set to something else than off?
See here:
https://www.postgresql.org/docs/9.6/static/wal-async-commit.html
Thanks for your help
Daniel
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql
uld only get if the
database is up. But in the process, it leaves a message behind in the
server's log file.
Basically it pings the server with whatever information it has at that
stage in the startup procedure until hopefully it has the complete
information needed.
Cheers,
Jeff
--
Adrian Klave
On 06/22/2017 01:41 PM, Ray Stell wrote:
On 6/22/17 4:36 PM, Adrian Klaver wrote:
On 06/22/2017 01:16 PM, Ray Stell wrote:
On 6/22/17 4:07 PM, Adrian Klaver wrote:
On 06/22/2017 12:06 PM, Ray Stell wrote:
I used "initdb -U" to specify an alternate superuser. On startup it
Ca
On 06/22/2017 01:16 PM, Ray Stell wrote:
On 6/22/17 4:07 PM, Adrian Klaver wrote:
On 06/22/2017 12:06 PM, Ray Stell wrote:
I used "initdb -U" to specify an alternate superuser. On startup it
Can you show your complete initdb command?
throws these msgs:
2017-06-22 14:36:34 EDT
On 06/22/2017 01:29 PM, Jeff Janes wrote:
On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote:
On 06/22/2017 01:13 PM, Jeff Janes wrote:
On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell <ste...@vt.edu
as, so it just uses the default.
Cheers,
Jeff
--
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
:36:34 EDT,0,startup LOCATION: InitializeSessionUserId,
miscinit.c:503
--
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 interesting stuff is done by CREATE LANGUAGE.
* Later we will probably "dumb down" that command and put more of the
* knowledge into this script.
*/
CREATE PROCEDURAL LANGUAGE plpgsql;
COMMENT ON PROCEDURAL LANGUAGE plpgsql IS 'PL/pgSQL procedural language';
--Jim :^)
--
Adr
then one version of Postgres installed then you will
need to use the pg_config from that version:
/usr/local/pgsql94/bin/pg_config --version --configure
PostgreSQL 9.4.11
'--with-python' '--with-openssl' '--with-libxml'
'--prefix=/usr/local/pgsql94'
Thanks.
Regards
Dylan
--
Adrian Klaver
plpgsql | postgres | t | PL/pgSQL procedural language
plpythonu | postgres | f | PL/PythonU untrusted procedural
language
I won't worry about this much more, but if the system identifies it as
an error then
I thought it was at least worth making the inquiry. Thanks!
--J
plan until I forced a new
function version. Hence my questioning, is there more than just «plpgsql cache
plans» in that issue…
If there is nothing else, then I'll start digging the code…
I don't know, which is why I am returning this to list.
Pierre
--
Adrian Klaver
adrian.kla
a table, but this seems… odd to me. I don't think we are
> doing anything very complicated here, so I'm surprised that nothing has been
> done yet to fix that issue.
https://www.postgresql.org/docs/9.6/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
> Did I miss som
On 06/21/2017 05:08 AM, Günce Kaya wrote:
Hi,
I work on PostgreSQL 9.6 and I'm looking for a source code control tool.
Is there anyone who give a suggest about that?
http://sqitch.org/
Best Regards,
--
Gunce Kaya
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general
On 06/20/2017 01:23 PM, Alban Hertroys wrote:
On 20 Jun 2017, at 18:46, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
Yes this could be become complicated if for no other reason then it is being
driven from the customer end and there will need to be a process to verify and
incor
On 06/20/2017 08:12 AM, Steve Clark wrote:
On 06/20/2017 10:38 AM, Adrian Klaver wrote:
On 06/20/2017 07:00 AM, Steve Clark wrote:
We already have a monitoring system in place that has been in operation circa
2003. Just recently we have
added a new class of customer whose operation
On 06/20/2017 07:00 AM, Steve Clark wrote:
On 06/20/2017 09:02 AM, Adrian Klaver wrote:
On 06/20/2017 05:35 AM, Steve Clark wrote:
Hello,
We have customers whose equipment we monitor. Some of the customers don't run a
24/7 operation
and turn their equipment off when the go home. We need
and do you or the customer provide it?
Thanks in advance,
Steve
--
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
.
Many thanks for your help, which is exceptionally clear and detailed.
MM
--
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
m1L3zsHQm9eceGhQh8UV4IOgzDvapg=MpRqOYUdfX_Z4OK9-AFg2b7glEe4lY2aYupB6508ZjQ=
From you original post the directory you mentioned:
/users/martin/Library ApplicationSupport/Postgres/var9.5/base/
looks to be below the top level data directory.
While I remember, how are you installing/updating Postgres on your
) The above is valid for Steve Atkins suggestion of using the external
drive as the sole data directory. The only thing I would be concerned
about is that external hard drives I have worked with are not all that
fast, you will have to see if that is a problem in your case.
--
Adrian Klaver
being you do not
have Dropbox trying to sync while you are using the database. That I am
pretty sure will not end well. The above does depend on familiarity with
programs like rsync or Unison for the syncing portion.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general ma
/
There is one for RHEL7 Workstation, but not for RHEL6.
Thanks,
Sari
--
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 someone who is just started with PostgreSQL and C interface it is
confusing.
Maybe this will help:
https://www.postgresql.org/docs/9.6/static/libpq-example.html
Thank you.
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgre
On 06/15/2017 01:23 PM, Igor Korot wrote:
Hi, Adrian,
On Thu, Jun 15, 2017 at 4:13 PM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
On 06/15/2017 12:02 PM, Igor Korot wrote:
Hi, again,
On Thu, Jun 15, 2017 at 2:59 PM, Igor Korot <ikoro...@gmail.com> wrote:
Hi, ALL,
n the connection
to the server?
https://www.postgresql.org/docs/9.6/static/multibyte.html
Thank you.
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.postgre
|| ('{"community_zoid": ' || zoid || '}')::jsonb;
end if;
end if;
...
Not sure what happens if zoid is null and new_zoid is null also?
Or if it matters?
Jim
--
Jim Fulton
http://jimfulton.info
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing
esn’t complain if the database, never mind the schema,
doesn’t exist.
If this turns out to be a bug, I’ll happily move to the bug mailing list to
discuss further. But under the possibility I’m missing the obvious, I’d thought
I’d try here first.
I’m going to go try the 10.0 beta now…
Thanks!
- Paul
when checking an old running server,
the old and new port numbers must be different."
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
', $2 = '1'
ERROR: type " " does not exist at character 149
What are you using to execute the above query and how are the parameters
being supplied to $1 and $2?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To ma
On 06/12/2017 11:03 AM, Fabiana Zioti wrote:
I already have postgresql 9.6 installed. I'm developing extensions for
it in C. What would be the best IDE to debug the code? Eclipse has many
errors.
The errors are?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing
that also take summer time
into consideration? And using the immutable function wrapper is wrong?
By correct approach, you mean setting timezone to 'UTC'?
If by immutable function wrapper, you mean faking the immutability of a
function, then yes I would see that as wrong.
--
Adrian Klaver
adrian.kla
system settings could cause this behaviour? We run
Ubuntu Linux 16.04 and Postgresql 9.6
Another question is, should I just create immutable functions wrappers
for this instead?
--
Kind Regards / Med Vennlig Hilsen
Olav Grønås Gjerde
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via
party
site, like Dropbox.
regards, tom lane
--
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 06/09/2017 02:26 PM, armand pirvu wrote:
On Jun 9, 2017, at 4:20 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
On 06/09/2017 02:01 PM, armand pirvu wrote:
On Jun 9, 2017, at 3:52 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
On 06/09/2017 01:31 PM, armand
On 06/09/2017 02:01 PM, armand pirvu wrote:
On Jun 9, 2017, at 3:52 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
On 06/09/2017 01:31 PM, armand pirvu wrote:
By temporary tables I mean just regular table not tables created by "create
temporary table" . I shoul
c/progress-reporting.html
Aside that there are vacuum improvements and such, any other strong
compelling reason to upgrade to 9.6 ?
That would depend on what version you are on now. If it is out of
support then there would be a reason to upgrade, not necessarily to 9.6
though.
--
Adr
G-WHEN
log_min_messages (enum)
https://www.postgresql.org/docs/9.6/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
log_connections (boolean)
log_disconnections (boolean)
log_duration (boolean)
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-g
On 06/09/2017 09:13 AM, armand pirvu wrote:
On Jun 9, 2017, at 11:01 AM, Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>> wrote:
On 06/09/2017 08:45 AM, armand pirvu wrote:
Hi
Had a couple of processes blocking the vacuum so I terminated them
/docs/9.6/static/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW
Thank you
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
y/aa363860(VS.85).aspx
307 */
308 if (CreateHardLinkA(dst, src, NULL) == 0)
309 {
310 _dosmaperr(GetLastError());
311 return -1;
312 }
313 else
314 return 0;
315 }
316 #endif
Regards
--
Arnaud
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Se
and then the directory it points to.
--
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
able to debug this up to now.
Oops on my part.
--
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
us
crazy for some time now.
Looks like you also have postgis and pointcloud_postgis in mix. I would
say this may get an answer sooner here:
http://lists.osgeo.org/mailman/listinfo/pgpointcloud/
Thanks.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pg
t-in-query-tp5965573.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://www.postgresql.org/mailpref/pgsql-general
On 06/08/2017 08:13 AM, ADSJ (Adam Sjøgren) wrote:
Achilleas writes:
Anyone has a handy little script lying around?
http://www.databasesoup.com/2013/10/de-corrupting-toast-tables.html
Thanks for the response!
Adam
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via
also think about moving the tables to a new
tablespace to get a clean tablespace directory. Again this assumes space
available.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
ing.
--
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
ard Postgres advisory locks
..."
Thanks,
DR
--
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
5214495.4
422 File(s) 445.600.333.824 bytes
2 Dir(s) 198.487.891.968 bytes free
2017-06-06 16:37 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>:
On 06/06/2017 11:09 AM, tel medola wrote:
I will not be able t
elfilenode is for the TOAST table and then have you
look for it or maybe change it.
2017-06-06 10:37 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>:
On 06/06/2017 04:40 AM, tel medola wrote:
Lets go:
In my plsql:
ra
| 0 | t | f | p
| r |7 | 0 | f | t
| f | f | f | t |
9360288 | 1 ||
(1 registro)
Ok?
--
Adrian Klaver
adrian.kla...@aklaver.com
1 - 100 of 4904 matches
Mail list logo