Right. I managed to start up Postgres by symlinking the following
directories to a new mount: pg_logical, pg_subtrans, pg_wal, pg_xact.
I then created a new tablespace on the new mount, set it to be the default
tablespace, and moved some of the smaller (about 30GB) tables to it. That
allowed me
On Thu, 2019-05-02 at 16:55 +, Mark Zellers wrote:
> I thought I needed the prototype table to be able to define functions and
> procedures that refer to the temporary table but do not create it.
>
> Perhaps my assumption that I need the table to exist (whether as a temporary
> table or as a
On Thu, May 2, 2019 at 4:12 PM Alvaro Herrera
wrote:
> On 2019-May-02, Ray Cote wrote:
>
> > Does anyone have a hint on how I'd go about debugging why PostgreSQL 11
> is
> > not starting on CentOS 7?
> > Was running fine for several weeks then fails to come up after a reboot.
>
> How are you gett
On 2019-May-02, Ray Cote wrote:
> Does anyone have a hint on how I'd go about debugging why PostgreSQL 11 is
> not starting on CentOS 7?
> Was running fine for several weeks then fails to come up after a reboot.
How are you getting it started after the reboot? If you're not using
systemd facilit
On 5/2/19 12:20 PM, Ray Cote wrote:
Spoke too soon, Not coming back after a boot. Seems I can install, run,
but not reboot!
What happens if change the server name back?
Might want to take a look at what is in postgresql-11.service also.
On Thu, May 2, 2019 at 3:18 PM Ray Cote
--
Adrian
Spoke too soon, Not coming back after a boot. Seems I can install, run, but
not reboot!
On Thu, May 2, 2019 at 3:18 PM Ray Cote
wrote:
>
>
> On Thu, May 2, 2019 at 2:57 PM Adrian Klaver
> wrote:
>
>> On 5/2/19 11:22 AM, Ray Cote wrote:
>> > Does anyone have a hint on how I'd go about debugging
On Thu, May 2, 2019 at 2:57 PM Adrian Klaver
wrote:
> On 5/2/19 11:22 AM, Ray Cote wrote:
> > Does anyone have a hint on how I'd go about debugging why PostgreSQL 11
> > is not starting on CentOS 7?
> > Was running fine for several weeks then fails to come up after a reboot.
> >
> > I did change
On 5/2/19 11:22 AM, Ray Cote wrote:
Does anyone have a hint on how I'd go about debugging why PostgreSQL 11
is not starting on CentOS 7?
Was running fine for several weeks then fails to come up after a reboot.
I did change the name of the CentOS7 server, but I don't expect that to
have any eff
Does anyone have a hint on how I'd go about debugging why PostgreSQL 11 is
not starting on CentOS 7?
Was running fine for several weeks then fails to come up after a reboot.
I did change the name of the CentOS7 server, but I don't expect that to
have any effect on the database.
I'm running debug5
I have a query that is being ran on PGSQL, and when queried at a fast rate
for large data sets, it is taking a long time to run because it isn't
making use of the available indexes. I found that changing the filter from
multiple OR's to an IN clause causes the right index to be used. Is there a
way
On 05/02/2019 05:36 PM, Daniel Verite wrote:
rihad wrote:
Thanks for the reply. Do you know what would a "decent" ICU collation be
to bind to a field's schema definition so it would mimic a UTF-8
encoding for a multilingual column? Maybe und-x-icu? We aren't as much
concerned about thei
Laurenz,
I thought I needed the prototype table to be able to define functions and
procedures that refer to the temporary table but do not create it.
Perhaps my assumption that I need the table to exist (whether as a temporary
table or as a permanent table) in order to define the function/proce
Have you tried adding
ESCAPE '*\*' to the PostgreSQL COPY command?
https://www.postgresql.org/docs/10/sql-copy.html
On Thu, May 2, 2019 at 12:54 PM Rob Sargent wrote:
>
> On 5/2/19 9:19 AM, Guntry Vinod wrote:
> > Hi Adrian\Kiran,
> >
> > Below is the issue.
> >
> > We are migrating from Db2
On 5/2/19 9:19 AM, Guntry Vinod wrote:
Hi Adrian\Kiran,
Below is the issue.
We are migrating from Db2 to Postgre.
The Db2 dump consists of back Slash \ with in the data [dump] , but postgre is
not escaping the Slash.
For example if name consist of Vinod\G after the inserting the dump the v
Hi Adrian\Kiran,
Below is the issue.
We are migrating from Db2 to Postgre.
The Db2 dump consists of back Slash \ with in the data [dump] , but postgre is
not escaping the Slash.
For example if name consist of Vinod\G after the inserting the dump the value
in postgre is VinodG where as I ne
On 5/2/19 8:19 AM, Guntry Vinod wrote:
Hi Adrian\Kiran,
Below is the issue.
We are migrating from Db2 to Postgre.
The Db2 dump consists of back Slash \ with in the data [dump] , but postgre is
not escaping the Slash.
For example if name consist of Vinod\G after the inserting the dump the val
On 5/2/19 12:57 AM, Francisco Olarte wrote:
Adrian:
On Wed, May 1, 2019 at 8:14 PM Adrian Klaver wrote:
.
select '2019-05-02'::timestamp <= '2019-05-01 24:00'::timestamp;
And you'll see and out of range date selected.
Technically it is correct as:
test_(postgres)# select '2019-05-02'::ti
On 5/2/19 7:34 AM, Adrian Klaver wrote:
On 5/2/19 7:30 AM, ravikris...@mail.com wrote:
> We have dump from DB2 and trying to upload it Postgre.
DB2 export command has an option to export it as CSV which quotes data
so that any embedded
lines or special characters inside the data is treated fin
On 5/2/19 7:30 AM, ravikris...@mail.com wrote:
> We have dump from DB2 and trying to upload it Postgre.
DB2 export command has an option to export it as CSV which quotes data
so that any embedded
lines or special characters inside the data is treated fine. Does the
csv format has quotes enclo
> We have dump from DB2 and trying to upload it Postgre.
DB2 export command has an option to export it as CSV which quotes data so that any embedded
lines or special characters inside the data is treated fine. Does the csv format has quotes enclosing it ?
On 5/2/19 5:20 AM, Guntry Vinod wrote:
Hi Team,
We have dump from DB2 and trying to upload it Postgre.
What program did you use to take the dump?
How are you importing the data into Postgres(note the 's')?
What is the exact error message?
The records which has \(back ward) are failing to
Hi Team,
We have dump from DB2 and trying to upload it Postgre.
The records which has \(back ward) are failing to import.
Can anyone in the team help us to resolve the issue.
Can you also let us know if we are posting the question to the right team.
Regards,
Vinod
=
select * from (select id, my_age, ur_age as urage from datatable where
agegp != 'S') m where m.myage <> m.urage
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
rihad wrote:
> Thanks for the reply. Do you know what would a "decent" ICU collation be
> to bind to a field's schema definition so it would mimic a UTF-8
> encoding for a multilingual column? Maybe und-x-icu? We aren't as much
> concerned about their sortability in most cases, we just
Hi
What I am not clear on is what the rules are as to when a
> function/procedure is effectively recompiled. Is there a danger that.
> assuming the temporary table is created for a session that one session
> might see another session's data due to the procedure having effectively
> compiled the t
Mark Zellers wrote:
> One of the issues I have run into in migrating from Oracle to PostgreSQL is
> the difference in temporary table behavior.
> I've come up with what I think is a cunning plan, but I wonder if anyone with
> more PostgreSQL understanding can shoot holes in it.
>
> Oracle defin
Adrian:
On Wed, May 1, 2019 at 8:14 PM Adrian Klaver wrote:
.
> > select '2019-05-02'::timestamp <= '2019-05-01 24:00'::timestamp;
> > And you'll see and out of range date selected.
>
> Technically it is correct as:
> test_(postgres)# select '2019-05-02'::timestamp;
>timestamp
> -
One of the issues I have run into in migrating from Oracle to PostgreSQL is the
difference in temporary table behavior. I've come up with what I think is a
cunning plan, but I wonder if anyone with more PostgreSQL understanding can
shoot holes in it.
Oracle defines their temporary tables stati
28 matches
Mail list logo
