On Tue, Jul 07, 2015 at 06:57:45AM -0500, John McKown wrote:
at a bare minimum, a database administrator needs to create database
roles (users) and databases for an app like yours.
The admin don't need to create the db. It is done by the application
(sqlalchemy-utils on Python3) itself.
On Wed, Jul 8, 2015 at 3:55 AM, Karsten Hilbert karsten.hilb...@gmx.net
wrote:
On Tue, Jul 07, 2015 at 06:57:45AM -0500, John McKown wrote:
at a bare minimum, a database administrator needs to create database
roles (users) and databases for an app like yours.
The admin don't need to
Hello,
I plan to replace some btree indexes through btree_gin on some timed
tables(e.g. monthly tables)
For this, I first need to change the data type from character(n) to varchar,
but I can't afford it on historical tables as this would be too time consuming,
so only new tables should get
On 07/07/2015 11:21 PM, Chas. Munat wrote:
I recently upgraded to Ubuntu 15.04 with PostgreSQL 9.4.4 with uuids and
plv8 coffeescript extensions. I can access the database via psql. My web
application uses node.js via pg-bricks. It works perfectly on my Mac dev
machine.
The Mac has it's own
On 07/08/2015 01:04 AM, Thierry Hauchard wrote:
Hy,
We can't upgrade our customers from 8.4 to 9.4.4 if they have a 32 bits
server machine (Windows 2008, 2007...).
There is no problem with PG 64 bits.
Except below you say only for majority of 64bit machines, so are the
problems when they
Chas. Munat c...@munat.com writes:
I recently upgraded to Ubuntu 15.04 with PostgreSQL 9.4.4 with uuids and
plv8 coffeescript extensions. I can access the database via psql. My web
application uses node.js via pg-bricks. It works perfectly on my Mac dev
machine.
On the server, I get this
Marc Mamin m.ma...@intershop.de writes:
Now I have generated queries that include cast information in order to ensure
that the indexes get used.
e.g.: WHERE month1.foo = cast('XY' as character(2))
with mixed type, this should become something like:
SELECT ... FROM month1
WHERE
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Mittwoch, 8. Juli 2015 15:44
To: Marc Mamin
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Problem with ALTER TYPE, Indexes and cast
Marc Mamin m.ma...@intershop.de writes:
Now I have generated
There is NO problem on 64 bits machines with PG 64 bits.
(We have not try PG 32 bits on 64 bits machine.)
There IS problem on all 32 bits machine with PG 32 bits
All databases are encoded on PG in UTF8
We set that on all connexions :
SET CLIENT_ENCODING TO WIN1252;
SET bytea_output TO escape;
On 07/08/2015 08:40 AM, Thierry Hauchard wrote:
There is NO problem on 64 bits machines with PG 64 bits.
I saw this line from your previous post:
No issue on 64bits machine (majority of our customers).
Realize now that this means the majority of your customers are using
64bit Windows. I
Hi all,
I've been testing bdr over the last few days and trying to simulate
conflicts.
For an update/update conflict I powered down node a and updated on node b.
Then powered down node b and updated node a and powered node b back on.
The situation I'm left in is that replication happens one way
Hy,
We can't upgrade our customers from 8.4 to 9.4.4 if they have a 32 bits
server machine (Windows 2008, 2007...).
There is no problem with PG 64 bits.
When restoring from backup (created from 8.4 database with PG_Dump
9.4.4), the log shows errors about UTF like :
2015-07-07 17:03:35 CEST
Hi:
I cannot use .pgpass as the password stored here is not encrypted.
can i use a encrypted password from unix shell script. has anybody ran
into same situation. Wht options do i have.
Thanks,
-SR
On 7/8/2015 11:34 AM, Suresh Raja wrote:
I cannot use .pgpass as the password stored here is not encrypted.
can i use a encrypted password from unix shell script. has anybody
ran into same situation. Wht options do i have.
I believe anywhere you enter a password in postgres, it can be the
Thierry Hauchard wrote:
When restoring from backup (created from 8.4 database with PG_Dump
9.4.4), the log shows errors about UTF like :
2015-07-07 17:03:35 CEST ERREUR: séquence d'octets invalide pour
l'encodage « UTF8 » : 0xf4 0x6c 0x65 0x20
[...]
UPDATE test_table SET str_field
On 07/08/2015 08:40 AM, Thierry Hauchard wrote:
There is NO problem on 64 bits machines with PG 64 bits.
(We have not try PG 32 bits on 64 bits machine.)
There IS problem on all 32 bits machine with PG 32 bits
Further thought, are the 32bit and 64bit Windows in the same version of
Windows or
Thierry,
Please post the output of
$ psql -l
for the database in question for both the 32-bit and 64-bit servers. That will
show what encoding was specified when the databases where created.
Also, post the output of
$ psql dbname here login -c “show client_encoding”
$ psql dbname here
Hi,
which build of PosgreSQL did you use?
Postgres Professional has published today its Windows PostgreSQL installer for
9.4.4, which solves some strange issues with russian encoding in psql occurring
in the EDB build.
I'm not sure it can help in your case.
The installer is at
Hi,
We recently done the similar migration for one of our customer. We used all
opensource tools to achieve this migration process.
We used Pentaho Data Integration tool for doing Online DB migration, which
took minimal downtime with CDC{Change Data Capture} approach. Also, we used
Ora2Pg tool
Hello,
I have a customer that is about to undertake a migration of an Oracle 11g
database to PostgreSQL 9.x (exact version to be determined). I am talking
not only of the migration of schemas and data, but also of a substantial
codebase of Pl/SQL stored procedures, as well as many triggers.
I
On 7/8/2015 12:01 PM, Steve Midgley wrote:
My suggestion is to put it in an environment variable and set that
variable from a shell startup script that is secured with permissions.
(http://www.postgresql.org/docs/9.4/static/libpq-envars.html)
that just moves the problem, now the plaintext
On 7/8/2015 1:16 PM, dinesh kumar wrote:
We recently done the similar migration for one of our customer. We
used all opensource tools to achieve this migration process.
We used Pentaho Data Integration tool for doing Online DB migration,
which took minimal downtime with CDC{Change Data
On 07/08/2015 12:47 PM, John McKown wrote:
Why are they converting?
Would EnterpriseDB (a commercial version of PostgreSQL which has
extensions to make it a drop in replacement for Oracle) be a possibility?
http://www.enterprisedb.com/solutions/oracle-compatibility-technology
Because EDB
On 07/08/2015 02:20 PM, John R Pierce wrote:
On 7/8/2015 1:16 PM, dinesh kumar wrote:
We recently done the similar migration for one of our customer. We
used all opensource tools to achieve this migration process.
We used Pentaho Data Integration tool for doing Online DB migration,
which
This is almost exactly what we did around 8 years ago; obviously the
version numbers have changed. The reason we chose Postgres was the
enormous similarity between the two languages plus the overwhelming ROI
on the migration; my CEO had a spontaneous nosebleed when the Oracle
licensing costs were
On Wed, Jul 8, 2015 at 1:20 PM, John R Pierce pie...@hogranch.com wrote:
On 7/8/2015 1:16 PM, dinesh kumar wrote:
We recently done the similar migration for one of our customer. We used
all opensource tools to achieve this migration process.
We used Pentaho Data Integration tool for doing
I recently upgraded to Ubuntu 15.04 with PostgreSQL 9.4.4 with uuids and
plv8 coffeescript extensions. I can access the database via psql. My web
application uses node.js via pg-bricks. It works perfectly on my Mac dev
machine.
On the server, I get this error:
preload failed { [Error:
On Wed, Jul 8, 2015 at 2:24 PM, Tim Clotworthy
tclotwor...@bluestonelogic.com wrote:
Hello,
I have a customer that is about to undertake a migration of an Oracle 11g
database to PostgreSQL 9.x (exact version to be determined). I am talking
not only of the migration of schemas and data, but
On 07/03/2015 08:08 AM, howardn...@selestial.com wrote:
I am trying to move away from pg_dump as it is proving too slow.
Have you looked into barman?
http://www.pgbarman.org
Also, another potential approach is to setup replication and to do the
backups from the slave.
--
Sent via
Have a client using a commercial application. For a year plus we had
been using a local self signed certificate without issues. As of a few
weeks ago a change/update to the program is making it complain about the
self signed cert.
I bought a SSL cert and installed it, but the program is still
Francisco Reyes li...@natserv.net writes:
Have a client using a commercial application. For a year plus we had
been using a local self signed certificate without issues. As of a few
weeks ago a change/update to the program is making it complain about the
self signed cert.
What's the
I would start by looking at how many databases, schemas, tables and views
are involved. Then look at how many individual Oracle functions need to be
converted to plpgsql. You also need to investigate if there are any custom
data types. I do not have the formula, but I am sure there is a general
My suggestion is to put it in an environment variable and set that variable
from a shell startup script that is secured with permissions. (
http://www.postgresql.org/docs/9.4/static/libpq-envars.html)
If you can't do that, the only other method I've used is to setup Postgres
with Ansible, and
On Wed, Jul 8, 2015 at 2:46 PM, John R Pierce pie...@hogranch.com wrote:
but what security does that gain you?if someone gets your
encrypted/hashed password, he can still log on. the pgpass file has to be
permissions 700, so only YOU (and root) can read it.
Exactly this. If you want a
I use envcrypt for things like this locally. Just encrypt the file with
your own PGP key.
https://github.com/whilp/envcrypt
On Wed, Jul 8, 2015 at 12:01 PM, Steve Midgley scie...@misuse.org wrote:
My suggestion is to put it in an environment variable and set that
variable from a shell startup
35 matches
Mail list logo