Hi Adrian,
> First match wins loses in this case. The entries are processed top to
> bottom the first the one matches in this case:
>
> local all all peer
>
> Per
This answers my question. Thanks for the help,
--
Chris.
e everything matches all/all.
> There is no way to give a user a choice of how to authenticate. There will be
> one accepted option for a given set of connection values.
This answers my question. Thanks for the help,
--
Chris.
failed for user "postgres"
Notice I am failing “peer” authentication. Seems to me that if I explicitly ask
for a password, “-W”, I should be using “md5” authentication.
Can anybody straighten me out?
Thanks for the help,
--
Chris.
On Tue, Aug 27, 2024, 5:09 AM Chris Travers wrote:
> This message is being sent from the Community Code of Conduct Committee,
> with the approval of the Core Team.
>
> As part of the Community CoC policy, the Committee membership is to be
> refreshed on an annual basis. We are
to tell us about yourself that is helpful for us
to know about your potential involvement with the CoC Committee?
Please be sure to send your reply to the CoC email listed above. Thank you!
Regards,
Chris Travers
Acting Chair
PostgreSQL Community Code of Conduct Committee
Abramova, Sergei Kim, Simon Pain, and Chris Travers currently sit
on the committee.
Chris Travers is currently acting as chair.
More information about those on the committee can be found at the above
link.
Best Wishes,
Chris Travers
Interim Chair, Code of Conduct Committee
ion is to require a password plus
clientcert=sameuser. This allows you to authorize devices/user accounts
for specific remote database connections and provides that second factor --
i.e. something you have as well as something you know.
>
>
> Regards
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
time commitment
irequirements are not set. Any amount of help is welcome no matter how
small.
Is anyone interested in helping out?
Best Wishes,
Chris Travers
On Fri, 2 Feb 2024 at 13:20, Chris Angelico wrote:
> create or replace function send_settings_notification() returns
> trigger language plpgsql as $$begin perform
> pg_notify('stillebot.settings', ''); return null; end$$;
> create trigger settin
After various iterations of logical on PG 15, I bit the bullet and
installed PG 16. (Using the bookworm-pgdg repository.) Turns out, that
basically solved all the problems I'd been having previously - yay!
Got a bit of a curveball thrown at me though. I have a singleton
settings table (see other t
On Mon, 22 Jan 2024 at 05:50, Chris Angelico wrote:
>
> On Mon, 22 Jan 2024 at 05:25, Justin wrote:
> > Adding a primary key will fix this issue. Note PG 16 can use indexes to
> > find qualifying rows when a table's replica is set to full.
>
> I'll try dro
On Mon, 22 Jan 2024 at 05:25, Justin wrote:
>
> When using replica set to full this kicks off a full table scan for each
> update or delete this is very expensive. If there are no errors being
> reported you will find it is working but hung doing full scans. Inserts are
> just appended to e
PostgreSQL 15 on Debian, both ends of replication.
I'm doing logical replication in a bit of a complex setup. Not sure
how much of this is relevant so I'll give you a lot of detail; sorry
if a lot of this is just noise.
* Bidirectional alternating-master replication. Since I'm still on PG
15, the
uldn't prune.
>
Was there a datatype issue here? Like having a partition key of type
timestamp, but the query casting from date?
>
> When I departitioned the tables, performance became acceptable.
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
eneral approach is to COPY FROM STDIN and then use pg_putcopydata for
each row, and finally pg_putcopyend to close out this. It's not too
different from what psql does in the background.
>
>
> --
>
> Bien à vous, Vincent Veyron
>
&g
On Thu, Nov 30, 2023 at 9:03 AM Abdul Qoyyuum
wrote:
> Hi Chris,
>
> On Wed, Nov 29, 2023 at 7:38 PM Chris Travers
> wrote:
>
>>
>>
>> On Wed, Nov 29, 2023 at 4:36 PM Abdul Qoyyuum
>> wrote:
>>
>>> Hi all,
>>>
>>> Knowi
ndicators.
However, once these errors start happening, you are in danger territory and
need to find out why (and correct the underlying problem) before you get
data loss.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
Hi everyone,
Does anyone here know if the default PostgreSQL images set NUMA policies?
I am assuming not? Is there an easy way to make them do this?
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
between myself and the audience.
Slides should be a mnemonic device for you as a speaker and for the
audience later, not a source of direct information except when you need a
visual exploration and then the images are helpful.
>
>
> HTH,
>
> SteveT
>
> Steve Litt
>
> Autumn 2023 featured book: Rapid Learning for the 21st Century
> http://www.troubleshooters.com/rl21
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
e other reasons to rewrite but it really depends on a
lot of factors.
>
> Yours,
> Laurenz Albe
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
t;
>
>
>
>
> best regards,
> Ilya Kosmodemiansky,
> CEO, Data Egret GmbH
> Herrenstr. 1 A 2,
> Spiesen-Elversberg, Germany
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
Suddenly everything becomes clear: I'm running an OS that reached EOL 3 months
ago. I'll upgrade to Ubuntu 20 if I need to get it working on this computer.
Thanks.
On Saturday, September 23, 2023 at 02:15:19 PM PDT,
wrote:
Am 23.09.23 um 20:56 schrieb Chris Kelly:
&g
be
verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29".
On Friday, September 22, 2023 at 02:38:24 PM PDT, Ray O'Donnell
wrote:
On 22 September 2023 21:40:38 Chris Kelly wrote:
The need has mostly passed (I used another computer with Ubuntu
The need has mostly passed (I used another computer with Ubuntu 20) but are
there clear, *working* instructions for how to connect to Postgress on Ubuntu
18 via PDO? I don't see drivers that would work. This is for a Drupal site.
creating all
the partitions you expect even if they are empty, and seeing how long
EXPLAIN takes to run. If that's good enough, then go for it. If it is too
long then you could pre-calculate what partition to hit or you could use
fewer partitions.
>
> Thanks.
>
>
--
Best Wishes
up
>> pg_dumpall --globals-only > globals.sql
>>
>
> What is the relevance of globals-only and what this will do ${DB}.log
> // or is it ${DB}.sql ?
>
> pg_dump --format=d --verbose --jobs=$THREADS $DB &> ${DB}.log // .log
>> couldn't get an idea what it mean
>>
>> If you're 100% positive that the system you might someday restore to is
>> *exactly* the same distro & version, and Postgresql major version, then
>> I'd use PgBackRest.
>>
>> --
>> Born in Arizona, moved to Babylonia.
>>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
stgresql
> > password to the same password at once.
>
> To the same value??
>
> --
> Born in Arizona, moved to Babylonia.
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Fri, Jun 2, 2023, 09:36 Oliver Kohll wrote:
> Hi,
>
> Just wondering, does anyone else create apps which might not have 'big'
> data, but quite complex arrangements of views joining to each other?
>
> If so, do you have scripts to aid refactoring them e.g. drop/recreate/test
> them in the righ
The latest entry is at:
https://www.timescale.com/blog/a-postgresql-developers-perspective-five-interesting-patches-from-januarys-commitfest/?utm_source=timescaledb&utm_medium=linkedin&utm_campaign=mar-2023-advocacy&utm_content=tsdb-blog
--
Best Wishes,
Chris Travers
Hello list
I'm pondering migrating an FTS application from Solr to Postgres, just
because we use Postgres for everything else.
The application is basically fgrep with a web frontend. However the
indexed documents are very computer network specific and contain a lot
of hyphenated hostnames wi
Hi,
Ive created a read only user (SELECT PRIVILEGE) but it turns out that this
user can do this queries: SHOW work_mem; SET work_mem='40MB'; How do I
limit him?
Thanks,
Butching
I fixed it by editing the postgresql-14.service PGDATA path to the new
directory
Thanks,
butching
On Mon, Oct 24, 2022 at 7:25 PM chris navarroza
wrote:
> But I'm using a different path when I initdb /usr/pgsql-14/bin/initdb -D
> */home/dmartuser/pgsql/14/data
> *so "/va
But I'm using a different path when I initdb /usr/pgsql-14/bin/initdb
-D */home/dmartuser/pgsql/14/data
*so "/var/lib/pgsql/14/data/" is really empty. Is there a way to point the
startup script to the new path */home/dmartuser/pgsql/14/data* ?
Thanks,
Chris Albert Navarr
us=1
Oct 24 15:16:45 datamartds systemd[1]: postgresql-14.service: Failed with
result 'exit-code'.
How can I point the service to read the new path (
/home/dmartuser/pgsql/14/data )?
Thanks,
Chris Albert Navarroza
Information Technology Officer I
CTCO - ITDS - RDMD
4), 64-bit
2022-10-24 07:41:13.460 PST [107444] LOG: listening on Unix socket
"/tmp/.s.PGSQL.50432"
2022-10-24 07:41:13.486 PST [107444] LOG: redirecting log output to
logging collector process
2022-10-24 07:41:13.486 PST [107444] HINT: Future log output will appear
in directory "lo
sses=''
-c unix_socket_permissions=0700 -c unix_socket_directories='/tmp'" start
Failure, exiting
Thanks,
Chris Albert Navarroza
Information Technology Officer I
CTCO - ITDS - RDMD
On Fri, Oct 21, 2022 at 10:08 PM Tom Lane wrote:
> chris navarroza writes:
>
Hi,
I have a postgresql server version 12.9 and trying to upgrade it to 14.5.
My OS is Centos 8 Stream and I already managed to install postgresql14.5
but when I'm trying to upgrade, I am encountering this error
bash-4.4$ /usr/pgsql-14/bin/pg_upgrade
--old-datadir=/home/dmartuser/pgdata/data/
--n
CCESS
SHARED locks have to be taken on all tables as well as all associated
resources (indexes, sequences, etc.) and the act of taking and
releasing all of those locks will increase the lock contention
significantly. We're working to update our application so that we can
take advantage of the pruning. Are you also using native partitioning?
- Chris
On Wed, Apr 6, 2022 at 6:31 PM Adrian Klaver
wrote:
> On 4/6/22 3:28 PM, Chris Bisnett wrote:
> > On Wed, Apr 6, 2022 at 6:24 PM Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote:
>
> >
> > It can:
> >
> >
> https://www.p
On Wed, Apr 6, 2022 at 6:24 PM Adrian Klaver
wrote:
> On 4/6/22 3:13 PM, Chris Bisnett wrote:
> > Hi all!
> >
> > I have several large tables (1-2Tb) that are 99.9% writes (small number
> > of updates) with a decent commit rate (20K/sec). The basic idea is that
> &
this would cause decreased performance when used with
tables with a lot of writes and deletes. Is there a technical reason this
setting cannot be applied at the database or table context like other
autovacuum settings?
- chris
o just roll their
own solutions.
>
> > Trying to write documentation on how to develop a complete solution
> > would be quite an effort and would certainly go beyond bash scripting
> > and likely wouldn't end up getting used anyway- those who are developing
> > such s
,
Chris
On 14/05/2020 21:11, Chris Withers
wrote:
Hi,
I'm upgrading a database from 9.4 to 11.5 by dumping from the
old cluster and loading into the new cluster.
The database is tiny: around 2.3G, but importing this table is
pr
Which version? Active session should be green.
Regards,
Chris
On 11/11/2021 21:24，Shaozhong SHI wrote：
I never came across this before and wonder why?
Regards,
David
n the picture. And there are
other areas of complexity, such as how you handle partial page writes.
On the whole I think for small dbs it might perform well enough. On large
or high velocity dbs I think you will have more problems than expected.
Having worked with PostgreSQL on ZFS I wouldn't
, but
I'm unsure how much their regular Postgres offering differs, if at all.
Thanks,
Chris
On Mon, Oct 18, 2021 at 8:05 PM Tom Lane wrote:
> Chris Williams writes:
> > We have a script that runs a pg_dump off of an RDS PG13.3 replica several
> > times per day. We then load t
. I've also opened a ticket with
AWS's support to see if they have any ideas. For now, we've had to go back
to using the single threaded pg_dump (which is disappointing because it's
25 minutes slower). We were really hoping to take advantage of the
parallelism.
Any ideas would be much appreciated.
Thanks,
Chris
ght true for Sybase, but I've never done a
> detailed comparison.
>
Indeed. MongoDB has some interesting features like capped collections
which make it useful as a cache, but my experience always leaves me feeling
like performance and scalability are lacking.
>
>
> Cheers,
> Gav
rther. Kind regards, James
>
If you are posting here, is it because they want to move all these to
PostgreSQL?
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
I had to install pam-devel before reinstalling pgbouncer. appears to be
working now. thanks for pointing me in the right direction Laurenz!
On Wed, Apr 28, 2021 at 7:09 AM Chris Stephens
wrote:
> huh. you are right. i originally installed pgbouncer with yum but removed
> with just "
arting up. any
suggestions on how to completely remove and reinstall with support for pam?
On Wed, Apr 28, 2021 at 1:51 AM Laurenz Albe
wrote:
> On Tue, 2021-04-27 at 19:46 -0500, Chris Stephens wrote:
> > I'm trying to run pgbouncer but am having trouble with what looks like
I'm trying to run pgbouncer but am having trouble with what looks like a
very simple configuration.
centos 7
postgres 12
pgbouncer 1.15
we are already using pam for database auth. pgbouncer was compiled with
--with-pam. there is a /etc/pam.d/pgbouncer config file copied from the one
currently bei
I'm trying to create a visual representation of a 6x8 grid of samples on a
rack using the following SQL format:
with rack_display as (
select sr.ts rack_ts
, sr.rack_id
, r.rack_barcode
, 1 as row_pos
, max(case when rack_well = 0 then 'A1: '||sample_barcode end
ck plan to use
excel with pages linked to views in the database but i'm looking for
something a little more targeted.
does anyone have any suggestions that fit the description above?
thanks for any input,
chris
null
Cheers,
Chris Sterritt
alter column loc_nbr drop constraint
unique;' also
failed.
What's the proper syntax to drop the unique constraint on a table column?
TIA,
Rich
You need
alter table locations drop constraint ;
Cheers, Chris Sterritt
n stays in bounds, or redesign your application.
In some cases it might help to restart your sessions when they get too
big, but that seems like at best a band-aid.
regards, tom lane
Would executing DISCARD ALL release the PL cache?
Regards, Chris Sterritt
posgresql verion: 12
i can accomplish this procedurally fairly easily but would like to do this
strictly in SQL.
jsondb=# select jsonb_typeof(jsonb_path_query(vdl_json,'$.tables[*]')) from
vdl_json2;
jsonb_typeof
--
object
object
object
object
object
object
(6 rows)
jsondb=# s
s more something like delete+insert). So even if
the value of the column doesn't change, its tuple location changes, so
the index needs to be updated to reflect that change.
--
Guillaume.
If you execute
vacuum full plop;
you will see the size shrink back as the dead tuples will have been removed.
Chris
s.station_id,sd.ameasurement from src_data sd join (SELECT
station_id,station_data FROM ins_station UNION SELECT station_id,station_data
FROM station)s using (station_data)
except select station_id,ameasurement from measurement;
select * from station;
select * from measurement;
Regards,
Chris Sterritt
2meas1');
Now if you repeat the check for new measurements with the same query as at *,
you only get 3 rows.
Cheers, Chris Sterritt
e basically immutable.
>
> --
> Scott Ribe
> scott_r...@elevated-dev.com
> https://www.linkedin.com/in/scottribe/
>
>
>
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
lue from, say, 100 IDR to 100 EUR at least for
display purposes.
I have some thoughts about how to do a multi-currency type but I am not
actually sure you get anything by tying the data together instead of having
it in separate columns.
>
> cheers,
> raf
>
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
shot
(:
Best Regards
Chris
On Fri, Aug 7, 2020 at 4:22 PM Christoph Moench-Tegeder
wrote:
> ## Chris Borckholder (chris.borckhol...@bitpanda.com):
>
> > We are experiencing a strange situation with an AWS Aurora postgres
> > instance.
>
> The main problem here is that &quo
Thanks for your insight!
I cannot find any errors related to archiving in the logs that are
accessible to me.
It's definitely something that I will forward to the support team of the
managed database.
Best Regards
Chris
On Thu, Aug 6, 2020 at 3:18 AM Mohamed Wael Khobalatte <
from
within postgres?
Best Regards
Chris
On Tue, Aug 4, 2020 at 11:39 AM Srinivasa T N wrote:
> There may be lot of wal files or the size of log files in pg_log might be
> huge. "du -sh *" of data directory holding the database might help.
>
> Regards,
> Seenu.
>
>
lsn).
Can you imagine other things that I could check from within postgres with
limited permissions to diagnose this?
Best Regards
Chris
in future releases?
Regards, Chris Sterritt
it looks like there are a number of roles available through ansible galaxy
that support initial postgresql setup and configuration.
i'm wondering if there are any that are more popular/capable that i should
consider vs just picking a few and evaluating those.
does anyone have any recommendations?
!
On Mon, Jun 8, 2020 at 7:41 PM Thomas Munro wrote:
> On Tue, Jun 9, 2020 at 9:05 AM Chris Stephens
> wrote:
> > hostsslall all 0.0.0.0/0 ldap
> ldapserver="ldaps://xxx" ldapbasedn="yyy" ldaptls=1
>
> > does
posgresql 12
centos 7
i am trying to configure ldap authentication.
i have the following pg_hba.conf entry (server and basedn are correct but
not shown):
hostsslall all 0.0.0.0/0 ldap
ldapserver="ldaps://xxx" ldapbasedn="yyy" ldaptls=1
when i attempt to
high throughput systems (I have
systems where a db cluster generates 10-20TB of WAL per day)
So I am not at all sure this would be a step in the right direction or
worth the work.
>
> --
> Andreas Joseph Krogh
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
Ah, I do appear to have that enabled (inside Heroku's config), but I can't
find anything like that in the logs, so I've opened a ticket with them. Thx
a lot!
On Fri, May 29, 2020 at 2:25 PM Peter J. Holzer wrote:
> On 2020-05-29 12:42:47 -0500, Chris Morris wrote:
> >
We're using Heroku's PG, and it comes with a default, almost super-user.
I'm wanting to restrict that account for only our production app servers,
and have anyone connecting for personal queries to go through an assigned
role by employee (that's all setup and working).
Other than polling pg_stat_a
On 14/05/2020 21:31, Tom Lane wrote:
Chris Withers writes:
It has 4.1 million rows in it and while importing the data only
takes a couple of minutes, when I did a test load into the new
cluster, building the mkt_profile_period_col1_col4_col2_chan_excl
index for the
On 14/05/2020 21:16, k...@rice.edu wrote:
Hi Chris,
This sounds like a candidate for pg_logical replicating from the old to
new system.
Can you point me to a good guide as to how to easily set this up for one
database and would work between pg 9.4 and pg 11.5?
cheers,
Chris
nything, am I getting badly wrong here?
- what can I do to speed up creation of this index?
- failing that, what can I do to import and then create the index
in the background?
As you can imagine, a 15hr outage for an upgrade has not met with
large amounts of happiness from the people whose application it is
;-)
Chris
as another Oracle DBA trying to pick up Postgresql one thing i haven't come
across are script libraries such as there are for Oracle (
https://github.com/tanelpoder/tpt-oracle and
https://oracle-base.com/dba/scripts as examples).
Does anything like that exist for PG? Would be nice to see how peopl
On Thu, Apr 16, 2020 at 10:47 AM Michael Lewis wrote:
> My other thought was to range partition by pixelID + brin index.
>
> I would expect brin index to be INSTEAD of partitioning. You didn't share
> buffer hits, which I expect were 100% on the subsequent explain analyze
> runs, but the
disastrous :)
Planning Time: 7.569 ms
Execution Time: 316969.474 ms
On Thu, Apr 16, 2020 at 9:23 AM Pavel Stehule
wrote:
>
>
> čt 16. 4. 2020 v 16:08 odesílatel Chris Stephens
> napsal:
>
>> PG12
>> RHEL 8
>>
>> I suspect there's little I can do
893183'::bigint))
-> Bitmap Index Scan on "IDX_DiaSource_htmId20"
Thx!
On Sat, Apr 11, 2020 at 11:55 PM Julien Rouhaud wrote:
> On Sun, Apr 12, 2020 at 6:51 AM Chris Morris
> wrote:
> >
> > I have a local script I've written that will scan a log of PG queries to
> extract out unique queries without any specific parameter data.
I have a local script I've written that will scan a log of PG queries to
extract out unique queries without any specific parameter data. For
example, if these 2 queries are actually run:
SELECT * FROM foo where bar = 1;
SELECT * FROM foo where bar = 2;
It will capture only:
SELECT * FROM foo whe
Right now my dbs are hosted by Heroku, so I doubt I have any control over
the dbs at that level.
Thanks for the idea though! :)
On Wed, Mar 25, 2020 at 12:04 PM Michael Lewis wrote:
> Chris,
> Does it actually need to be a different server and database, or would it
> be possibl
>
> Not yet.. There is ongoing work to make that happen though.
Glad to hear it. :) Thx.
>
> > Is it even possible to use PG partitioning across a Foreign Server?
> I am not certain what you mean, but you can have foreign tables as
> partitions
> of a partitioned table. The partitions won't be processed in parallel
> though.
I have a large, growing table, that I'd like to start part
Is it even possible to use PG partitioning across a Foreign Server?
On 07/02/2020 12:49, Chris Ellis wrote:
What's "too much" for max_connections? What happens when you set it to
high? What factors affect that number?
When sizing max_connections you need to trade off how many connections
your application will use at peak vs how much RAM a
Hi Chris
On Fri, 7 Feb 2020, 08:36 Chris Withers, wrote:
> Hi All,
>
> What's a sensible way to pick the number to use for max_connections?
>
Sensible in this context is some what variable. Each connection in
PostgreSQL will be allocated a backend process. These are not th
Monday and thinking about potential problems related to the
number of available connections.
What's "too much" for max_connections? What happens when you set it to
high? What factors affect that number?
cheers,
Chris
Moreno, thank you for all your help.
Following your instructions, I was able to recover my databases. All is
good.
Chris
On Wed, Feb 5, 2020 at 6:45 AM Moreno Andreo
wrote:
> Il 04/02/2020 21:18, Chris Charley ha scritto:
> > Hello Moreno
> >
> > Thanks for the reply!
&
I tried items you suggested (1-5), but could find no helpful info.
Thanks for your help and going the extra mile!
On Mon, Feb 3, 2020 at 4:23 PM Adrian Klaver
wrote:
> On 2/3/20 1:11 PM, Chris Charley wrote:
> > Hi
> >
> > The link you provided
> > (
> https:
; On 2/3/20 12:54 PM, Chris Charley wrote:
> > /What does the Windows system log show when you do this?/
> >
> > I don't know where to find this log (for Windows 10)
> >
>
> I'm not a Windows user, what I can do is point you at:
>
>
> https://www
*What does the Windows system log show when you do this?*
I don't know where to find this log (for Windows 10)
On Mon, Feb 3, 2020 at 3:47 PM Adrian Klaver
wrote:
> On 2/3/20 12:44 PM, Chris Charley wrote:
> Please reply to list also.
> Ccing list.
> > Adrian
> >
>
the left pane
and then it allows me to edit the SQL in the query pane.
Thank you for any help you may provide.
Chris
On 05/11/2019 22:54, Adrian Klaver wrote:
On 11/5/19 2:46 PM, Chris Withers wrote:
Hi All,
Brazil recently abolished daylight savings time, resulting in updates
to system timezone information packages.
Does postgres use these? If so, does it need a reload or restart to
see the updated zone
would this be updated?
cheers,
Chris
nston <
david.g.johns...@gmail.com> wrote:
> On Wed, Oct 23, 2019 at 8:47 AM Chris Morris
> wrote:
>
>> The foreign table has a primary key. Ruby on Rails uses a system query to
>> lookup what the primary key on the table is, but it's querying the local
>> database,
The foreign table has a primary key. Ruby on Rails uses a system query to
lookup what the primary key on the table is, but it's querying the local
database, and not finding anything. In a schema dump of the local database,
I don't see a primary key defined, so I'm presuming I need to issue an ADD
C
I'm looking for a system query that will lookup the primary key column on a
fdw table. It's possible we need to declare that part of the foreign
table's schema in the local (is that the right term?) database?
Here's the foreign table - I don't see anything showing a primary key, so
my hunch is we
1 - 100 of 194 matches
Mail list logo
