Hi all,
When I tried to psql command, I found that the result of command seems to be
different from explanation of the manual. Please tell me which is
correct performance, the result of command or the explanation of manual.
I show the details as follows.
[Events］
The encoding that psql command s
On 06/02/14 06:46, Torsten Förtsch wrote:
> we decreased wal_keep_segments quite a lot. What is the supposed way to
> get rid of the now superfluous files in pg_xlog?
Nothing special. The database did it for me.
Sorry for the noise.
Torsten
--
Sent via pgsql-general mailing list (pgsql-genera
Hi,
we decreased wal_keep_segments quite a lot. What is the supposed way to
get rid of the now superfluous files in pg_xlog?
Thanks,
Torsten
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gene
On 02/05/2014 12:19 PM, Mephysto wrote:
I posted my last message via Nabble, so I think that the log is not
shown in email.
I try to repost my log via email:
DEBUG: building index "pg_toast_148085_index" on table "pg_toast_148085"
CONTEXT: SQL statement "CREATE LOCAL TEMPORARY TABLE deck_ty
Greetings,
Often times I find it necessary to work with table rows in a specific,
generally user-supplied order. It could be anything really that requires an
ordering that can't come from a natural column. Most of the time this involved
manipulating a position column from the client applicati
Em 05/02/2014 15:08, Adrian Klaver escreveu:
On 02/05/2014 08:53 AM, Edson Richter wrote:
Em 05/02/2014 13:03, Adrian Klaver escreveu:
On 02/05/2014 05:43 AM, Edson Richter wrote:
Em 05/02/2014 11:12, Alban Hertroys escreveu:
Are you connecting to the correct host?
On 5 February 2014 12:37,
On Feb 5, 2014, at 12:50 PM, Eliott wrote:
> Dear community,
>
> I've just noticed that in one of our databases many duplicate tables had
> appeared all ending in _copy. These tables are owned by postgres not the db
> owner user, other than that they seem to be a replica from a specific time
Dear community,
I've just noticed that in one of our databases many duplicate tables had
appeared all ending in _copy. These tables are owned by postgres not
the db owner user, other than that they seem to be a replica from a
specific time in the past. I suspect that a failed backup might hav
On 05 Feb 2014, at 21:19, Mephysto wrote:
> I posted my last message via Nabble, so I think that the log is not shown in
> email.
>
>
> I try to repost my log via email:
>
> DEBUG: building index "pg_toast_148085_index" on table "pg_toast_148085"
> CONTEXT: SQL statement "CREATE LOCAL TEMP
I posted my last message via Nabble, so I think that the log is not shown
in email.
I try to repost my log via email:
DEBUG: building index "pg_toast_148085_index" on table "pg_toast_148085"
CONTEXT: SQL statement "CREATE LOCAL TEMPORARY TABLE deck_types
ON COMMIT DROP
You said they upgraded the driver but the versions you stated are the same
???
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Wed, Feb 5, 2014 at 12:23 PM, CS DBA wrote:
> Hi All;
>
> We have a client running Pentaho to migrate data.
>
> They recently upgraded Pentaho wh
Em 05/02/2014 11:51, rob stone escreveu:
O
n Wed, 2014-02-05 at 09:37 -0200, Edson Richter wrote:W
ithout any changes in the configuration files, a **local** connection to
a local VPN IP address could not be established with the following
error:
The error (JDBC connection using driver version 10
CS DBA wrote
> Hi All;
>
> We have a client running Pentaho to migrate data.
>
> They recently upgraded Pentaho which upgraded their JDBC driver from 8.4
> (postgresql-8.4-703.jdbc4.jar) to 9.1 (postgresql-8.4-703.jdbc4.jar).
> They have a test set which updates 1000 rows, with the old driver
Em 05/02/2014 15:08, Adrian Klaver escreveu:
On 02/05/2014 08:53 AM, Edson Richter wrote:
Em 05/02/2014 13:03, Adrian Klaver escreveu:
On 02/05/2014 05:43 AM, Edson Richter wrote:
Em 05/02/2014 11:12, Alban Hertroys escreveu:
Are you connecting to the correct host?
On 5 February 2014 12:37,
Hi All;
We have a client running Pentaho to migrate data.
They recently upgraded Pentaho which upgraded their JDBC driver from 8.4
(postgresql-8.4-703.jdbc4.jar) to 9.1 (postgresql-8.4-703.jdbc4.jar).
They have a test set which updates 1000 rows, with the old driver it
takes about 30 seconds
On 02/05/2014 08:53 AM, Edson Richter wrote:
Em 05/02/2014 13:03, Adrian Klaver escreveu:
On 02/05/2014 05:43 AM, Edson Richter wrote:
Em 05/02/2014 11:12, Alban Hertroys escreveu:
Are you connecting to the correct host?
On 5 February 2014 12:37, Edson Richter
wrote:
Without any changes in
Em 05/02/2014 13:03, Adrian Klaver escreveu:
On 02/05/2014 05:43 AM, Edson Richter wrote:
Em 05/02/2014 11:12, Alban Hertroys escreveu:
Are you connecting to the correct host?
On 5 February 2014 12:37, Edson Richter
wrote:
Without any changes in the configuration files, a **local**
connecti
On Thu, Jan 30, 2014 at 2:12 PM, Tim Uckun wrote:
> Hi all.
>
> I have the following scenario I want to accomplish.
>
> In order to test a new branch of code I want to create a snapshot of the
> live database into a testing database.
>
How do you do that? Running pg_basebackup live? What I do
On 2014-02-05 10:36, ChoonSoo Park wrote:
On Wed, Feb 5, 2014 at 7:53 AM, George Ant
mailto:g.antonopoulos...@gmail.com>> wrote:
Hey Guys,
I am trying to copy data from one table to another using plpgsql.
The two
tables have different structure cause the new one is object-table
On 02/05/2014 07:36 AM, mephysto wrote:
Ehm no,
at a few line befor end you can read this:
ERROR: relation "deck_types" already exists
I should have been clearer. There is no error log posted in your
previous message.
So, the error persists.
:(
--
View this message in context:
htt
On Wed, Feb 5, 2014 at 7:53 AM, George Ant wrote:
> Hey Guys,
>
> I am trying to copy data from one table to another using plpgsql. The two
> tables have different structure cause the new one is object-table. My
> function is this :
>
> CREATE OR REPLACE FUNCTION copy_customers() RETURNS integer a
Ehm no,
at a few line befor end you can read this:
ERROR: relation "deck_types" already exists
So, the error persists.
:(
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Temporary-table-already-exists-tp5789852p5790688.html
Sent from the PostgreSQL - general mailin
On 02/05/2014 07:19 AM, mephysto wrote:
Hello newly,
this is my error log:
Thanks in advance.
Seems problem is solved:)
Meph
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
Hello newly,
this is my error log:
Thanks in advance.
Meph
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Temporary-table-already-exists-tp5789852p5790682.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general maili
On 02/05/2014 05:43 AM, Edson Richter wrote:
Em 05/02/2014 11:12, Alban Hertroys escreveu:
Are you connecting to the correct host?
On 5 February 2014 12:37, Edson Richter wrote:
Without any changes in the configuration files, a **local**
connection to a
local VPN IP address could not be estab
O
n Wed, 2014-02-05 at 09:37 -0200, Edson Richter wrote:W
ithout any changes in the configuration files, a **local** connection to
a local VPN IP address could not be established with the following
error:
>
> The error (JDBC connection using driver version 1002):
> 2014-02-05 09:12:21.111 - x
Em 05/02/2014 11:12, Alban Hertroys escreveu:
Are you connecting to the correct host?
On 5 February 2014 12:37, Edson Richter wrote:
Without any changes in the configuration files, a **local** connection to a
local VPN IP address could not be established with the following error:
The error (J
Are you connecting to the correct host?
On 5 February 2014 12:37, Edson Richter wrote:
> Without any changes in the configuration files, a **local** connection to a
> local VPN IP address could not be established with the following error:
>
> The error (JDBC connection using driver version 1002):
Hey Guys,
I am trying to copy data from one table to another using plpgsql. The two
tables have different structure cause the new one is object-table. My
function is this :
CREATE OR REPLACE FUNCTION copy_customers() RETURNS integer as $BODY$
DECLARE
idcounter integer := 1;
firstname t
Dear all, I need your advise. Found a tricky situation.
Without any changes in the configuration files, a **local** connection
to a local VPN IP address could not be established with the following
error:
_*The error (JDBC connection using driver version 1002):*_
2014-02-05 09:12:21.111 -
On Wed, Feb 5, 2014 at 9:15 AM, Alan Nilsson wrote:
> I tried (and finally succeeded) to do a base backup tonight using
> pg_basebackup. I was backing up a server that had no activity on it. The
> backup connected but no data was transferring, both ends sitting idle. It
> finally occurred to
I tried (and finally succeeded) to do a base backup tonight using
pg_basebackup. I was backing up a server that had no activity on it. The
backup connected but no data was transferring, both ends sitting idle. It
finally occurred to me to try a manual checkpoint and it then the backup took
32 matches
Mail list logo
