>
>
> On 9.0.3 corrected for the ':':
>
> test(5432)aklaver=>select to_timestamp('02/26/2011 14:50', 'MM/DD/
> HH24:MI');
> to_timestamp
>
> 2011-02-26 14:50:00-
v
> ---
> >0.1<
>
> So, padding zeroes suppressed by FM is a rest of the value.
Any documentation changes suggested?
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything
>
>I'll manually install them.
I don't think we ever researched how to install manual pages in all the
distributions. /share does make sense; not sure why that doesn't happen.
--
Bruce Momjian http://momjian.us
EnterpriseDB htt
Rich Shepard wrote:
> On Thu, 10 Mar 2011, Bruce Momjian wrote:
>
> > I don't think we ever researched how to install manual pages in all the
> > distributions. /share does make sense; not sure why that doesn't happen.
>
> Bruce,
>
>That's wh
e.
You can modify pg_hba.conf to 'trust' if you lost the password. If you
removed the row, I think you need to start the server in single-user
mode.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for every
o upgrade the master, and make a new slave. It is something we had not
considered. I don't think you can run pg_upgrade on the slave and have
it work.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible
Magnus Hagander wrote:
> On Fri, Mar 11, 2011 at 13:02, Bruce Momjian wrote:
> > Damien Churchill wrote:
> >> Hi there,
> >>
> >> I have done quite a bit of searching but have been unable to find any
> >> way to do this. I am quite keen to use PostgreS
uot;, like slony, bucardo, londiste etc.
> >
>
> Thanks for the response!
>
> That's the conclusion I had come to as well, I thought it best to ask
> in case there was a method I hadn't come across. Is anything planned
> to allow SR to be used for dow
Dmitriy Igrishin wrote:
> 2011/3/10 Bruce Momjian
>
> > Dmitriy Igrishin wrote:
> > > dmitigr=> SELECT '>'||to_char(0.1, '0.9')||'<' AS v;
> > > v
> > >
> > > >
arger WAL size but it
> stayed at 16 Mb. Any info on this?
Why is 16MB too small? Most people increase checkpoint_segments for
larger installs and it works fine.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's im
gt; We are doing continuous archiving and we have thousands of these 16 Mb
> archive files on disk.
> My boss is used to using Oracle where you can set the size of the files.
> He'd rather have fewer but larger archive files.
There is no option to do that, but there is pg_lesslo
http://postgresql.1045698.n5.nabble.com/PostgreSQL-for-Holdem-Manager-could-not-be-installed-tp3700954p3708616.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes
at Nabble.com.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterp
Adrian Klaver wrote:
> On Tuesday, March 15, 2011 9:04:30 am Bruce Momjian wrote:
> > The larger question is whether these forums should be used to help
> > people get support for commercial products that embed Postgres.
> >
>
> The eternal Open Source dilemma. Once i
Adrian Klaver wrote:
> On Tuesday, March 15, 2011 9:31:17 am Merlin Moncure wrote:
> > On Tue, Mar 15, 2011 at 11:04 AM, Bruce Momjian wrote:
> > > The larger question is whether these forums should be used to help
> > > people get support for commercial products that
quotes,
and then bytea is saying it doesn't know how to process \something. It
sounds like you want bytea but don't want the ability to use backslash
escapes to input the bytea values. I am unsure how to accomplish that.
--
Bruce Momjian http://momjian.us
EnterpriseDB
ith
> disable-integer-datetimes?
pg_upgrade --check will definitely complain about a timestamp storage
mismatch. Odds are your packager built 8.3 with integer timestamps.
Run pg_controldata on the 8.3 cluster and look at:
Date/time type storage: 64-bit integers
This
S.: pg_upgrade_utility.log attached.
I am not sure what would cause this. At the point where you get this
error, pg_upgrade has already started and stopped the old and new
servers, so I am not sure why the pid file would exist. Is it possible
the file copy was so fast that the new cluster had
ql
> service while we were trying to do the upgrade. Looks like this was the
> cause of the failure.
OK. We block users from connecting to our own postmaster by placing the
socket files in the current directory, but that doesn't prevent someone
from starting the server using the default
On Wed, May 28, 2014 at 04:56:53PM -0700, Adrian Klaver wrote:
> On 05/28/2014 08:15 AM, Bruce Momjian wrote:
> >On Wed, May 28, 2014 at 12:05:54PM -0300, Leonardo M. Ramé wrote:
>
> >>
> >>Sorry guys, one of the in-site tech support guys started the postgresql
>
on view column ?
This has been fixed by this commit:
commit eb56812144bb310f7cb2f63e53d6d58f30df95b5
Author: Fujii Masao
Date: Mon May 19 17:03:30 2014 +0900
Fix incorrect column name in pg_stat_replication document.
Fabrízio de Royes
On Wed, May 28, 2014 at 11:28:47PM -0400, Tom Lane wrote:
> Bruce Momjian writes:
> > On Wed, May 28, 2014 at 04:56:53PM -0700, Adrian Klaver wrote:
> >> So for my edification, does that mean -O ' -c
> >> config_file=/etc/postgresql/9.3/main/postgresql.conf'
If you need any additional info from me please dont hesitate to ask.
Thanks
Bruce
TopMemoryContext: 171136 total in 13 blocks; 4128 free (5 chunks); 167008 used
Type information cache: 24240 total in 2 blocks; 3744 free (0 chunks); 20496
used
TopTransactionContext: 57344 total in 3 blocks; 21280
Hi,
On 16/06/2014 14:15, Andres Freund wrote:
Hi,
On 2014-06-16 13:56:23 +0100, Bruce McAlister wrote:
[1] 3 x ESX VM's
[a] 8 vCPU's each
[b] 16GB memory each
# Dont hand out more memory than neccesary
vm.overcommit_memory = 2
So you ha
be greatly appreciated :)
Reference:
https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Linux/6/html/Performance_Tuning_Guide/s-memory-captun.html
Thanks
Bruce
On 16/06/2014 14:21, Bruce McAlister wrote:
Hi,
On 16/06/2014 14:15, Andres Freund wrote:
Hi,
On 2014-06-16 13:5
g_upgrade for this, as I
think they already use it for major release upgrades. Adrian is right,
though, that you might just need to run pg_upgrade manually.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their o
ook into
> the code of postgress easily.
>
>
>
>
> You can get help from http://doxygen.postgresql.org/
>
> You can look in optimizer/path for looking at how current join paths are
> generated.
Also see the Developer FAQ:
http://wiki.postgresql.org/wik
oming late to this thread, but it seems easier for the user to set
archive_command to something meaningful during start/stop backup, and
set it to /bin/true at other times. I realize they can't turn
archive_mode on/off without a restart.
--
Bruce Momjian http://momjian.us
Enterpris
I don't think that there is any way for initdb to
> safely figure out what is going on just based on the outcome of some timing
> tests. The person who purchased the hardware has to apply their knowledge.
TODO item removed.
--
Bruce Momjian http://momjian.us
Enterprise
dditionally, if
> the
> slave becomes master, the "corrupt" indexes will in cases be unable to enforce
> uniqueness, but quietly allow duplicate values.
No surprise; I have been expecting to hear about such breakage, and am
surprised we hear about it so rarely. We really have
e _after_ the
* subprocess has completed, so we do this only when writing from a
* non-primary thread. fflush(), running system() twice, and pre-creating
* the file do not see to help.
I think that returns a "share violation" error.
--
Bruce Momjian http://mom
rders WHERE i_order <> sort_order;
>
> This method is really slow on a big table, and I'm not going to promise it
> always works, but that is how we found the root cause.
We could walk the index looking for inconsistent btree splits, e.g. the
split doesn't match the or
g from a
> * non-primary thread. fflush(), running system() twice, and pre-creating
> * the file do not see to help.
>
> I think that returns a "share violation" error.
I have applied the attached patch for 9.5 which will generate a clearer
error in this case, attache
en we switch to the hot standby level to support a hot
> standby, then go back to the archive level, all while uploading WAL logs to
> the
> same location. Would PostgreSQL be able to do PITR over this entire span of
> time?
Yes, PITR needs any wal_level other than "minimal".
but I am glad it is showing a benefit.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
htt
m strings for usernames and
database names.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
red in GMT,
you might be able to just change the system catalogs to say timestamp
with time zone. I recommend you find a PG expert to research this and
test it.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their
nly option, like geometry and perhaps range (shared with SP-GiST).
With the 9.4 GIN improvements I am unclear if GiST is ever better for
full text indexing compared to GIN.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyon
On Mon, Dec 8, 2014 at 04:56:00PM +0530, bln prasad wrote:
> Hi,
> Is there any way to update single/multiple fields of JSON document of a
> column?
No, not yet. We are thinking of options but don't have any work in
progress.
--
Bruce Momjian http://momjian.us
n do
lookups on them independently, like 'c'? I was not aware that works,
but it might. I know it doesn't work for traditional btree as the index
is hierarchical. You can look up things like a,c and it will skip over
'b', but doing 'c' alone doesn'
he command-line to
find the objects represented by files?
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Fri, Dec 12, 2014 at 09:42:48AM -0500, Peter Eisentraut wrote:
> On 12/12/14 9:25 AM, Bruce Momjian wrote:
> > On Fri, Dec 12, 2014 at 09:18:53AM -0500, Peter Eisentraut wrote:
> >> pgsql-hackers are discussing some housekeeping in contrib.
> >>
> >&g
what the
> difference was between oid and relfilenode.
The fact oid2name is called that, but references relfilenode, doesn't
help my memory either. ;-)
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has the
gt; or
Yes.
> backup+archived logs, for example)?
There is no way to _fix_ the torn page, but you can ignore the error
with ignore_checksum_failure:
http://www.postgresql.org/docs/9.4/static/runtime-config-developer.html
--
Bruce Momjian http://momjian.us
Enterp
On Fri, Dec 26, 2014 at 04:07:11PM -0500, Bruce Momjian wrote:
> On Fri, Dec 26, 2014 at 01:11:57PM +0300, Borodin Vladimir wrote:
> > Hi all.
> >
> > I ve read thread [0], src/backend/storage/page/README and everything I
> > found in
> > the documentation abo
at all?
http://www.postgresql.org/message-id/flat/CAEB4t-OHNE95=n5u4yssykwipqswequtbsjkayj63_1vzkz...@mail.gmail.com#CAEB4t-OHNE95=n5u4yssykwipqswequtbsjkayj63_1vzkz...@mail.gmail.com
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+
ata" -o "-p 50432 -b " start >>
> "pg_upgrade_server_start.log" 2>&1
> Access is denied.
> waiting for server to start stopped waiting
Yep, that's the problem all right. The question is why is it failing?
--
Bruce Momjian http:
On Thu, Jan 22, 2015 at 10:46:50AM -0800, Igal @ getRailo.org wrote:
> Bruce,
>
> On 1/22/2015 10:38 AM, Bruce Momjian wrote:
> > On Thu, Jan 22, 2015 at 10:30:44AM -0800, Igal @ getRailo.org wrote:
> >>
> >> pg_upgrade_server_start.log contains the following:
>
/CAEB4t-OHNE95=n5u4yssykwipqswequtbsjkayj63_1vzkz...@mail.gmail.com#CAEB4t-OHNE95=n5u4yssykwipqswequtbsjkayj63_1vzkz...@mail.gmail.com
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-g
y.
>
> thank you all for your help.
That URL I just emailed you explains the cause.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-general mailing list (pgsql-general@
ay, thanks for your help, Magnus.
Clarification doc patch attached and applied.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
diff --git a/doc/src/sgml/libpq.sgml b/doc/src/sgml/libpq.sgml
new file m
2"
will be truncated to
"x11"
ERROR: column
"x11" specified
more than once
--
Bruce Momjian http://momjian.u
> a conenction.
>
> So my question is if this is supported by libpq? Is it possible to use it in
> more than one thread and make connections at the same time?
Each connection can be created and accessed from only one thread.
--
Bruce Momjian http:
vity.procpid is renamed
> as pg_stat_activity.pid.
> http://www.postgresql.org/docs/9.2/interactive/release-9-2.html
Yes. Pg_upgrade doesn't know about renamed system columns, so if you
had a view that referenced a renamed column, pg_upgrade wouldn't know
about that until it tried to restore
support, and if so,
are you willing to accept frequent updates and breakage as the bugs are
fixed?
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-general
pall, which
> you bypassed (for databases anyway).
>
> There's been some discussion of refactoring these responsibilities,
> but no consensus.
pg_upgrade fixed this for pg_dumpall -g --binary-upgrade by outputing
the per-database settings.
Isn't this a bug? Seems there
ents are invalid or do not match
> Failure, exiting
OK, sure. Run this on the old and new clusters:
$ pg_controldata /u/pg/data.old
$ pg_controldata /u/pg/data.new
You will see a mismatch here:
Maximum data alignment: 8
On Wed, Jan 16, 2013 at 06:47:12PM -0800, Charles Porter wrote:
> Bruce -
>
> Yep. That's it. Thank you
>
> Maximum data alignment: 4
> Maximum data alignment: 8
>
> There are several differences, including TOAST chunk 2000 vs 1996.
&
r than C? I thought we had optimized PL/pgSQL to
save parsed functions, but I don't see how that would help with queries,
which use SPI. Am I missing something?
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's
;
> Is there a turnover ?
>
> PG 8.4, Windows XP
This must be a mismatch between your operating system encoding and your
database encoding.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everythin
ster lock files.
I am guessing there is something non-standard about your old cluster,
and 8.4's pg_ctl -w can't handle it. Tell me what is non-standard and I
can help further. Another idea is to make the old cluster use defaults
for everything and do the upgrade.
--
Bruce Momjian
to use GPUs with
> postgresql, and I'm quite interested in giving this a try, unless I'm missing
> something.
I think it would be fine. I expect to be researching this soon myself:
http://wiki.postgresql.org/wiki/Parallel_Query_Execution
Let me know
On Mon, Feb 18, 2013 at 02:51:13PM +, Seref Arikan wrote:
> Thanks Bruce,
> I too think that it should be fine, as long as I make sure that the spawned
> threads do not call back to originating thread and they are properly
> terminated
> once they're finished etc.
>
thinking about
> sendinging the bytea through a protocol to a threaded processing
> server running outside of the database. More work and slower
> (protocol overhead), but much more robust.
You can see the approach of not calling any PG-specific routines from
theads here:
http://
ime? Like a waiting
> queue in my code?
Is this from the client code? That is easy from libpq using
asynchronous queries.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
On Mon, Feb 18, 2013 at 10:46:39PM +0530, Atri Sharma wrote:
>
>
> Sent from my iPad
>
> On 18-Feb-2013, at 22:38, Bruce Momjian wrote:
>
> > On Mon, Feb 18, 2013 at 10:33:26PM +0530, Atri Sharma wrote:
> >>>> While your threads are executing, your qu
ynchronisation mechanism for
> server side code? A kind of construct which would be the standard way to
> manage synchronisation ? I was thinking of something on the lines of a
> monitor.
You would use the standard methods, semaphores for processes, thread
locks for threads.
--
Bruce
t the simple authentication issue which I thought was at the
> heart of this concern. Is there anything there that you see as being an
> issue with what we're doing currently..?
I too am worried that make SSL even more flexible will make simple setups
more complex to setup.
--
Bru
> of
> the clients. But does anyone know if CVE-2013-1899 allows an arbitrary
> attacker
> to use the exploits described in [1]?
Yes, if you were running 9.0+. pg_hba.conf does not limit access
sufficiently, though listen_addresses does.
> We are using PostgreSQL 8.4.
8.4 does not
e. But I have no idea what the cause of the issue is and
> how to find out I’m vulnerable or not.
>
>
>
> How can I get that?
Why don't you tell use that the release note item is and we can help
you? Your only other option is to read the git commits for that
release.
--
to that.
Use SET log_statment='all' and look in the server logs for the query.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-general mai
per bound on
> database size and if so, what it is?
Well, anything over hundreds of gigabytes is going to require tuning,
and above a terrabyte is going to require partitioning. There isn't a
hard limit, but we don't see many serves over tens of terrabytes.
--
Bruce Momjian
you
can use the simple "port" server-side variable for this; does this help
you?
test=> SELECT setting FROM pg_settings WHERE name = 'port';
setting
-
5432
(1 row)
--
Bruce Momjian http://momjian.us
EnterpriseD
t. This is in a C module, I suppose I
> could run a query but there has to be a direct C function to get this data.
Well, you could look at how to access the PostPortNumber global
variable.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterp
On Wed, May 8, 2013 at 05:05:05PM -0400, Ray Stell wrote:
> A minor detail in 9.2.4, but I noticed that the pg_upgrade flag for
> superuser, -u, does not get carried to a -U flag on the vacuumdb commands
> written to analyze_new_cluster.sh.
OK, let me look at this issue.
--
Bruc
ter because other
* defined users might match users defined in the old cluster and
* generate an error during pg_dump restore.
Let me know what you find in case I can improve the error message.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterpr
On Wed, May 8, 2013 at 08:52:40PM -0400, Bruce Momjian wrote:
> On Wed, May 8, 2013 at 05:05:05PM -0400, Ray Stell wrote:
> > A minor detail in 9.2.4, but I noticed that the pg_upgrade flag for
> > superuser, -u, does not get carried to a -U flag on the vacuumdb commands
, which affects more than just functions.
OK, attached release note patch applied.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
diff --git a/doc/src/sgml/release-9.3.sgml b/doc/s
stem. See pg_upgrade
--help for a full list of options.
So, no, you don't get a mess if the upgrade fails in the middle, even in
link mode, but you would be in trouble if you started the new server and
wanted to revert to the old server.
--
Bruce Momjian http://
On Wed, May 29, 2013 at 09:42:12AM -0400, Peter Eisentraut wrote:
> On 5/21/13 2:41 PM, Bruce Momjian wrote:
> > I have thought about this and there are potentially several options
> > specified to pg_upgrade that could be passed into scripts:
> >
> > -O, --new-opti
de to postgresql version 9.2."
You have to use the pg_upgrade version that matches the new server
version. I am confused by your report if you are upgrading to 9.0 or
9.2.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+
pgraded
> database? Can this be done while the database is live?
Sure, you can run it anytime. Until you run it your large object
permissions might not be accurate.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It'
On Mon, Jun 24, 2013 at 08:51:46AM -0400, Bruce Momjian wrote:
> On Mon, Jun 24, 2013 at 11:13:08AM +, Stuart Ford wrote:
> > Dear community
> >
> > Last week we upgraded our database from 8.4 to 9.1. The upgrade seemed to
> > go fine and the database seems to
On Mon, Jun 24, 2013 at 03:25:44PM +, Stuart Ford wrote:
> On 24/06/2013 14:00, "Bruce Momjian" wrote:
>
>
> >
> >Looking further, here is the command that is executed:
> >
> > SELECT pg_catalog.lo_create(t.loid)
> > FROM (SELECT D
On Mon, Jun 24, 2013 at 06:03:40PM +, Stuart Ford wrote:
> On 24/06/2013 17:18, "Bruce Momjian" wrote:
>
>
> >On Mon, Jun 24, 2013 at 03:25:44PM +, Stuart Ford wrote:
> >> On 24/06/2013 14:00, "Bruce Momjian" wrote:
> >>
> >&
2f81f580d9d006ef1
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
htt
into the
> database. I was hoping there was some known way of doing that to save me the
> time it takes to patch Postgres to do that.
There is no way to decode the WAL data as the decoding information is in
the database and not easily available to an external tool.
-
, the more
> likely it is to have bugs ...
Just to give the 10k mile answer, the WAL contains all database changes
that _might_ be lost due to file system changes during a base backup.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterpris
t decided to return fractional days, that would blow up.
>
>
> If integers are guaranteed, might I suggest to change the
> documentation to read
>
>
> J Chronological Julian Day (integer number of days since November 24,
> 4714 BC at midnight)
Done and backpatch
p://www.postgresql.org/developer/backend/
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
On Sat, Aug 10, 2013 at 09:52:48PM +0200, Stefan Kaltenbrunner wrote:
> On 08/10/2013 04:21 PM, Bruce Momjian wrote:
> > On Sat, Aug 10, 2013 at 06:38:57AM +, Arvind Singh wrote:
> >> as you can see it is for a single record "login88193" it places
> >&
EADER option. ]
We assume CSV is going to be read into a tool that can use the header
names; delimited files don't usually have a use for those headers.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's
On Mon, Aug 12, 2013 at 03:17:00PM -0700, Jeff Janes wrote:
> On Mon, Aug 12, 2013 at 2:21 PM, Bruce Momjian wrote:
> > On Mon, Aug 12, 2013 at 02:15:25PM -0700, Joe Van Dyk wrote:
> >> Mostly just curious, as this is preventing me from using tab-separated
> >> output
cluded too). In documentation it is said that
> typlen of -1 or -2 means that type is variable length, but I don't
> know how to find out if type can have additional precision?
Try psql -E, and run the \dT command to see the query it uses.
--
Bruce Momjian http://momjian.u
On Thu, Aug 15, 2013 at 09:25:07AM +0100, Richard Huxton wrote:
> On 12/08/13 23:18, Bruce Momjian wrote:
> >On Mon, Aug 12, 2013 at 03:17:00PM -0700, Jeff Janes wrote:
> >>On Mon, Aug 12, 2013 at 2:21 PM, Bruce Momjian wrote:
> >>>On Mon, Aug 12, 2013 at 02:15
On Thu, Aug 15, 2013 at 11:33:42AM +0200, Ivan Radovanovic wrote:
> On 08/15/13 05:23, Michael Paquier napisa:
> >On Thu, Aug 15, 2013 at 6:00 AM, Bruce Momjian wrote:
> >>Try psql -E, and run the \dT command to see the query it uses.
> >You have also the following comman
k the certificates as CAs so they are passed
from the server to the client. You are looking for the CA certificates
to say:
X509v3 Basic Constraints:
CA:TRUE
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
On Tue, Feb 28, 2017 at 10:50:02PM +0100, Frazer McLean wrote:
> On 28 Feb 2017, at 21:51, Bruce Momjian wrote:
> >I have researched this and will post a blog and and document the fix in
> >the next few months. The reason you have to supply the entire
> >certificate chain
with the rest of the world, and not have to deal
> with replies to topics that I don't care about anyway.
You might want to look at PgLife, which gives you a read-only view of
what's currently happening in the Postgres community:
http://pglife.momjian.us/
; elasticsearch in front of our datasource right now.
Full text search of JSON and JSONB data is coming in Postgres 10, which
is to to be released in September of this year:
https://www.depesz.com/2017/04/04/waiting-for-postgresql-10-full-text-search-support-for-json-and-jsonb/
--
Bru
201 - 300 of 2119 matches
Mail list logo
