acle
You're looking for help with an Ansible recipe, not with anything to do with
PostgreSQL itself.
Mentioning it here, in case someone already has one, is worth a try but you're
likely going to need to go talk to the Ansible people. Or write your own.
Cheers,
Steve
--
Se
;s support for the pgoutput logical
decoder in PG10, which might be a bit more robust to deal with than the
test_decoding one).
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
no longer supported https://github.com/confluentinc/bottledwater-pg
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ffort - libpq exists; you can call it from Chapel if you just declare the api,
I think.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rting and indexing properties.
>
> To "guarantee" uniqueness with a shared sequence or UUID generator,
> you can use a trigger to prevent override of identifiers from SQL. As
> long as you always use the correct value generator during INSERT and
> disallow mutation of identi
a, including any views, but won't
replicate DDL changes automatically after that. It does provide a clean way to
replicate DDL from the master to slaves with pglogical.replicate_ddl_command().
Cheers,
Steve
> > On Sep 6, 2017, at 6:00 AM, Marcin Giedz wrote:
> >
>
successfully
for years before moving to pglogical.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> On Sep 4, 2017, at 10:25 PM, Nico Williams wrote:
>
> On Mon, Sep 4, 2017 at 4:21 PM Steve Atkins wrote:
> >
>
> Me too.
>
> https://github.com/wttw/pgsidekick
>
> Select-based, sends periodic keep-alives to keep the connection open, outputs
> paylo
ayloads in a way that's friendly to pipe into xargs. (Also the bare bones of a
notify-based scheduler).
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi List,
I loaded 9.5 on CentOS 7 but by default every thing wants to use the default
9.2 version that comes with CentOS 7.
Is there a simple way to fix this so the 9.5 version of tools and libraries are
used.
Thanks,
Steve
--
Sent via pgsql-general mailing list (pgsql-general
of writing. The table is analyzed, to pg
should "know" that date1 <= "today" hence there is no data beyond today.
On similar - and more relevant lines the same query with a date range so as
above but "c.date1 >= '2017-08-01' and c.date1 <= '2017-08-10&#x
real database.
You could do an intermediate check by restoring into a real database with
--schema-only, I guess.
As an aside, pg_dump with custom format already compresses the dump with gzip,
so the additional gzip step may be redundant. You can set pg_dump's compression
level with -Z.
On Tue, Jul 11, 2017 at 9:51 PM, Steve Litt
wrote:
> Hi all,
>
> Please tell me this is a mistake:
>
> https://wiki.postgresql.org/wiki/Systemd
>
> Why a database system should care about how processes get started is
> beyond me. Systemd is an entangled mess that every
h language makes a query to it. Why
should Postgres care which init system started it? I hope you can free
Postgres of init-specific code, and if for some reason you can't do
that, at least don't recommend init-specific code.
Thanks,
SteveT
Steve Litt
July 2017 featured book: Quit Job
Exactly it!! I had changed that to 1000 also when we needed more.
Reduced that and it fixed it immediately.
Thank you!!
On 07/06/2017 11:00 AM, Melvin Davidson wrote:
On Thu, Jul 6, 2017 at 10:44 AM, Steve DeLong <mailto:sdel...@saucontech.com>> wrote:
I am running P
I am running Postgresql 9.3.15 and I am trying to reduce the amount of
wal files being recycled in pg_xlog. Archive is set up and working
correctly. A while ago we had problems with the streaming slave falling
behind because of hardware being slower and tuned postgres to keep over
1000k wal f
On 06/20/2017 10:38 AM, Adrian Klaver wrote:
> 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
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
nt to maintain
alerts and equipment to be monitored. Each piece of equipment has a unique unit
serial number so
the schedule would be tied to this unit serial no.
I would be very interested in what might be the best was to organize a
scheduling table(s) in postgresql.
Thanks in advance,
y path, so if the drive
is plugged in pg_ctl, psql etc go to the installation on the external
drive.
With one of the little samsung usb3 SSDs it'll fit in your pocket.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
guessing, but I'd assume because the NUMERIC type behaves as required by
the SQL spec, while float and double are vanilla IEEE754 arithmetic and will do
whatever the underlying hardware is configured to do, usually round to nearest
even.
Cheers,
Steve
--
Sent via pgsql-general maili
does execute, I wonder if the $ has any special meaning ?
>
> Can anyone shed some light please ?
No special meaning to postgresql - in postgresql a dollar sign is a valid
character in an identifier.
It might have some special meaning to the app that was using it, perhaps.
Cheers,
S
On Mon, May 8, 2017 at 2:26 PM, Paul Hughes wrote:
> Hello,
>
> I noticed that most of the largest web platforms that use PostgreSQL as
> their primary database, also use Python as their primary back-end language.
> Yet, according to every benchmark I could find over the last couple of
> years, b
ere's also pglater, which is a minimal external process that'll let you
implement any sort of cron-ish functionality entirely inside the database
without needing to be woken up every minute by an external cron.
https://github.com/wttw/pgsidekick
More proof-of-concept than anything remot
ntent is stored elsewhere, sure).
Use the right tool for the job.
Cheers,
Steve
>
> One question is "is it possible?", then next "is it feasible?"
>
> I think it would be great if I could use PG only and if I could
> avoid the other types of servers.
>
> T
ELECT example_a__rollup.bar_id FROM example_a__rollup)...
Or shortened with alises:
...(SELECT x.bar_id FROM example_a__rollup x)...
Cheers,
Steve
get:
foo_id | bar_id
+
3 | 4
5 | 6
If you add another record to example_a__rollup and run it and you will get:
ERROR: more than one row returned by a subquery used as an expression
Although the subquery won't work as an expression it would still work in a
the where clause but I doubt it will return what you desire.
Unfortunately there
are lots of ways to write syntactically correct but logically flawed
statements.
Cheers,
Steve
On 04/19/2017 11:57 AM, Jeff Janes wrote:
> On Wed, Apr 19, 2017 at 8:24 AM, Steve Clark <mailto:steve.cl...@netwolves.com>> wrote:
>
> Hello,
>
> I am confused. I have a table that has an incrementing primary key id.
>
> When I select max(id) from tab
Should add this is version 9.4.10 of postgresql
On 04/19/2017 11:24 AM, Steve Clark wrote:
> Hello,
>
> I am confused. I have a table that has an incrementing primary key id.
>
> When I select max(id) from table is returns almost instantly but
> when I select min(id) from tab
Hello,
I am confused. I have a table that has an incrementing primary key id.
When I select max(id) from table is returns almost instantly but
when I select min(id) from table it takes longer than I want to wait.
Shouldn't postgresql be able to quickly find the minimum id value in the index?
p
Please see below.
- Original Message -
From: "Nicolas Paris"
To: "Steve Petrie, P.Eng."
Cc:
Sent: Sunday, April 09, 2017 7:58 AM
Subject: Re: [GENERAL] TimeScaleDB -- Open Source Time Series Database
Released (www.i-programmer.info);
Le 09 avril 2017 à
-knowledgeable list participants
have thoughts on this TimeScaleDB project ??
Would there be merit in considering porting some TimeScaleDB
functionality into standard Postgres, as a response to NoSQL
"competition" ??
Best Regards,
Steve
* * *
Steve Petrie, P.Eng.
http://aspetrie.
just
to see if there's anything new? With mailing lists, the information
comes to you, instead of making you go out to it.
SteveT
Steve Litt
April 2017 featured book: Troubleshooting Techniques
of the Successful Technologist
http://www.troubleshooters.com/techniques
--
Sent
'UTC') AT TIME ZONE 'UTC';
timezone
---
2017-04-03 11:57:14.088515+01
(1 row)
This makes no sense to me.
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
On Wed, Mar 29, 2017 at 9:05 AM, Adrian Klaver
wrote:
> On 03/29/2017 08:49 AM, Steve Crawford wrote:
>
>> When firewalls/VPNs stand between my psql client and a remote PostgreSQL
>> server the connection will on occasion time out and drop. This results
>> in the followin
nd my coworkers could spend brain cycles trying to
unerringly remember to close and restart connections, write all queries in
an external editor and then submit them, etc. but I'm looking for more user
friendly options.
Cheers,
Steve
o write an essay, for which I'll provide the URL when it's finished.
Bottom line though, don't mess with success.
SteveT
Steve Litt
March 2017 featured book: Troubleshooting: Why Bother?
http://www.troubleshooters.com/twb
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
easy
> way to set up multiple "personalities" for connecting to different PostgreSQL
> servers. The password protection will deter the curious user from gaining
> access to your data. It will not stop a determined hacker, but the idea is to
> make it more difficult.
>
&g
astructure just
because those aren't replaced, yet.
Cheers,
Steve
On Sat, Mar 18, 2017 at 3:59 AM, Devrim Gündüz wrote:
>
> Hi,
>
> On Fri, 2017-03-17 at 12:15 -0700, Steve Crawford wrote:
> > The question remains - does anyone know where I might find packages so I
On Fri, Mar 17, 2017 at 11:35 AM, John R Pierce wrote:
> On 3/17/2017 11:07 AM, Steve Crawford wrote:
>
>> Where might I find yum repos PostgreSQL 9.6 on CentOS 5 (i386 & x86_64)?
>>
>> RHEL/CentOS 5 is still in production with extended support through 2020
>>
Where might I find yum repos PostgreSQL 9.6 on CentOS 5 (i386 & x86_64)?
RHEL/CentOS 5 is still in production with extended support through 2020 but
seems to be dropped from the 9.6 PGDG repos.
Cheers,
Steve
On 03/17/2017 10:14 AM, Adrian Klaver wrote:
> On 03/17/2017 06:58 AM, Steve Clark wrote:
>> On 03/17/2017 09:49 AM, Adrian Klaver wrote:
>>> On 03/17/2017 06:42 AM, Steve Clark wrote:
>>>> Hi List,
>>>>
>>>> I am running postgresql 8.4.20
On 03/17/2017 09:49 AM, Adrian Klaver wrote:
> On 03/17/2017 06:42 AM, Steve Clark wrote:
>> Hi List,
>>
>> I am running postgresql 8.4.20 on CentOS 6. Things have been running fine
>> for a long time
>> then I rebooted. Postgres came up but when I tried to c
psql looks for the socket?
Thanks,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
looking to do fast searches for "is this IP address in any of these
CIDR blocks" you might want to look at https://github.com/RhodiumToad/ip4r as a
possible alternative.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
n't running
out of connections more often. Perhaps there are per-database settings that
haven't been shown. We are also missing info on reserve_pool_timeout,
max_db_connections, etc. which could all play a role, here.
Cheers,
Steve
gt;
> Any ideas on how to proceed?
It looks like a DNS issue. That hostname authoritatively doesn't exist,
according to any of UW's nameservers.
If it works sometimes then you have some sort of internal name resolution hack,
and it's not reliable.
Cheers,
Steve
>
&
For my enlightenment, why use LATERAL here? I get the same result with a
simple CROSS JOIN (though overall I like the clever solution).
Cheers,
Steve
On Thu, Feb 16, 2017 at 12:11 AM, Alessandro Baggi <
alessandro.ba...@gmail.com> wrote:
> Il 15/02/2017 19:11, Alessandro Baggi h
ach step of the plan, so you can see
whether the planner estimates are reasonable or wildly off.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
tc/postgresql/9.4/main/postgresql.conf”
There's a suspicious hole between "exec" and "start" where I'd expect to see
the full path to the pg_ctl binary. As though a variable were unset in a script
or config file.
Cheers,
Steve
--
Sent via pgsql-general mailing list
t;
> I only can see that inserted row if I do the select outside of this
> transaction.
>
> How could I get that ?
This'd be the idiomatic way of doing it:
INSERT INTO test (name,description) VALUES ('test 1','testing insert')
RETURNING id;
Cheers,
hen
> take the 32 bit libpq and the 64 bit libpq and use lipo to
> glue them together and create a ‘fat’ libpq and replace the
> installed libpq?
>
> Is this a safe thing to do?
I've done it in the past (http://labs.wordtothewise.com/postgresql-osx/) and it
seemed to work f
se, that you are sure that your PHP script are the only things that can
connect - no scripts, backups, etc. are consuming connections.
But generally I'd advise using pg_bouncer or a similar pooler which can
deal with a mix of connections from persistent and non-persistent
connections from one or multiple hosts.
Cheers,
Steve
ing
your code with libpq and see if anything looks different.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
one, on the other hand, encapsulates the offset as it changes both
throughout the year and historically. It is almost always preferable to use
an actual timezone by specifying it by name as in Europe/London,
America/Los_Angeles, etc.
Cheers,
Steve
gt; this.
>
> you would write test cases for all the functionality provided by this
> extension, same as you'd test any other sort of API.
And you might find http://pgtap.org convenient for doing that.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
re
are useful defaults. If you omit the host name, psql will connect via a
Unix-domain socket to a server on the local host, or via TCP/IP to
localhost on machines that don't have Unix-domain sockets...."
Cheers,
Steve
On Wed, Jan 25, 2017 at 8:07 AM, Adrian Klaver
wrote:
> On 01/25/
hat does nothing, successfully, to a command that actually
archives logs just requires a reload. So this lets you enable archiving without
halting the server by changing the command.
Or that's how I vaguely recall it working some years ago. Things may have
changed now - you're following
using a pipe as the delimiter and double-quote as
the quote character but change all "ma" to "pa" and put into myoutput.txt
\o | sed s/ma/pa/g > myoutput.txt
copy (some query) to stdout csv header delimiter '|' quote '"';
\o
Cheers,
Steve
r
role. That's probably what you need.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
my_instance_of_template_table LIKE template_table;
CREATE TEMPORARY VIEW view_over_my_template_instance AS SELECT * FROM
my_instance_of_template_table;
There'd be a small amount of session startup overhead, but that could be
handled at the pooler level and amortized down to zero.
Cheers,
Steve
--
Sent via pgsq
rating the data in subsequent
steps. In that case, an ETL solution may be a better approach. Many
options, both open- closed- and hybrid-source exist.
Cheers,
Steve
(if I can't
get away with sql functions).
If you're trying to convince people to get the most out of their database,
pushing them towards pl/v8 as their first choice of embedded language might not
be the best path. (That it might encourage them to write code to iterate
through ta
On Tue, Dec 27, 2016 at 12:01 PM, Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> You could start here:
> http://www.softwaretestingmagazine.com/tools/open-source-test-data-
> generators/
>
> I have rolled my own on occasion by just pulling some public lists of most
You could start here:
http://www.softwaretestingmagazine.com/tools/open-source-test-data-generators/
I have rolled my own on occasion by just pulling some public lists of most
common given names and family names and toing a full-join. Same for city,
streets, etc.
-Steve
On Tue, Dec 27, 2016 at
vely so this effects notions of equality as well as collation. This
has implications for pg varchar(N) fields etc.
I would be interest to know what support pg has/will have for graphemes.
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rted data type.
Booleans aren't numeric.
https://www.postgresql.org/docs/9.5/static/datatype-boolean.html
Boolean will take a range of formats, including '0' - an untyped literal
"0". But it won't take an integer, which is what an unquoted 0 is.
You'll ne
On Thu, 8 Dec 2016 19:19:27 -0500
Metare Solve wrote:
> Sorry, I got on so many lists yesterday. I'm really not that dense.
>
> I have absolutely no language programming skills and it is very very
> frustrating. I can HTML and that's it. I desperately want to develop
> the skills but whenever I
ented, and functional languages.
I think she could learn SQL concurrently with Python, as long as she
completely understands that they don't do anything the same way as each
other, and they're not even for the same purpose.
SteveT
Steve Litt
November 2016 featured book: Qui
; in an index? Can we get the same behaviour in Postgres to minimise
> usage? What would be the recommendation here?
It's unlikely anyone will be able to usefully answer the questions you
should be asking without seeing the schema and index definitions,
and maybe some clues about
-1PGDG.rhel6.x86_64
postgresql94-9.4.9-1PGDG.rhel6.x86_64
Then tried to build pmacct and the configure complained it couldn't find the
libpq library. I looked for
a package-config file for the above but couldn't find one.
What am I missing?
Thanks,
Steve
--
Sent via pgsql-general mailing l
understand the question. You have
some table(s) with column(s) of type timestamp without time zone. You
currently view the data from the perspective of US/Eastern (probably not
actually EST - more comments on the difference between offsets and zones
below) and want to know what happens if you view it
regular backups and streaming replication to identically
equipped machines which rarely lag the master by more than a second.
Cheers,
Steve
On Wed, Nov 2, 2016 at 1:20 PM, Scott Marlowe
wrote:
> On Wed, Nov 2, 2016 at 11:40 AM, Joshua D. Drake
> wrote:
> > On 11/02/2016 10:03 AM,
of what someone might want for
PostreSQL in 2017?
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
invalidate cache under specific circumstances.
Cheers,
Steve
On Mon, Oct 31, 2016 at 7:17 AM, Melvin Davidson
wrote:
>
>
> On Mon, Oct 31, 2016 at 9:48 AM, Karsten Hilbert
> wrote:
>
>> On Mon, Oct 31, 2016 at 09:14:07AM -0400, Melvin Davidson wrote:
>>
>> >> May
On 10/28/2016 10:25 AM, Tom Lane wrote:
Steve Clark writes:
On 10/28/2016 09:48 AM, Tom Lane wrote:
Retrying might be a usable band-aid, but really this is an application
logic error. The code that is trying to do "lock table t_unit in
exclusive mode" must already hold some lower-
On 10/28/2016 09:48 AM, Tom Lane wrote:
Steve Clark writes:
No. But I examined the pg_log/log_file and saw an error indicating it was
autovacuum:
2016-10-27 09:47:02 EDT:srm2api:12968:LOG: sending cancel to blocking
autovacuum PID 12874
2016-10-27 09:47:02 EDT:srm2api:12968:DETAIL: Process
On 10/28/2016 09:15 AM, Adrian Klaver wrote:
On 10/28/2016 05:28 AM, Steve Clark wrote:
Hello List,
I am occasionally seeing the following error:
ALERT 3 sqlcode=-400 errmsg=deadlock detected on line 3351
So what exactly is it doing at line 3351?
from an application written using ecpg when
Hello List,
I am occasionally seeing the following error:
ALERT 3 sqlcode=-400 errmsg=deadlock detected on line 3351
from an application written using ecpg when trying an update to the table.
Can autovacuum be causing this,
since no one else is updating this database table.
Thanks,
--
Stephen
If the former then a regular btree
index
on the (case-folded text form of the) value, possibly using text_pattern_ops,
is the right thing.
The prefix module isn't what you want - it's for matching, e.g., an entire
phone number
against a table of possible prefixes, not a prefix
DDL, I define email addresses like:
contact_email_addr varchar(256) NOT NULL,
Disclosure: I'm a PG newbie (and a relative SQL newbie, too), and not
familiar with the DEFAULT ":: notation in your DDL.
Steve
There are 30k rows and the email column is not null... there is data
in
there
due to the lack of availability
of the actual server and client.
I know this is open source. I know that people work on their "itch" or what
their employer sponsors. I'm just sharing the user experience should it
provide value and increase the number of testers.
Cheers,
Steve
On Tue, Sep 13, 2016 at 11:03 AM, Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> I'm trying to install 9.6 RC1 on Ubuntu 16.04 Xenial on my laptop and it
> seems broken.
>
> Installation of 9.6 RC1 on Centos was straightforward by comparison - just
> add the 9
tried adding -testing to the repo but no joy:
deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg-testing main
Is packaging just not complete or am I missing something? (I had hoped that
getting configured for testing would be more friction-free.)
Cheers,
Steve
x27;s a good resource
> for reporting slow queries:
>
> https://wiki.postgresql.org/wiki/Slow_Query_Questions
+1
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ance to a master and kill off the original master instance.
As always in these instance, testing and practice is mandatory.
Cheers,
Steve
you don't
have lots of roles with different ownership and permissions across your
database you should be fine.
Or create role(s) on your test database that match those on the production
database. This may require updating pg_hba.conf on the test database.
Cheers,
Steve
On Wed, Aug 17, 2016
> On Jul 20, 2016, at 8:03 PM, John R Pierce wrote:
>
> On 7/20/2016 4:48 PM, Steve Langlois wrote:
>> I am upgrading an existing system running CentOS 5.6 with Postgres 8.2.5 to
>> CentOS 7 with 9.2.15. The original system modified the postgresql script to
>> man
On Jul 20, 2016, at 7:48 PM, Steve Langlois
mailto:steve.langl...@tavve.com>> wrote:
you never did answer my previous question, why are you messing about with
manually starting postgres from the wrong user account, when it should be run
as a system service with systemctl ?
I am upgrad
you never did answer my previous question, why are you messing about with
manually starting postgres from the wrong user account, when it should be run
as a system service with systemctl ?
I am upgrading an existing system running CentOS 5.6 with Postgres 8.2.5 to
CentOS 7 with 9.2.15. The orig
Steve Langlois writes:
> I ran
> + /usr/bin/initdb --pgdata=/usr/xxx/databases/pgsql/data --auth=ident
> without issue however when I try to start the database it complains about the
> lockfile.
> FATAL: could not create lock file "/var/run/postgresql/.s.PGSQL.5432.lock&qu
>Presumably, you are working with a distro-modified version of Postgres,
>because the stock sources don't use /var/run/postgresql as a socket
>directory. You will likely find that your version of libpq.so also
>expects /var/run/postgresql as the socket directory, so you won't be
>able to make non
My apologies but I didn't include the command I am using to start the database
/usr/bin/postmaster -p 5432 -D /usr//databases/pgsql/data
FATAL: could not create lock file "/var/run/postgresql/.s.PGSQL.5432.lock":
Permission denied
Thank you.
Using Postgres 9.2 with CentOS7.
I ran
+ /usr/bin/initdb --pgdata=/usr/xxx/databases/pgsql/data --auth=ident
without issue however when I try to start the database it complains about the
lockfile.
FATAL: could not create lock file "/var/run/postgresql/.s.PGSQL.5432.lock":
Permission denied
modify the script to
get 9.2 to run but I was hoping this script had been updated for 9.x. The
current script uses --auth='ident sameuser' when calling initdb for instance
which is not supported in 9.2.
Steve
steve.langl...@tavve.com
From: Adrian Kl
Hi, I've been searching for a 9.2.15 version of the postgresql script for "init
script for starting up the PostgreSQL". I have managed to find older versions
than what we are currently using, 8.2.5 but haven't had any luck finding a new
version in the postgres 9.2.15 rpms. We are moving from Ce
sedb.com/postgres-plus-edb-blog/fred-dalrymple/postgres-meets-hipaa-cloud
http://www.slideshare.net/EnterpriseDB/achieving-hipaa-compliance-with-postgres-plus-cloud-database
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
could easily pull PHP.
I'd go for that first one, if possible. Robust, and zero overhead in the happy
path.
> I'm looking at trying to parse/search/replace. This might well be imperfect,
> and error-prone. But if I can get something that at least works in a lot of
> cases,
) from sometable where sts=0
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Clark
Sent: Thursday, June 2, 2016 9:56 AM
To: pgsql
Subject: [GENERAL] dumb question
Hi List,
I am a noob trying to do something that
want to find the max(id) whose sts is 0 but whose id is not referenced by
ref_id.
so the answer would be id=3.
Thanks for any pointers,
Steve
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/
1 - 100 of 1490 matches
Mail list logo
