On Wed, Oct 12, 2016 at 3:41 PM Adrian Klaver
wrote:
> On 10/12/2016 02:07 AM, arnaud gaboury wrote:
>
> >
>
> >
>
> > On Tue, Oct 11, 2016 at 4:20 PM Tom Lane
> > <mailto:t...@sss.pgh.pa.us>> wrote:
>
> >
>
> > ar
On Tue, Oct 11, 2016 at 4:20 PM Tom Lane wrote:
> arnaud gaboury writes:
>
> > I am a little confused about some of my settings when it comes to map
>
> > linux/psql users.
>
>
>
> I think you're misunderstanding what the user-mapping stuff does.
>
>
On Tue, Oct 11, 2016 at 4:20 PM Tom Lane wrote:
> arnaud gaboury writes:
>
> > I am a little confused about some of my settings when it comes to map
>
> > linux/psql users.
>
>
>
> I think you're misunderstanding what the user-mapping stuff does.
>
>
On Tue, Oct 11, 2016 at 3:45 PM Adrian Klaver
wrote:
> On 10/11/2016 04:25 AM, arnaud gaboury wrote:
>
> > I am a little confused about some of my settings when it comes to map
>
> > linux/psql users.
>
> >
>
> > I have two databases: mattermost and thet
I am a little confused about some of my settings when it comes to map
linux/psql users.
I have two databases: mattermost and thetradinghall
I have two linux users: mattermost and dovecot. mattermost is the one who
want to talk to mattermost and dovecot the one who want to talk to
thetradinghall.
On Fri, Oct 7, 2016 at 5:01 PM Adrian Klaver
wrote:
> On 10/07/2016 07:58 AM, arnaud gaboury wrote:
> >
> >
>
> >
> > GGGrrrh
> >
> > ---
> > # systemctl restart postgresql
> > # su mattermost
> > bash
On Fri, Oct 7, 2016 at 4:42 PM Adrian Klaver
wrote:
On 10/07/2016 07:28 AM, arnaud gaboury wrote:
>
>
> On Fri, Oct 7, 2016 at 3:56 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
>
> On 10/07/2016 06:42 AM, arnaud gaboury wrote:
> >
> &g
On Fri, Oct 7, 2016 at 3:56 PM Adrian Klaver
wrote:
> On 10/07/2016 06:42 AM, arnaud gaboury wrote:
> >
> >
>
> >
> > Honestly not so much, as it is a nearly perfect Copy/past of postgresql
> > official doc[0].
> > My postgresql socket is in the usual
On Fri, Oct 7, 2016 at 3:15 PM Andreas Kretschmer
wrote:
> arnaud gaboury wrote:
>
> > I start an app which use a libpq function to read connection params in a
> URI.
> > Until now, the app was using a tcp connection to connect to postgresql
> with
> &
I start an app which use a libpq function to read connection params in a
URI. Until now, the app was using a tcp connection to connect to postgresql
with this URI:
postgres://
mmuser:mmuser_password@10.10.10.1:5432/mattermost?sslmode=disable&connect_timeout=10
I want to switch and make the app co
On Thu, Aug 25, 2016 at 5:50 PM, Francisco Olarte
wrote:
> Hi Arnaud:
>
> On Thu, Aug 25, 2016 at 4:35 PM, arnaud gaboury
> wrote:
>>> Are this all the contents of you pg_hba.conf? Note order matters, all
>>> non comment ( or at least the host ones ) need to be
On Thu, Aug 25, 2016 at 5:43 PM, Francisco Olarte
wrote:
> On Thu, Aug 25, 2016 at 4:28 PM, arnaud gaboury
> wrote:
>> On Thu, Aug 25, 2016 at 4:26 PM, Ilya Kazakevich
>> wrote:
>>>>I entered this line in pg_hab.conf:
>>> Are you sure your file name is co
On Thu, Aug 25, 2016 at 5:26 PM, Joshua D. Drake wrote:
> On 08/25/2016 07:44 AM, arnaud gaboury wrote:
>>
>> On Thu, Aug 25, 2016 at 4:38 PM, Joshua D. Drake
>> wrote:
>
>
>>> Did you reload PostgreSQL? That is how you tell PostgreSQL to reread the
>>&
On Thu, Aug 25, 2016 at 4:27 PM, Melvin Davidson
wrote:
>
>
> On Thu, Aug 25, 2016 at 10:18 AM, arnaud gaboury > wrote:
>
>> I am deploying mattermost on my machine following their documentation[0].
>>
>> My machine network settings:
>> --
On Thu, Aug 25, 2016 at 4:38 PM, Joshua D. Drake wrote:
> On 08/25/2016 07:18 AM, arnaud gaboury wrote:
>>
>> I am deploying mattermost on my machine following their documentation[0].
>
>
>> There is a public IP with a domain name (http works OK).
>>
>> I en
On Thu, Aug 25, 2016 at 4:37 PM, Ilya Kazakevich
wrote:
>
> % psql --host=127.0.0.1/32 --dbname=mattermost --username=mmuser
> psql: could not translate host name "127.0.0.1/32" to address: Name or
> service not known
> % psql --host=127.0.0.1/24 --dbname=mattermost --username=mmuser
> psql: could
On Thu, Aug 25, 2016 at 4:29 PM, Francisco Olarte
wrote:
> Hi Arnaud:
> On Thu, Aug 25, 2016 at 4:18 PM, arnaud gaboury
> wrote:
>> There is a public IP with a domain name (http works OK).
> Nice to know, but does not matter if all you use is 127.0.0.1
>
>
>> I en
On Thu, Aug 25, 2016 at 4:32 PM, Tom Lane wrote:
> arnaud gaboury writes:
>> I entered this line in pg_hab.conf:
>> --
>> host mattermost mmuser 127.0.0.1 md5
>
>> What am I doing wrong?
>
> Looking in the
On Thu, Aug 25, 2016 at 4:26 PM, Ilya Kazakevich
wrote:
>>I entered this line in pg_hab.conf:
> Are you sure your file name is correct and it is really used by postgres?
I think so as another service (Postfix) is running and working.
How can I verify ?
>
>
> Ilya Kazakevich
>
> JetBrains
> http:
I am deploying mattermost on my machine following their documentation[0].
My machine network settings:
--
$ ip a
1: lo: mtu 65536 qdisc noqueue state UNKNOWN
group default qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope h
On Sun, Jul 10, 2016 at 7:07 PM, Adrian Klaver
wrote:
> On 07/10/2016 03:13 AM, arnaud gaboury wrote:
>>
>> My box upgraded postgresql from 9.4.8 to 9.5.3 when doing a full
>> version upgrade (Fedora 23 --> 24).
>>
>> I have now :
>>
>>
On Sun, Jul 10, 2016 at 5:36 PM, Tom Lane wrote:
> arnaud gaboury writes:
>> My box upgraded postgresql from 9.4.8 to 9.5.3 when doing a full
>> version upgrade (Fedora 23 --> 24).
>
> So I assume you're using the Fedora-supplied RPMs, not the PGDG ones?
>
>
My box upgraded postgresql from 9.4.8 to 9.5.3 when doing a full
version upgrade (Fedora 23 --> 24).
I have now :
/db/pgsal/data > initialized with 9.5, with postgresql.conf and
pg_hab.conf from 9.4
/db/pgsql/data.old > the old one from 9.4
/usr/lib64/pgsql/postgresql-9.4/bin which comes
On Sat, Jul 9, 2016 at 8:45 PM, Adrian Klaver wrote:
> On 07/09/2016 11:40 AM, arnaud gaboury wrote:
>>
>> On Sat, Jul 9, 2016 at 8:22 PM, Adrian Klaver
>> wrote:
>>>
>>> On 07/09/2016 11:06 AM, arnaud gaboury wrote:
>>>>
>>>>
>
On Sat, Jul 9, 2016 at 8:22 PM, Adrian Klaver wrote:
> On 07/09/2016 11:06 AM, arnaud gaboury wrote:
>>
>> On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver
>> wrote:
>>>
>>> On 07/09/2016 08:08 AM, arnaud gaboury wrote:
>
>
>>>>
>>&
On Sat, Jul 9, 2016 at 7:31 PM, Adrian Klaver wrote:
> On 07/09/2016 08:08 AM, arnaud gaboury wrote:
>>
>> On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver
>> wrote:
>>>
>>> On 07/09/2016 03:09 AM, arnaud gaboury wrote:
>>>>
>>>>
&
On Sat, Jul 9, 2016 at 5:08 PM, arnaud gaboury wrote:
> On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver
> wrote:
>> On 07/09/2016 03:09 AM, arnaud gaboury wrote:
>>>
>>> On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury
>>> wrote:
>>>>
&
On Sat, Jul 9, 2016 at 4:16 PM, Adrian Klaver wrote:
> On 07/09/2016 03:09 AM, arnaud gaboury wrote:
>>
>> On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury
>> wrote:
>>>
>>> On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury
>>> wrote:
>>&g
On Sat, Jul 9, 2016 at 11:54 AM, arnaud gaboury
wrote:
> On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury
> wrote:
>> On Thu, Jul 7, 2016 at 1:00 AM, José María Terry Jiménez
>> wrote:
>>> El 7/7/16 a las 0:14, Devrim Gündüz escribió:
>>>
>>>>
On Thu, Jul 7, 2016 at 10:01 AM, arnaud gaboury
wrote:
> On Thu, Jul 7, 2016 at 1:00 AM, José María Terry Jiménez
> wrote:
>> El 7/7/16 a las 0:14, Devrim Gündüz escribió:
>>
>>> Hi,
>>>
>>> Fedora packages have an executable (not sure about its na
On Thu, Jul 7, 2016 at 1:00 AM, José María Terry Jiménez
wrote:
> El 7/7/16 a las 0:14, Devrim Gündüz escribió:
>
>> Hi,
>>
>> Fedora packages have an executable (not sure about its name, but check a
>> package called postgresql-upgrade or so). That will help you to finish the
>> upgrade process.
On Wed, Jul 6, 2016 at 8:56 PM, John R Pierce wrote:
> On 7/6/2016 11:27 AM, Adrian Klaver wrote:
>>
>>
>> First, if possible copy your data dir and conf files somewhere for safety.
>
>
> +1 !!! must be first step.
It is the first thing I did
>
>>
>> From the looks of it Fedora upgraded your Po
I am left today, after an upgrade I think (Fedora 23 --> 24) with a
broken postgresql.
It used to work very well. The service is started with the systemd
unit file. I have now this error:
-
postgres@thetradinghall ➤➤ systemd/system %
/usr/libexec/postgresql-ctl start -D /db/pgsql/
On Fri, Apr 1, 2016 at 4:04 PM, Adrian Klaver
wrote:
> On 04/01/2016 06:52 AM, arnaud gaboury wrote:
>
>>
>>
>> On Fri, Apr 1, 2016 at 3:33 PM, Sándor Daku >
>
>
>
>> One of many difficulties with computers that they do what you say
>> the
On Fri, Apr 1, 2016 at 3:33 PM, Sándor Daku wrote:
>
> On 1 April 2016 at 11:33, arnaud gaboury wrote:
>
>> I have one table email.mail.mailusers :
>>
>>Table "email.mailusers"
>>Column
On Fri, Apr 1, 2016 at 11:33 AM, arnaud gaboury
wrote:
> I have one table email.mail.mailusers :
>
>Table "email.mailusers"
>Column| Type |
> Modifiers | Storage
>
I have one table email.mail.mailusers :
Table "email.mailusers"
Column| Type |
Modifiers | Storage
| Stats target | Description
-+--+
On Wed, Feb 3, 2016 at 8:19 PM, Raymond O'Donnell wrote:
> On 03/02/2016 14:05, arnaud gaboury wrote:
>>>>
>>>> thetradinghall=> SELECT u.username ||'@'||d.domain as email_address
>>>> FROM email.mailusers u
>>>&
>>
>> thetradinghall=> SELECT u.username ||'@'||d.domain as email_address
>> FROM email.mailusers u
>> INNER JOIN
>> email.domainlist d
>> ON
>> (u.domain_id=d.id);
>>
>>email_address
>> ---
>> arnaud.gabo...@thetradinghall.com
>> (1 row)
>>
rent/static/functions-sequence.html
>
>
> On Wed, Feb 3, 2016, 06:26 arnaud gaboury wrote:
>>
>> On Wed, Feb 3, 2016 at 1:18 PM, arnaud gaboury
>> wrote:
>> > $ psql -V
>> > psql (PostgreSQL) 9.4.5
>> >
>> > I am quite a newbie in psql. I a
On Wed, Feb 3, 2016 at 2:19 PM, Raymond O'Donnell wrote:
> On 03/02/2016 13:11, arnaud gaboury wrote:
>
>> Hum hum...
>> --
>> SELECT u.username ||'@'||d.domain as email_address
>> FROM email.mail
On Wed, Feb 3, 2016 at 1:51 PM, Raymond O'Donnell wrote:
> On 03/02/2016 12:18, arnaud gaboury wrote:
>> $ psql -V
>> psql (PostgreSQL) 9.4.5
>>
>> I am quite a newbie in psql. I am setting an email server and need to
>> create then query psql tables
On Wed, Feb 3, 2016 at 1:18 PM, arnaud gaboury wrote:
> $ psql -V
> psql (PostgreSQL) 9.4.5
>
> I am quite a newbie in psql. I am setting an email server and need to
> create then query psql tables to get some information: mainly email
> address and mail directory.
>
> Fo
$ psql -V
psql (PostgreSQL) 9.4.5
I am quite a newbie in psql. I am setting an email server and need to
create then query psql tables to get some information: mainly email
address and mail directory.
For now I have created two tables this way. Both tables are in same
database and schema. I only i
On Tue, Jul 28, 2015 at 1:43 PM, CaT wrote:
> On Tue, Jul 28, 2015 at 01:31:29PM +0200, arnaud gaboury wrote:
> > On Tue, Jul 28, 2015 at 1:26 PM, Francisco Olarte <
> fola...@peoplecall.com>
> > wrote:
> >
> > > Hi Arnaud...
> > >
> &
On Tue, Jul 28, 2015 at 1:37 PM, arnaud gaboury
wrote:
>
>
> On Tue, Jul 28, 2015 at 1:31 PM, Albe Laurenz
> wrote:
>
>> arnaud gaboury wrote:
>> > On Fedora 22
>> >
>>
On Tue, Jul 28, 2015 at 1:31 PM, Albe Laurenz
wrote:
> arnaud gaboury wrote:
> > On Fedora 22
> >
> > % pg_ctl -V
> > pg_ctl (PostgreSQL) 9.4.4
> >
> >
> > % systemctl status p
On Tue, Jul 28, 2015 at 1:26 PM, Francisco Olarte
wrote:
> Hi Arnaud...
>
> On Tue, Jul 28, 2015 at 12:13 PM, arnaud gaboury
> wrote:
> > On Fedora 22
> ...
> > Jul 28 11:49:57 poppy postgresql-ctl[307]: FATAL: 42501: could not
> > open log file "/sto
On Fedora 22
% pg_ctl -V
pg_ctl (PostgreSQL) 9.4.4
% systemctl status postgresql.service -l
● postgresql.service - PostgreSQL database server
Loaded: loaded (/etc/systemd/system/postgresql.service; enabled;
vendor preset: disable
On Thu, May 28, 2015 at 11:04 AM, Ian Barwick wrote:
> On 15/05/28 17:55, arnaud gaboury wrote:
> (...)
>> I can't log from the phppgadmin. I have login failed.
>> First, I am not sure if I shall log with my unix account or postgres
>> role (I guess the latter one).
OS . Fedora 22. It is my localhost.
website : enl.global.
for phppgadmin : phppgadmin.enl.global
Nginx, php, postgresql
socket:
--
bash-4.3# ls -al /run/postgresql/
srwxrwxrwx 1 postgres postgres 0 May 28 10:10 .s.PGSQL.5432
-rw--- 1 postgres postgres 52 May 28
51 matches
Mail list logo
