Re: [ADMIN] Canot access PostgreSQL via psql -h (Vmware Fusion)

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

Re: [ADMIN] Canot access PostgreSQL via psql -h (Vmware Fusion)

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

Re: [ADMIN] Restore a backup to a different disk?

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

Re: [ADMIN] Filesystem and PG configuration

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

Re: [ADMIN] Restore DataBase

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,

Re: [ADMIN] Corrupted database - how to recover

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

[ADMIN] pg_clog after crash

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

Re: [ADMIN] parametrized query

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

[ADMIN] Problems with select lower()

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 ?

Re: [ADMIN] another pg database corruption?

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

Re: [ADMIN] Installing plpgsql fails

-- 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]

Re: [ADMIN] Blob Data type in postgres ?

: [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

Re: [ADMIN] Postgresql slow on XEON 2.4ghz/1gb ram

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

[ADMIN] Using temp tables

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

Re: [ADMIN] Still a bug in the VACUUM ??? !!!

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

Re: [ADMIN] Still a bug in the VACUUM ??? !!!

() 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

Re: [ADMIN] Still a bug in the VACUUM ??? !!!

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

[ADMIN] Still a bug in the VACUUM ??? !!!

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

Re: [ADMIN] ERROR: deadlock detected

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

Re: [ADMIN] ERROR: deadlock detected -referential integrity violation

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

[ADMIN] ERROR: deadlock detected

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

[ADMIN] dbsize

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

[ADMIN] add space to expand database ?

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

[ADMIN] locking a table

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

Re: [ADMIN] locking a table

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

Re: [ADMIN] add space to expand database ?

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

Re: [ADMIN] locking a table

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

Re: [ADMIN] how to cancel a query ?

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

[ADMIN] how to cancel a query ?

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

[ADMIN] problems dumping

-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

[ADMIN] Extent size

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

Re: [ADMIN] Extent size

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

Re: [ADMIN] hardware question

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

[ADMIN] hardware question

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