[ADMIN] Can I restrict backups?

Hi, now this might be a bit of a silly question, but I'll give it a shot anyway. I'm working on a remote database for a few employees of a rather small startup company where at least a few will get teleworking jobs. They'll get a ms-access application that connects via ODBC from their home. T

Re: [ADMIN] Can I restrict backups?

Scott Marlowe schrieb: Andreas wrote: now this might be a bit of a silly question, but I'll give it a shot anyway. I'm working on a remote database for a few employees of a rather small startup company where at least a few will get teleworking jobs. They'll get a ms-access a

[ADMIN] Need a wee bit more info on PostgreSQL's SSL security options

t-side topic is rather thin for a newbie. Regards Andreas ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [ADMIN] Need a wee bit more info on PostgreSQL's SSL security options

company anymore. You could find such a scenario in many companies or even schools/univeresities, I guess. I'd like to have some input from people who allready went through this issues. Regards Andreas Ray Stell schrieb: Read the entries listed here: http://archives.postgresql.org/pgsq

Re: [ADMIN] Need a wee bit more info on PostgreSQL's SSL security options

Well, I think I got this CertificateRevocationList file right but PostgreSQL 8.1.8 seems to ignore it. At least if it is enough to host this root.crl file in the DB's data directory and restart postmaster. OpenSSL says my test client's certificate was revoked but I still get a ssl-connection

Re: [ADMIN] ssl and odbc standar driver

In deed it is possible. You'll need a ssl certificate and a private key and put it on c: in your users \application data\postgresql directory. You'll have to create the postgresql-directory first. The certificate has to be namedpostgresql.crt and the key postgresql.key. Now you can

Re: [ADMIN] ssl and odbc standar driver

Fabricio Peñuelas schrieb: I need to install something in the client? Well, you obviously need the ODBC driver on the client The certificate has to be namedpostgresql.crt and the key postgresql.key. this is for the client? Yes. You need a key+cert pair for your client, too. And it sh

Re: [ADMIN] run postgres.exe as a Windows Administrative account

Hi, don't confuse the user who initiates the starting process of the DB (double click on the icon) with the one the DB runs under. As far as I know, there should be an unprivileged user e.g. "postgres". "administrator" starts postmaster in the unprivileged context of "postgres" when you start

[ADMIN] let users change their password

Hi, how can I let users change their own password but noone else's ? I could restrict this within our client-app but then I'm skrewed when some smarty connects directly with psql. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://w

Re: [ADMIN] let users change their password

Am 25.08.2010 03:29, schrieb Tom Lane: Andreas writes: how can I let users change their own password but noone else's ? Uh, that's the normal behavior, no? At least for non-superusers. aarghl ... right ... 8-} Thanks Tom Now, lets make it more difficult then. Is there a w

[ADMIN] 5 pg_toast_temp and pg_temp schemas ?

Hi, I just recently activated the system objects in pgAdmin. Now I'm wondering if it's normal to have 5 pg_toast_temp and 5 pg_temp schemas. It's a PG 8.4.0 server of the OpenSuse distribution that works pretty well. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make c

[ADMIN] I've got gaps in the log files?

Hi, it appeares I've got gaps in the log files. It's a PG 9.1 from the OpenSuse 12.1 distribution. I know the server is running so it should dump it's feelings all the time in those files in PGDATA/pg_log. But I find huge gaps where nothing is written. E.g. yesterday the last entry is at 09.5

Re: [ADMIN] I've got gaps in the log files?

Am 06.03.2012 18:38, schrieb Tom Lane: Andreas writes: it appeares I've got gaps in the log files. It's a PG 9.1 from the OpenSuse 12.1 distribution. I know the server is running so it should dump it's feelings all the time in those files in PGDATA/pg_log. But I find huge gaps w

[ADMIN] Can't increase shared_buffers for PostgreSQL on openSUSE 12.3

something higher, PG won't start anymore. I had the same issue back with openSUSE 12.1 and it was solved when I switched from systemd back to sysvinit. How can I get more memory for PG on openSUSE 12.3 ? Regards Andreas -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To

[ADMIN] Re: [GENERAL] Can't increase shared_buffers for PostgreSQL on openSUSE 12.3

Am 14.06.2013 20:55, schrieb Peter Geoghegan: On Fri, Jun 14, 2013 at 11:55 AM, Andreas wrote: How can I get more memory for PG on openSUSE 12.3 ? http://www.postgresql.org/docs/9.2/static/kernel-resources.html OK I think that did it :) I'm just wondering what point it could be t

[ADMIN] libpq++ question

. Can anybody help? BTW, the returned error message, called as in the examples by data.ErrorMessage(), is empty. Cheers, Andreas please cc any answers to [EMAIL PROTECTED]

[ADMIN] security issues

Hello seems like my mail to pgsql-novice is being ignored so I'll try here. How can I let local users connect with their own ID locally without having to enter a password, but disallow them to reconnect - with \connect - as another user - either completely or allow it only using a password. Rig

[ADMIN] Postgres performance

would be thankful. Perhaps you can tell me what bandwidth we should reserve, too. Thanks a lot Andreas

[ADMIN] Install problems

can't parse "template1" initdb: could not log template database initdb: cleaning up. Unfortunately i have no clue what causes this error perhaps you can help me. thank you andreas gietl -- andreas gietl dedicated server systems fon +49 9402 2551 fax +4

[ADMIN] PostgreSQL 7.0.3 vacuum and insert problems

Hi, We are an ISP running our radius on postgres version 7.0.2 on an twin Intel 550 processor with Solaris 7 and 600Mb RAM : 1. We have a database with 8 tables one of these tables (TABLE1) gets updated every second or so as a result the table keeps growing and growing and growing... to about 5

[ADMIN] pgAdmin guru hints

/docs/en_US/hints/ You're invited to make your comments on the hints: are these correct, is there something missing or misleading? Regards, Andreas ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to

Re: [ADMIN] Installing plpgsql fails

Hi, edit the script called "createlang" and adjust PGLIB='$libdir'. regards -Andreas On Wednesday 08 October 2003 13:19, Nigel Bishop wrote: > Hi > > Solaris 8 > PG V7.3.3 > > I'm trying to install the procedural language plpgsql using: > &g

Re: [ADMIN] another pg database corruption?

ware (board,cpu etc.) might 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

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

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:

[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] pg_clog after crash

Hi Tom, PostgreSQL 7.4.1 is used in this case. I was able to fix the clog by dd if=/dev/zero bs=8k count=1 >> Andreas Schmitz <[EMAIL PROTECTED]> writes: > > after a harddisk filling up to a 100% the database crashed. This is > > the output I get when I try to start th

Re: [ADMIN] Application gui

. Your GUI written with Qt will be nearly independent from database and operating system. -- Andreas Motzkus inmess GmbH Frankfurter Str. 74 64521 Gross Gerau Tel.: +49 6152 9779 11 Fax.: +49 6152 9779 20 Email: [EMAIL PROTECTED] www.inmess.de > I am looking for an application builder to create

Re: [PERFORM] [ADMIN] Postgres VS Oracle

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It's even harder, as Oracle disallows publishing benchmark figures in their license. As a cynic, I might ask, what Oracle is fearing? Andreas Jonah H. Harris wrote: > On 6/18/07, David Tokmatchi <[EMAIL PROTECTED]> wrote:

Re: [PERFORM] [ADMIN] Postgres VS Oracle

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jonah H. Harris wrote: > On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote: >> As a cynic, I might ask, what Oracle is fearing? > > As a realist, I might ask, how many times do we have to answer this > type of anti-comm

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

for many, >> many thousands (if not hundreds of thousands) of dollars. > > Oracle also fears benchmarks made by people who don't know how to > tune Oracle properly... Well, bad results are as interesting as good results. And this problems applies to all other databases. A

Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

er. And philosophically, the query optimizer in MySQL is near perfect. OTOH, considering the fact that many operations in MySQL still have just one way to execute, it's easy to choose the fastest plan, isn't it *g*) Andreas -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (GN

Re: [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

e with PG. It's hard to quantify how many of these cases there are performance-wise, well, because Oracle insists on that silly NDA, but there are clearly cases where PG is superior. Andreas -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (GNU/Linux) Comment

[ADMIN] Restore dump into different databases/owners

? I really don't want to manually set ownership of hundreds of database objects like tables, functions, domains, sequences, ... Please tell me I just overlooked the obvious... ;-) - - andreas - -- Andreas Haumer | mailto:[EMAIL PROTECTED] *x Software + Systeme | h

Re: [ADMIN] Restore dump into different databases/owners

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! Just a short followup... Andreas Haumer schrieb: > Hi! > > I must be blind or something but it seems I just can't > figure out a working procedure to restore a PG dump in > custom format (created with "pg_dump -Fc"

Re: [ADMIN] Restore dump into different databases/owners

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Tom! Thanks for your reply! Tom Lane schrieb: > Andreas Haumer <[EMAIL PROTECTED]> writes: >> I now solved it by temporarily adding the "superuser" privilege >> to the roles in question. > > That sho

[ADMIN] Advice on running two database clusters on one server machine

account? We have no prior experience with PostgeSQL administration, having run our previous systems on Windows Servers and MS SQL Server. Thanks to all for your input! -- Andreas Philipp Clínica Universitaria Teletón Chía, Colombia -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org

[ADMIN] Advice on running two database clusters on one server machine

take into account? We have no prior experience with PostgeSQL administration, having run our previous systems on Windows Servers and MS SQL Server. Thanks to all for your input! Andreas Philipp Clínica Universitaria Teletón Chía, Colombia -- Sent via pgsql-admin mailing list (pgsql-admin

[ADMIN] Advice on running two database clusters on one server machine

take into account? We have no prior experience with PostgeSQL administration, having run our previous systems on Windows Servers and MS SQL Server. Thanks to all for your input! Andreas Philipp Clínica Universitaria Teletón Chía, Colombia -- Sent via pgsql-admin mailing list (pgsql-admin

[ADMIN] Replication, HA ...?

Hello, I have a webserver with postgresql. I would have a backup from this database. It should also be possible to query this backup solution. So I think slony would be a good choice. Am I right? Thanks for answers Andreas -- Kraftl EDV - Dienstleistungen Schulungen, Linux, Linuxlösungen

[ADMIN] MD5 password issue

192.168.97.30? That sould not be possible ... or am I wrong? Thanks for any advice Cheers Andy - -- St.Pauli - Hamburg - Germany Andreas Wenk -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http:/

Re: [ADMIN] autovacuum daemon

acuum; way easiere than my approach ;-) Thanks! Andy - -- St.Pauli - Hamburg - Germany Andreas Wenk > > If it says "on", then it is working. > -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJd

Re: [ADMIN] grant question

o musicians; GRANT roletest=# \c roletest tena You are now connected to database "roletest" as user "tena". roletest=> SELECT * FROM test; id | value +--- (0 rows) Cheers Andy -- St.Pauli - Hamburg - Germany Andreas Wenk Regards, Tena Sakai tsa...@gallo.ucsf.e

Re: [ADMIN] grant question

elp ... Cheers Andy Tena Sakai tsa...@gallo.ucsf.edu -Original Message- From: Tena Sakai Sent: Sat 2/28/2009 3:04 PM To: Tena Sakai; Andreas Wenk Cc: pgsql-admin@postgresql.org Subject: RE: [ADMIN] grant question Hi, Maybe I found the underlying problem... too psql, I typed: canon=# \dn ga

Re: [ADMIN] Where 8.4.0 binaries-no-installer for win32

dayat schrieb: Hi pgsql admins, I think the postgresql 8.4.0 binaries-no-installer for win32 exists in http://www.postgresql.org/ftp/binary/v8.4.0/win32/ . Who are know where I can to get this file. Thank you very much, Hidayat Hi dayat, AFAIC there is no binary for windows maintained at all

Re: [ADMIN] Enhancement - code completion when typing set search_path

Campbell, Lance schrieb: I use postgres 8.1.X. Is there a way to add code completion when entering: set search_path = xyz I love the code completion for SQL. It would be really nice to have it for the "set search_path". me too ;-) you should send this request to the hackers list ... may

Re: [ADMIN] implement ldap authentication in PostgreSQL

mitra nazemian schrieb: hi, I want too implement ldap authentication in PostgreSQL in linux, but I cant. Please help me... Tanx Hi, first you should understand the basics of authentication in postgresql. http://www.postgresql.org/docs/current/static/client-authentication.html Then jump to thi

Re: [ADMIN] implement ldap authentication in PostgreSQL

mitra nazemian schrieb: thanks but I has read them. I dont understand where I shoud spacify the cn, dn in postgresql too use them in pg_hba.conf. please help me On Mon, Jul 20, 2009 at 11:50 AM, Andreas Wenk mailto:a.w...@netzmeister-st-pauli.de>> wrote: mitra nazemian s

Re: [ADMIN] implement ldap authentication in PostgreSQL

Andreas Wenk schrieb: mitra nazemian schrieb: thanks but I has read them. I dont understand where I shoud spacify the cn, dn in postgresql too use them in pg_hba.conf. please help me On Mon, Jul 20, 2009 at 11:50 AM, Andreas Wenk <mailto:a.w...@netzmeister-st-pauli.de>> wrote:

Re: [ADMIN] implement ldap authentication in PostgreSQL

use it. What I've shown is the way you can handle a ldap authentication and that's it what you can do or have to set up in postgresql's pg_hba.conf. The rest is not related to postgresql at all (setting up a directory in ldap and so on). Cheers Andy On Tue, Jul 21, 2009 at 1

Re: [ADMIN] implement ldap authentication in PostgreSQL

mitra nazemian schrieb: Excuse me, I have another question. should I run ldapserver in linux for using ldap autentication in PostgreSQL? Thanks most likely http://en.wikipedia.org/wiki/Ldap is your friend to get some basic info ... this could also be of interest: http://www.openldap.org/ O

Re: [ADMIN] complie postgresql with kerberos in centos

rahimeh khodadadi schrieb: Nobody does me help. Please. first it's sunday - so maybe some of the people who may answer your questions have an off day ;-). On the other hand you should be patient. As Tom allready mentioned, all dependent packges have to be installed. I was running in some pr

Re: [ADMIN] complie postgresql with kerberos in centos

Devrim GÜNDÜZ schrieb: CentOS/Red Hat/Fedora has (development snapshots of) 8.4 since Sep 3, 2008. :) http://archives.postgresql.org/pgsql-hackers/2008-09/msg00208.php good to know - thanks ;-) -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscript

Re: [ADMIN] force varchar column to be lowercase

Kevin Kempter schrieb: Can I use a check constraint, or something other than a function to force a column to be lowercase only? Thx in advance try to use regexp in your CHECK CONSTRAINT: CHECK (column::bpchar ~ '^[a-z]+$'::bpchar::text) Cheers Andy -- Sent via pgsql-admin mailing list (p

Re: [ADMIN] force varchar column to be lowercase

Greg Stark schrieb: On Tue, Jul 28, 2009 at 11:15 AM, Andreas Wenk wrote: Kevin Kempter schrieb: Can I use a check constraint, or something other than a function to force a column to be lowercase only? Thx in advance try to use regexp in your CHECK CONSTRAINT: CHECK (column::bpchar ~ 

[ADMIN] pg_standby doesnt't work

Hi, I'm testing serveral days a replication-system with PostgreSQL, but I get allways the same error. 2009-10-25 15:44:45 CET FATAL: XX000: could not restore file "0001.history" from archive: return code -1073741811 The restore_command is: restore_command = 'pg_standby.exe -d -s 5 -t C:\

Re: [ADMIN] pg_standby doesnt't work

2009 03:36 An: Andreas Schmidt Cc: pgsql-admin@postgresql.org; PostgreSQL-development Betreff: Re: [ADMIN] pg_standby doesnt't work Hi, On Mon, Oct 26, 2009 at 12:34 AM, Andreas Schmidt wrote: > I'm testing serveral days a replication-system with PostgreSQL, but I get > a

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

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

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 wit

Re: [ADMIN] Monitoring PostgreSQL on Windows 2003

You can use select client_addr, current_query from pg_stat_activity; to show all db-connection and the running queries. Regards, murphy Von: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] Im Auftrag von Vítor Gesendet: Freitag, 2. Juli 2010 14:10 An: pgsql-admin@po

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

[ADMIN] alter table without an ACCESS EXCLUSIVE lock

Hi, i'm searching for a solution for changing the type of a column, e.g. from varchar(128) to varchar(512), without an ACCESS EXCLUSIVE lock. The issue is that the relation is nearly 100 million rows big and in our environment every second of downtime is very bad. In my current setup a slave datab

[ADMIN] alter table without ACCESS EXCLUSIVE lock

Hi, i'm searching for a solution for changing the type of a column, e.g. from varchar(128) to varchar(512), without an ACCESS EXCLUSIVE lock. The issue is that the relation is nearly 100 million rows big and in our environment every second of downtime is very bad. In my current setup a slave datab

Re: [ADMIN] alter table without an ACCESS EXCLUSIVE lock

an index). When using skytools I can keep the downtime minimal by doing a master slave change after modifying the slave db. But the question now is, is it possible to use wal shipping without having downtimes when modifying tables? regards, Andi On 2011-06-16 20:21, Tom Lane wrote: > Andr

Re: [ADMIN] alter table without an ACCESS EXCLUSIVE lock

an index). When using skytools I can keep the downtime minimal by doing a master slave change after modifying the slave db. But the question now is, is it possible to use wal shipping without having downtimes when modifying tables? regards, Andi On 2011-06-16 20:21, Tom Lane wrote: > Andr

Re: [ADMIN] Best practise for upgrade of 24GB+ database

On Fri, Jan 20, 2012 at 16:45, Nicholson, Brad (Toronto, ON, CA) wrote: > In the past I've used Slony to upgrade much larger database clusters than > yours with minimal down time (I'm talking seconds for the actual master > switch).  You set up a new replica on the new version and then move 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 installe

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

Re: [ADMIN] pgdumpall_file is bigger than 2 Gigabyte

gt; Thanks a lot > > DAvid Hello I guess "split" and "gzip" are your friends. You can pipe the "pgdumpall" to "split" with option to cut the file into pieces. Recommended is to use also "gzip" or similar to compress the files. Hope this help

Re: [ADMIN] Problem

error: no acceptable cc found in $PATH" Your Problem obviously seems to be a missing compiler. First install the GNU Compiler, then run configure again... begin:vcard n:Hierling;Andreas x-mozilla-html:FALSE org:LAUT.de;Softwareentwicklung adr:;; version:2.1 email;internet:[E

[ADMIN] Set Passsword for existing User

egin:vcard n:Hierling;Andreas x-mozilla-html:FALSE org:LAUT.de;Softwareentwicklung adr:;; version:2.1 email;internet:[EMAIL PROTECTED] note;quoted-printable:---=0D=0Ahttp://www.laut.de - DER Musikkanal=0D=0A--- x-mozilla-cpt:;0 fn:Andrea

Re: [ADMIN] sql by length of data

Kristopher Yates wrote: > > select a, b, c where length(a=2); > > How do you do this? I couldn't find a postgres command for this kind of > call. SELECT a, b, c FROM table WHERE LENGTH(a) = 2; best regards -- And

[ADMIN] Postgresql support

Hi, is here anybody in this list who support Postgresql installations in Munich, Germany? Greetings, Andreas ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

[ADMIN] URGENT: pg_restore problem

mping to create an ascii(?) dump. Any ideas? Greetings, Andreas I know I should analyse the database to find the problem but there is no time. We need it on a notebook for a demo ;-) ---(end of broadcast)--- TIP 5: Have you checked our ex

Re: [ADMIN] URGENT: pg_restore problem

... dumped with pg_dump -Fp -- Andreas Andreas Schlegel wrote: > Hi, > > I tried to restore a pg database with pg_restore -d but the operation > was running on error: > ERROR: Relation "..." does not exist > The database was dumped with pg_dump -Ft > > As

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

Re: [ADMIN] hardware question

The system shows 4 CPUs 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 -

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

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 thi

[ADMIN] problems dumping

test2 bash-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

Re: [ADMIN] problems dumping

On Wednesday 16 October 2002 06:54, Jyry Kuukkanen wrote: > On Tue, 15 Oct 2002, Andreas Schmitz wrote: > > I have a problem dumping with 7.2.3. When I do a pg_dumpall redirecting > > this to a file I have >4 lines of schema and data. Running psql > > template1 <

[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

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 > > This has the same effe

[ADMIN] how to dump and restore unicode databases?

i have two machines, one with postgres 7.2.X and one with 7.3. Both their encodings are set to UNICODE. on the first i have crated a unicode database, with german, swedish and english texts, more to come. on that machine i dump the db with pg_dump -c -s ncg and pg_dump -D -a ncg. on that machine i

[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

uot; at character 19 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 -- A

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 PROTEC

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 additi

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'; >

[ADMIN] dbsize

yContextAlloc: invalid request 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

Re: [ADMIN] dbsize

, open_sync, or open_datasync wal_debug = 0 # range 0-16 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 broadcas

[ADMIN] ERROR: deadlock detected

t of 356437 datarows. I 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] --

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 d

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

enced 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 broa

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 NOTICE

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

solaris 8 (E450 4x 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)---

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&#

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

Feb 17 11:19:36 postgres2 postgres[1803]: [ID 553393 local0.info] [5] LOG: pq_flush: send() 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 PROTEC

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

s build on that datarows 'cause no long text was inserted. I filled the empty fields with the "" string. But it didn't help. can someone give me some advise on this. thanks and regards -andreas -- Andreas Schmitz - Phone +49 201 8501 318 Cityweb-Technik-Service-Gesellsc

  1   2   >