Hello I have a postgres cluster with following databases
davical| pgadmin | UTF8 | en_US.utf8 |
en_US.utf8 |
test| test | LATIN9| en_US.iso885915 |
en_US.iso885915 |
foo| postgres | SQL_ASCII | en_US.
start of postgres all is fine.
Thanks a lot.
p.s. os: debian 7 with postgres 9.1
On 05.03.2015 14:36, Adrian Klaver wrote:
> On 03/05/2015 02:48 AM, basti wrote:
>> Hello I have a postgres cluster with following databases
>>
>> davical| pgadmin |
Hello,
I try to use PHP with Postgresq1 socket connection. All works fine with
following entry in
pg_hba.conf
local database user trust
or
local database user peer map=someuser
pg_ident.conf
# MAPNAME SYSTEM-USERNAME PG-USERNAME
someuserwww-data
Hello,
i have a problem with my postgres server. There is a DB with approx 30
GB. the traffic per day is between 20-50 GB on the outgoing interface.
one client has ~ 20 IDLE connections. i have sniffer this connections
with nfdump and get this traffic
2016-11-29 12:05:56.165 5854.304 TCP x
and
its very old (year 2004).
Is there a way to see traffic network of postgres sort by query?
best regards
basti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
9h41 Seg, 05/12/2016, basti <mailto:mailingl...@unix-solution.de>> escreveu:
>
> Hallo,
>
> I have to try traffic accounting for postgres using tcpdump and nfdump.
> I can see what traffic is produced but cant see the query / activity who
> do it. bec
work and then correlate network
> activity with PIDs and then somehow via (pg_stat_* or ps) with queries.
>
>>
>> Em 9h41 Seg, 05/12/2016, basti
>> <<mailto:mailingl...@unix-solution.de>mailingl...@unix-solution.de>
>> escreveu:
>>
>> Hallo,
work and then correlate network
> activity with PIDs and then somehow via (pg_stat_* or ps) with queries.
>
>>
>> Em 9h41 Seg, 05/12/2016, basti
>> <<mailto:mailingl...@unix-solution.de>mailingl...@unix-solution.de>
>> escreveu:
>>
>> Hallo,
CEST WARNING: archiving transaction log file
"0001000C" failed too many times, will try again later
How can I fix this?
Thanks,
Basti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
abase.");
}
When I try to connect via
psql -U user -h localhost -W database
I can connect without error.
I also use SSL connections, is this the problem? or in other words is
there a way to connect php via (postgres) ssl?
Regards,
basti
--
Sent via pgsql-general mailing list (pg
Yes, there is the same problem.
postgres logs also:
"Connection matched pg_hba.conf line 93
„hostall all 127.0.0.1/32md5“"
Am 09.07.2014 13:14, schrieb Bill Moran:
> On Wed, 09 Jul 2014 13:04:19 +0200 basti wrote:
>
>> Hello my pg_h
Here is the output of the echo.
host=127.0.0.1 user=mydns password=mypass sslmode=allow dbname=mydns
I have also try host=localhost and sslmode=require
Am 09.07.2014 13:47, schrieb Francisco Olarte:
> Hi:
>
> On Wed, Jul 9, 2014 at 1:04 PM, basti wrote:
>> Hello my pg_hab.conf
0.0.0 md5
did not work.
I use Postgres 9.3.4-1.pgdg70+1. (debian)
Am 09.07.2014 15:06, schrieb Adrian Klaver:
> On 07/09/2014 04:04 AM, basti wrote:
>> Hello my pg_hab.conf has this entry:
>>
>> hostall all 127.0.0.1/32md5
&
Is there a simple md5 hash?
I also try to hash my passwd via md5.
There is sill the same error.
Am 09.07.2014 15:19, schrieb rob stone:
> Are you encrypting the password? If not, alter the pg_hba.conf file to
> "trust" instead of md5. If it's all running on localhost it's no big
> deal.
--
Sent
I don't know whats wrong there
hostmydns mydnslocalhost trust
works well and
#hostall all 0.0.0.0 0.0.0.0 md5
did not work.
I use Postgres 9.3.4-1.pgdg70+1.
Am 09.07.2014 14:04, schrieb basti:
> Here is th
Hello,
I had followed this discuss
(http://www.postgresql.org/message-id/CABRT9RAXzUa=_zT_M4Z1vyDuFkpgNCZLUnRTUO5gvK2kKkNu=a...@mail.gmail.com).
I have a similar problem now:
I use one Postgres Server as Master an an other one as Standby (WAL
archives).
I do also a daily backup of the Master Serv
1.pgdg70+1)
php: php5(5.4.4-14+deb7u12), libphp-adodb(5.15-1),
php5-pgsql(5.4.4-14+deb7u12)
When I try Postgres 9.1 and php 5.4.4 with md5 auth-method, it also
works very well.
Perhaps someone can do a bug report?
Thanks for any help!
Best regards,
basti
Am 10.07.2014 05:21, schrieb Scott Marlowe:
above.
I have done the setup.
And I don't use ADO for this test.
I have also test
Postgres 9.1 and Postgres 9.4 both work with auth-method md5, except
postgres 9.3 discuss there.
It takes a round 5 hours to find this "error".
If anybody has the same problem be warned.
Regards,
b
d64PostgreSQL C client library
Am 15.07.2014 16:33, schrieb Adrian Klaver:
> On 07/15/2014 07:17 AM, basti wrote:
>> Hello Adrian,
>>
>> Yes I use the correct cluster.
>>
>> password authentication failed for user "testuser" ...
>> is a line from
Yes all clusters, run on the same machine.
All packages are from pgdg.
libpq5 is version 9.3.4-1.pgdg70+1
the problem is still the same,
The relevant database is only for testing and development,
I will downgrade to 9.1.
Thanks for helping.
Regards,
basti
Am 15.07.2014 16:46, schrieb Adrian
d64PostgreSQL C client library
Am 15.07.2014 16:33, schrieb Adrian Klaver:
> On 07/15/2014 07:17 AM, basti wrote:
>> Hello Adrian,
>>
>> Yes I use the correct cluster.
>>
>> password authentication failed for user "testuser" ...
>> is a line from
Hello,
months ago I have a similar problem with the OOM-Killer.
Have a look at
http://www.credativ.co.uk/credativ-blog/2010/03/postgresql-and-linux-memory-management
I hope that's helpful.
Regards,
basti
On Sat 25.10.2014 22:55 +0200, Joe Van Dyk wrote:
> One of my postgres back
"
Async or Synchronous?
Am 27.10.2014 17:00, schrieb Joe Van Dyk:
>
> On Mon, Oct 27, 2014 at 8:16 AM, basti <mailto:mailingl...@unix-solution.de>> wrote:
>
> Hello,
>
> months ago I have a similar problem with the OOM-Killer.
> Have a look at
>
&
Hello,
months ago I have a similar problem with the OOM-Killer.
Have a look at
http://www.credativ.co.uk/credativ-blog/2010/03/postgresql-and-linux-memory-management
I hope that's helpful.
Regards,
basti
On Sat 25.10.2014 22:55 +0200, Joe Van Dyk wrote:
> One of my postgres back
Please use this http://www.postgresql.org/community/lists/subscribe/ link.
On 28.01.2015 12:01, Quirin Hamp wrote:
> Please unsubscribe me from mailing list. Thank you!
>
> Bien cordialement, / Mit freundlichen Grüßen / Yours sincerely,
>
> Quirin HAMP
> _
> Viessmann F
Hallo, we have a Postgres database Server and around that there are 8
clients get data from it.
All servers are the the same datacenter i think (traceroute only 4-5 hops)
Now we plan to move the server to an other hoster/datacenter.
I have done simple test with ping and traceroute.
Is there a wa
Hello,
is there a recomment to set max_worker_processes and
max_parallel_workers_per_gather per cpu core or thread?
Best regards
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
possible to use on Master Version 9.1 and on Slave 9.6 (it will
get the new master in the next step)?
Best Regards,
Basti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
in my postgres.conf i use
log_filename = 'postgresql-%Y-%m-%d.log'
this results in Logfiles named "postgresql-2017-07-14.log"
Is there a way to create logfiles
"postgresql--2017-07-14.log"
Best Regards,
Basti
--
Sent via pgsql-general mailing list (pg
I want to create a generic own_postgres.conf and include that in
postgres.conf
I ask a bit wrong. Is there a variable to include postgres version on
log_filename?
Best regards
basti
Am 18.07.2017 um 10:40 schrieb Achilleas Mantzios:
> On 18/07/2017 11:36, Walter Nordmann wrote:
>> M
I want to create a generic own_postgres.conf and include that in
postgres.conf
I ask a bit wrong. Is there a variable to include postgres version on
log_filename?
Best regards
basti
Am 18.07.2017 um 10:40 schrieb Achilleas Mantzios:
> On 18/07/2017 11:36, Walter Nordmann wrote:
>> M
4";
^
ERROR: syntax error at or near "a"
LINE 1: a:1:{^CCancel request sent
ERROR: syntax error at or near "s"
LINE 1: s:4:"4508";
^
Is there a way to do a clean backup and restore with this json data?
best regards,
basti
--
Sen
Hello,
i have a webapp convert from ascii to uft8.
Now I get in postgres
ERROR: invalid byte sequence for encoding "UTF8": 0xfc
Now I try to log all queries with log_statement = 'all'.
All queries are longed expected this one.
Is there a way to debug this.
Best Regards,
/wiki/Streaming_Replication
and had install an other cluster in the past with successful.
How can help please?
Best regards,
basti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
i have fixed. pg_update has create a wrong cluster
On 14.08.2017 20:52, basti wrote:
Hello,
i try to replicate my database. what i have done?
- create a cluster on slave (UTF8, en_US.utf8 collate/c_type)
- stop cluster and cleanup datadir
- do basebackup from master
- start db-cluster
31 14:22:49.310 CEST [15884] LOG: Worker-Prozess: pglogical
apply 16627:1763399739 (PID 16767) beendete mit Status 1
I have retry< setup multipole times, always the same error.
What i have done wrong?
Best Regards,
basti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
and deny all other?
Best Regards,
basti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
we have a database master Version:
PostgreSQL 9.1.6 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
4.7.2-2) 4.7.2, 64-bit
and a WAL-Replication Slave with hot-standby version:
PostgreSQL 9.1.9 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
4.7.2-5) 4.7.2, 64-bit.
Since a few da
release (9.2.4, 9.1.9 or 9.0.13).
On 17.03.2014 12:12, Tomas Vondra wrote:
> Hi,
>
> On 17 Březen 2014, 11:45, basti wrote:
>> Hello,
>>
>> we have a database master Version:
>> PostgreSQL 9.1.6 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
>> 4.7.2-2)
Hello,
at the moment we use a Postgres Server as Master and one as Hot-Standby.
The Database is around 50GB and will massive grow next time.
Backup and Restore with pg_dump take several hours, is there a faster
way to do this?
Regards,
Basti
--
Sent via pgsql-general mailing list (pgsql
Hello,
at the moment we use a Postgres (9.1) Master and a Hot-Standby with WAL
Replication.
We also use Slony to copy some (not all) Tables to fronted server.
Is it possible to use repmgr to switch between Master and Hot-standby
without lose the slony functionality?
When I use repmgr and switch
ot;: No such file or
directory
/var/run/shm# ls -rtl
-rw--- 1 postgres postgres 312211 Apr 22 11:31 pgstat.stat
There is no "/run/shm/pgstat.tmp" file but if I create it and change the
owner to postgres the file will be removed few minutes later.
How can explain and how can I solve thi
/run/shm and /var/run/shm would be the same. On my system I found no
symlink to each other but there is the same content.
Basti
On 22.04.2014 12:02, Tomáš Vondra wrote:
> Seems you're using /run/shm and /var/run/shm by mistake.
>
> Tomas
>
> basti napsal/a:
>
>&
22 16:02 shm
I think these permissions are enough.
Basti
On 22.04.2014 15:36, Adrian Klaver wrote:
> On 04/22/2014 02:39 AM, basti wrote:
>> Hello,
>>
>> since I have enabled "stats_temp_directory = '/run/shm'" in
>> /etc/postgresql/9.1/main/postgresql.con
:15 ..
-rw--- 1 postgres postgres 52658 Apr 22 17:09 pgstat.stat
-rw-r--r-- 1 root root 0 Oct 19 2012 .tmpfs
postgres@srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$
Basti
On 22.04.2014 16:32, Adrian Klaver wrote:
> On 04/22/2014 07:11 AM, basti wrote:
>>
ot;: No such file or
directory
/var/run/shm# ls -rtl
-rw--- 1 postgres postgres 312211 Apr 22 11:31 pgstat.stat
There is no "/run/shm/pgstat.tmp" file but if I create it and change the
owner to postgres the file will be removed few minutes later.
How can explain and how can I solve t
/run/shm and /var/run/shm would be the same. On my system I found no
symlink to each other but there is the same content.
Basti
On 22.04.2014 12:02, Tomáš Vondra wrote:
> Seems you're using /run/shm and /var/run/shm by mistake.
>
> Tomas
>
> basti napsal/a:
>
>&
:15 ..
-rw--- 1 postgres postgres 52658 Apr 22 17:09 pgstat.stat
-rw-r--r-- 1 root root 0 Oct 19 2012 .tmpfs
postgres@srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$
Basti
On 22.04.2014 16:32, Adrian Klaver wrote:
> On 04/22/2014 07:11 AM, basti wrote:
>> When Po
Hello,
is it possible to have WAL Replication and Point-in-Time Recovery like
follows:
DB-Master -- (WAL to Slave) --> DB-Slave
|
|---> (PITR to an other Server)
Thanks for any help!
Basti
p.s. is there a tutorial somewhere how describe the steps todo when the
master is c
Hello,
is it possible to have WAL Replication and Point-in-Time Recovery like
follows:
DB-Master -- (WAL to Slave) --> DB-Slave
|
|---> (PITR to an other Server)
Thanks for any help!
Basti
p.s. is there a tutorial somewhere how describe the steps todo when the
master is c
50 matches
Mail list logo
