Re: Peter Eisentraut 2015-04-24 <553a3b85.1070...@gmx.net>
> On 4/20/15 6:09 PM, Bruce Momjian wrote:
> > On Mon, Apr 20, 2015 at 07:06:37PM -0300, Alvaro Herrera wrote:
> >> ISTM there's a documentation bug here: in the code, the "dump" method
> >> checks for tablespaces and raises an error if the
Re: Benoit Lobréau 2016-08-31
> Hi,
>
> My company is using PGDATA to store configuration files and the guc
> data_directory to give the path to the instance directory.
>
> They would use it like this:
>
> pg_ctl start -D -w
>
> with this directory setup:
>
> /CONFDIR => postgresql.conf pg_
Re: Jehan-Guillaume de Rorthais 2016-09-07 <20160907140816.3e13eaa3@firost>
> Indeed. I never noticed data_directory was set in postgresql.conf file...
>
> But then, why starting PostgreSQL with the following command ?
>
> /usr/lib/postgresql/9.4/bin/postgres -D /var/lib/postgresql/9.4/main \
>
Re: Antonio Silva 2016-10-16
> 2016-10-15 06:15:20 BRT [995-1] FATAL: data directory
> "/var/lib/postgresql/9.5/main" has group or world access
> 2016-10-15 06:15:20 BRT [995-2] DETAIL: Permissions should be u=rwx (0700).
>
> The problem with permissions was already indicated to .pgpass
Hi,
Re: Durumdara 2016-04-09
> In MS the session id is smallint, so it can repeats after server restarts,
> but my coll. found a "session creation timestamp".
> This is a key which unique.
> With this we can check for died sessions and we can clean their records.
>
> We want create same mechanism.
>
Re: Stephen Frost 2016-04-09 <20160409115712.gt10...@tamriel.snowman.net>
> > Btw, what you are describing is exactly what %c in log_line_prefix
> > does.
>
> That's not currently exposed at an SQL level anywhere though, is it?
> Perhaps we should add a way to get that. Another thought would be t
Re: Peter Eisentraut 2016-05-07
<6f86345a-0658-2cd9-27d9-c381846eb...@2ndquadrant.com>
> On 5/7/16 2:43 AM, Vincenzo Romano wrote:
> > In a fresh new install of PostgreSQL 9.5.2 on Ubuntu 16.04 I am getting
> > this:
> >
> > ...
> > Setting up postgresql-9.5 (9.5.2-1.pgdg16.04+1) ...
> > Unescap
Re: James Le Cuirot 2014-06-25 <20140625144325.49d1124d@red.yakaraplc.local>
> Hello,
>
> I've been using the Chef database cookbook and found it
> frustrating because it doesn't allow you to use peer
> authentication. The client process generally runs as root and
> connects to PostgreSQL using th
Re: Bill Moran 2014-11-25
<20141125111630.d05d58a9eb083c7cf80ed...@potentialtech.com>
> Anything with a journal is a performance problem. PostgreSQL effectivly
> does its own journalling with the WAL logs. That's not to say that there's
> no value to crash recovery to having a journalling filesyst
Re: Daniel Verite 2013-04-08
> Merlin Moncure wrote:
>
> > if you have an internet facing database, patch it immediately!
>
> By the way:
>
> People running 9.1 on debian stable (squeeze) typically use this package:
> http://packages.debian.org/squeeze-backports/postgresql-9.1
>
> Curren
Re: hubert depesz lubaczewski 2013-06-28 <20130628085246.ga25...@depesz.com>
> On Fri, Jun 28, 2013 at 02:21:10PM +0530, Atri Sharma wrote:
> > How would this be helpful for general use cases? Querying on tids on a
> > specific page doesn't seem too useful for any other case than the one
> > you me
Re: Magnus Hagander 2017-04-06
> On Thu, Apr 6, 2017 at 3:46 PM, Stephen Frost wrote:
>
> > * Tom Lane (t...@sss.pgh.pa.us) wrote:
> > > (But ... these statements are based on an assumption of out-of-the-
> > > box Postgres behavior. I would not exactly put it past the Debian
> > > packagers t
Re: Igor Korot 2017-08-13
> I need to modify the pg_hba.conf file to get access to the DB
> remotely.
>
> However, I can't find this file anywhere on the system.
Try "SHOW hba_file;".
Christoph
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
Re: Igor Korot 2017-08-13
> draft=# SHOW hba_file
> draft-# SHOW hba_file;
> ERROR: syntax error at or near "SHOW"
> LINE 2: SHOW hba_file;
> ^
Standard beginners error. If you forgot the ";" on the first line,
it'll process both lines as a single, erroneous command. Note the
"
Re: Harry Ambrose 2017-08-25
> Hi All,
>
> Sorry to open this can of worms again. However, we are still struggling
> with this issue across quite a large amount of our estate.
Hi,
we've just seen exactly this error on a customer database running
9.5.3 (postgresql95.x86_64 9.5.3-2PGDG.rhel6). L
Re: Tom Lane 2017-11-10 <8027.1510347...@sss.pgh.pa.us>
> > The recovery succeeds, but when I go to start the cluster on the
> > standby, it begins to replay the WAL, and does so for about 30
> > seconds. Then I get a line in my log saying:
>
> >> pg_ctl: server did not start in time
Hi Adam,
h
Re: Magnus Hagander 2017-11-11
> > Is there any way that either the package maintainer or a site
> > administrator/programmer such as myself can mark the Postgres server
> > packages as "manual upgrade only" or similar? Or since I'm almost certainly
> > not the first person to be bitten by this,
Re: Adam Brusselback 2017-11-11
> Hey Christoph, I tried starting it with init (service postgresql
> start), and pg_ctlcluster.
>
> I modified the pg_ctl.conf and set the timeout higher so I could just
> get my cluster back up and running properly, so I can't give you the
> info on what systemct
Re: To Adam Brusselback 2017-11-11
<2017205316.u56lkmkakdmcx...@msg.df7cb.de>
> I'm investigating if it's a good idea to tell systemd to ignore the
> exit code of pg_ctl(cluster).
Telling systemd to ignore ExecStart errors seems to be the correct
solution. The service will still be active, wi
Re: Peter J. Holzer 2017-11-12 <20171112173559.m6chmbyf4vz6f...@hjp.at>
> Wouldn't it be better to remove the timeout? If some other service
> depends on PostgreSQL it probably shouldn't be startet until PostgreSQL
> is really up and services which don't need PostgreSQL (e.g. SSH or X11
> login or
Re: Tom Lane 2017-11-12 <20802.1510513...@sss.pgh.pa.us>
> Agreed, but I think Peter has a point: why is there a timeout at all,
> let alone one as short as 30 seconds? Since systemd doesn't serialize
> service starts unnecessarily, there seems little value in giving up
> quickly. And we know tha
Re: Andrus 2013-09-23
> SELECT * FROM toode
> WHERE toode in (SELECT toode FROM tempkaive)
> OR toode in (SELECT toode FROM tempalgsemu)
Generally, WHERE IN (SELECT) should be rewritten as WHERE EXISTS
(SELECT):
SELECT * FROM toode o
WHERE EXISTS (SELECT toode FROM tempkaive i WHERE o.toode
Re: Robert James 2012-12-18
> I have Postgres running on a SSD. The data is now almost 50GB, which
> is filling up the drive.
>
> How can I move some of the data to my HDD?
Use a TABLESPACE.
Christoph
--
c...@df7cb.de | http://www.df7cb.de/
--
Sent via pgsql-general mailing list (pgsql-ge
23 matches
Mail list logo