He wrote:
I can ssh between servers,
regards,
Andreas
On 08/24/2012 06:57 PM, Walter Hurry wrote:
On Fri, 24 Aug 2012 10:35:54 -0400, Tom Lane wrote:
No route to host doesn't have anything to do with whether there's
anything listening on the target port ... what's more likely is that the
Hi,
are there any firewalls up (check iptabled) ? try running
telnet 192.168.91.145 5432
what is happening ?
regards,
Andreas
On 08/24/2012 06:15 AM, CS DBA wrote:
Hi all;
I've fired up 2 CentOS 6.2 VM's via vmware fusion 5 (on a mac).
I disables selinux on both, and installed postgres
Reading this thread confuses me a little bit. There is no need to backup
a cluster in order to move it to another disk within the same machine.
Stopping the Database, moving $PGDATA, adjusting scripts and routines if
nessecary and firing up the whole thing would do fine.
regards
-Andreas
Hi,
pgtune could be the thing you're looking for.
http://pgfoundry.org/projects/pgtune/
regards
andreas
RBN wrote:
Can someone suggest some appropriate initial configuration parameters
and shared memory settings for the following hardware?
I'm running Debian on a Dell with 4x6 core
hi,
sounds like a plain text backup. your problem, I guess, will be some
constraint issue. I suggest commenting out the constraints in the backup
file before running the restore.
regards
andreas
ALEXANDER JOSE wrote:
psql coon I'm trying to restore a database that has 60 GB in size,
hi johann,
maybe you should consider using point in time recovery (pitr) if the
database is mission critical.
http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html
regards
andreas
Johann Spies wrote:
After two disks on our raid-5 system failed causing a filesystem
Hello *,
after a harddisk filling up to a 100% the database crashed. This is the output
I get when I try to start the DB again. Is there any chance to get it back
running without using a dump ?
regards,
-Andreas
2004-06-11 13:38:23 [22379] LOG: database system was interrupted while in
Put it into a shell script like
echo select * from mytable where id = $1; | psql $DBNAME
That can be executed using the shell function in psql
\! [COMMAND] execute command in shell or start interactive shell
regards,
-Andreas
On Wednesday 28 April 2004 17:46, Ben Kim wrote:
I tried but
Hello *,
I have a problem with select lower() using capital letters with diaeresis. I
tried with encoding SQL_ASCII und UNICODE.
newsdb=# select lower('kosteuer');
lower
kosteuer
(1 row)
newsdb=# select lower('Andreas');
lower
-
andreas
(1 row)
Any Ideas ?
behave different (chip rev. etc). I
suggest you move the database for testing to another machine. Try to
reproduce the problem there.
regards
-andreas
PS: FYI ext3 is an ext2 filesystem with journaling enabled (man tunefs)
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
: [EMAIL PROTECTED]
Weaving the knowledge tapestry'
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED]
---(end of broadcast)---
TIP 3
Hello,
yes - I had the same problem using dual xeon machines. The problem seems to be
related to the kernel that suffers from a lack of xeon cpu support. also the
intel compiler seems to get much faster binaries than the gcc does. I finally
skipped the whole xeon hardware for the use as
namespaces are still there.
Any ideas about that phenomena ?
best regards
-Andreas Schmitz
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED]
---(end
On Monday 17 February 2003 19:56, Tom Lane wrote:
Andreas Schmitz [EMAIL PROTECTED] writes:
I think it is not the same. When I ran the vaccum when no other clients
whe= re=20
connected to the database.
The vacuum that reports the NOTICEs is not the one that created the
problem
() failed: Broken pipe
regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED]
INFO: --Relation pg_catalog.pg_conversion--
INFO: Pages 2: Changed 0, reaped 0, Empty 0, New
On Friday 14 February 2003 17:55, Tom Lane wrote:
Andreas Schmitz [EMAIL PROTECTED] writes:
I have a problem with the vacuum full. every time I run the vacuum
command I loose data from the parent tables. maybe also from the
subtables (haven't checked yet). I tried it a few times up to now
400 sun4u 1.5 GB)
regards
-Andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you
On Thursday 13 February 2003 06:08, Tom Lane wrote:
Andreas Schmitz [EMAIL PROTECTED] writes:
I am still working on the newspaper archive project. I started indexing
the articles with tsearch. Along the long text parts I get a ERROR:
deadlock detected when I try to build the index update
referenced from
dpa_text not found in dpa
any ideas ?
regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED]
---(end of broadcast
already increased the number of locks per transaction. Any ideas on that ?
regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED]
---(end
size 1684144132
This started to happen when I increased memory sizes in the postgresql.conf.
regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED
Hello *,
I have a little problem with a database that is growing drastically. I am
getting short on diskspace within $PGDATA. Is there a way to use $PGDATA2 in
addition to $PGDATA with the same database ?
regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service
newsdb=# lock table dpa in lockmode exclusive;
ERROR: parser: parse error at or near lockmode at character 19
newsdb=#
Did I get it totally wrong and I am badly in need of some holidays or is there
something wrong with the syntax ?
kind regards,
-andreas
--
Andreas Schmitz - Phone +49 201 8501
On Monday 23 December 2002 18:35, Simone Tellini wrote:
lock dpa in exclusive mode;
thanks a lot. thats it.
regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED
On Monday 23 December 2002 18:54, Tom Lane wrote:
Andreas Schmitz [EMAIL PROTECTED] writes:
I have a little problem with a database that is growing drastically. I am
getting short on diskspace within $PGDATA. Is there a way to use $PGDATA2
in addition to $PGDATA with the same database
On Monday 23 December 2002 18:35, Simone Tellini wrote:
On Mon, 23 Dec 2002 18:02:24 +0100
Andreas Schmitz [EMAIL PROTECTED] wrote:
AS LOCK [ TABLE ] name [, ...] IN lockmode MODE
[...]
AS newsdb=# lock table dpa in lockmode 'exclusive';
AS ERROR: parser: parse error at or near lockmode
On Wednesday 04 December 2002 17:47, Tom Lane wrote:
Andreas Schmitz [EMAIL PROTECTED] writes:
ist there any way to cancel a user query as dba ?
Send a SIGINT to the backend process running that query, eg
kill -INT pid
This has the same effect as a user-requested cancel (eg ^C
Hello,
ist there any way to cancel a user query as dba ?
regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED]
---(end of broadcast
-2.03$
kind regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our
Hello *,
is there any way in postgres to define the size of extents ?
regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED]
---(end
On Tuesday 01 October 2002 17:18, Bruce Momjian wrote:
Andreas Schmitz wrote:
Hello *,
is there any way in postgres to define the size of extents ?
We don't have extents like Informix. We use the file system so size is
unlimited. I think that answers your question.
Not really. If I
that seems to be typical
for Xeon. Will postgres use this a a 4 CPU machine ? Is there any HT support
?
regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED
Hello *,
I've got a question concerning hardware. We're planning to replace our SUNS
(E3500,E3000,E450 etc) with multiprocessor XEON boards. Is there any
recommendation or experience about this type of hardware ?
kind regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb
34 matches
Mail list logo