R: [ADMIN] Out of memory...

rotation_size";"0" "log_statement";"none" "log_truncate_on_rotation";"off" "logging_collector";"on" "maintenance_work_mem";"300MB" "max_connections";"250" "max_stack_depth";&quo

[ADMIN] Out of memory...

nderstand 1) How can I understand what is filling up memory ? 2) How can I avoid (or limit) this kind of situations ? Thank you very much! Marco -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

R: [ADMIN] Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?

ATAL: role "postgres" does not exist vacuumdb: could not connect to database postgres: FATAL: role "postgres" does not exist .. If I launch it manually adding the -U mysuperuser option it works... Hope this is somehow useful Regards Marco -Messaggio or

[ADMIN] Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?

problem ? Thank you (I hope this is the right list to post this) Marco The output : -- -bash-3.2$ /usr/local/pgsql/bin/pg_upgrade -d /dbms/pgdata-8.4 -D /dbms/pgdata -b /usr/local/pgsql-8.4/bin -B /usr/local/pgsql/bin -l /tmp/pg_upgrade.log -v --user=mys

[ADMIN] Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?

blem ? Thank you (I hope this is the right list to post this) Marco The output : -- -bash-3.2$ /usr/local/pgsql/bin/pg_upgrade -d /dbms/pgdata-8.4 -D /dbms/pgdata -b /usr/local/pgsql-8.4/bin -B /usr/local/pgsql/bin -l /tmp/pg_upgrade.log -v --user=mys

[ADMIN] Database in recovery mode forever

t all Postgres process disappeared and I was able to restart Postgres. Now everything works.. Is there an explanation for this behaviour ? I include messages from the log and from the shell hoping is more clear. Thank you very much Marco --- 2009

Re: [ADMIN] fsync off without a restart

differ from the plain reload? And what does it > actually do under the hood? If you're referencing to the init script (/etc/init.d/postgresql-XXX), then they should be the same stuff. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ -- Sent via pgsql-admin mailing li

Re: [ADMIN] [GENERAL] Dumping/Restoring with constraints?

r any > advice. > > -- > Sent via pgsql-general mailing list ([EMAIL PROTECTED]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > Isn't the --disable-triggers working for you? -- Marco Bizzarri http://iliveinpisa.blogspot.co

Re: [ADMIN] Looking for an E/R tool for Postgres

On Dec 17, 2007 12:58 PM, Mark Steben <[EMAIL PROTECTED]> wrote: > Does anybody have suggestions as to what Entity_Relationship diagram tool > > Is out there that'll work for Postgres? dbwrench: http://www.dbwrench.com/ -- Saludos y abrazos... Marco Antonio Frias Butrón

Re: [ADMIN] backup of postgres scheduled with cron

On Nov 22, 2007 2:53 PM, Andrew Sullivan <[EMAIL PROTECTED]> wrote: > On Thu, Nov 22, 2007 at 02:28:08PM +0100, Marco Bizzarri wrote: > > > > why don't you add a "MAILTO=" at the start of your > > crontab file, so that you can receive a report of the probl

Re: [ADMIN] backup of postgres scheduled with cron

On Nov 22, 2007 2:46 PM, Sorin N. Ciolofan <[EMAIL PROTECTED]> wrote: > Hi Marco! > > Thank you for the advice. > > I got: > > /home/swkm/services/test/backup.sh: line 4: pg_dump: command not found > updating: mydb_dump_22-11-07.out (stored 0%) > > which see

Re: [ADMIN] backup of postgres scheduled with cron

backups manually. The script > itself is executed fine if run manually but run on cron scheduler I got an > mydb_dump_$time.out file empty (of 0 kb) > > Do you have any idea about what's wrong? > > Thanks > Sorin > Hi Sorin, why don't you add a &q

Re: [ADMIN] Fastest DB restore options

out, you can always throw all away and start from scratch... Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] PgAdmin : table backup problem

s = off pg_dump: dumping contents of table collezioni I also tried to copy pg_dump.exe from a Postgres 8.2.3 install into the PgAdmin directory. The only result has been to eliminate the version mismatch problem. Thank you for any advice Marco Cassiano Manifatture del Nord srl unipersonale

[ADMIN] Logfile permission

? Thanks everyone   Marco Cassiano   Manifatture del Nord srl unipersonaleGruppo MaxMara viale Regina Elena 13-15 42100 Reggio Emilia RE ITALY Sede operativa:via Mazzacurati 642100 Reggio Emilia REITALY Tel. +39 0522 358215 Fax +39 0522 268715 email : [EMAIL PROTECTED

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

On 9/11/06, Purusothaman A <[EMAIL PROTECTED]> wrote: Hi Marco Bizzarri and Martijn van Oosterhout, Thanks for your valuable reply. I am trying to execute all query from VC++ through CDatabase::ExecuteSQL(sQueryString) function call. ie, via programming, not by manual entering

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

0); lo_close -- 0 (1 row) (you closed the file). commit ; COMMIT In this way, you created a new large object, and stored a string of 4 bytes inside of it. Regards Marco On 9/11/06, Purusothaman A <[EMAIL PROTECTED]> wrote: Thanks Martijn van Oosterhout and Marco Bizzarri. But, acc

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

ilabe (www.paflow.it): look in the Documents.py source, and look for the lo_xxx queries. This is indipendent from the fact that client and server are running on the same server. Regards Marco On 9/11/06, Purusothaman A <[EMAIL PROTECTED]> wrote: Thanks Martijn van Oosterhout, So, I have

[ADMIN] Checking what is the current query running

Hi all. I've a postgresql where sometimes a process can remaing running a query for a very long time. Aside from logging the queries, is there a way to know which query is running in one particular moment? Regards Marco -- Marco Bizzarri http://notenotturne.blogspo

Re: [ADMIN] reg:lo_write

Did you look at this example? http://www.redhat.com/docs/manuals/database/RHDB-7.1.3-Manual/prog/largeobjects.html (I think you can find better example in the postgresql documentation, this was the first one I found) On 6/22/06, Marco Bizzarri <[EMAIL PROTECTED]> wrote: Hi Sandhya. O

Re: [ADMIN] reg:lo_write

how can i over come this problem?So that i can proceed further - Original Message - From: "Marco Bizzarri" <[EMAIL PROTECTED]> To: "sandhya" <[EMAIL PROTECTED]> Cc: "Postgres" Sent: Thursday, June 22, 2006 1:43 PM Subject: Re: [ADMIN] reg:

Re: [ADMIN] reg:lo_write

rting some experience. Regards Marco On 6/22/06, sandhya <[EMAIL PROTECTED]> wrote: Hi, If i use lo_write in different function to write data into an object,Will there be any problem? like, I open my object and add data into it and in another function if i again open the same object and add

Re: [ADMIN] Howto get tranaction rate in postgres

Hi, I mean the transactions over time interval. Say the current db transactions per minute. Thanks Marco -Original Message- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 3:41 PM To: Meyer Marco Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Howto get

[ADMIN] How to mesure transaction rate in Postgres

Help. Marco

[ADMIN] Howto get tranaction rate in postgres

Title: Howto get tranaction rate in postgres Hello, I've been asked to give the transaction rate of a deployed system. How can I mesure this in postgres. Could not find anything in the documentation. Are there any tools for this. Thanx for your help Marco

[ADMIN] table disappear from pg_class

Hi all, I have a problem with a table which is disappeared from pg_class with all objects related (views, indexes and so on). pg_dump against this table does not work (I think because it is not present in pg_class). The strange behaviour is that I can select data from this table !! We are using a

[ADMIN] Replication

Can PostgreSQL do replication ? If possible could guide me in the right direction. Regards Marco Rademeyer Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests

Re: [ADMIN] Database disappeared

a vacuum. Thanks for the VACUUM idea. I thought it was happening every Sunday. Thanks for the help. Regards Marco On Wed, 2005-07-27 at 10:23 -0400, Tom Lane wrote: > Marco Rademeyer <[EMAIL PROTECTED]> writes: > > I have a very strange problem. > > I was importing abou

[ADMIN] Database disappeared

there. When logged into the databases \d gives me the following output: 'no relations found ' Is there any way that I can put these relations back? Any help would be great. Regards Marco Rademeyer Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If

[ADMIN] Problems with starting/stoping Postmaster if homedir is not available

cial-conf file (don't know how this binary handles the $USER Variable if not using "su". Marco ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[ADMIN] multiple servers updating from/to one

understand I say, I try to be more clear). Cheers, Marco Carvalho ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [ADMIN] Application gui

There are 2 that I know of. pgaccess and pgadmin3 On Debian you can do an apt-get to get them Regards Marco On Tue, 2005-03-01 at 15:48 -0300, Philip Pinkerton wrote: > I am looking for an application builder to create an application to > enter client data into the database. &g

[ADMIN] ALTER TABLE help.

s the auto increment field set, but it is only for the new fields that get added. this is what I have done: step one : CREATE TABLE num_table (num SERIAL); step two : ALTER TABLE test_stock ALTER COLUMN num SET DEFAULT nextval(num_table_num_seq'); But this is how far I got. Regards Ma

[ADMIN] ALTER TABLE help.

s the auto increment field set, but it is only for the new fields that get added. this is what I have done: step one : CREATE TABLE num_table (num SERIAL); step two : ALTER TABLE test_stock ALTER COLUMN num SET DEFAULT nextval(num_table_num_seq'); But this is how far I got. Regards Ma

Re: [ADMIN] Como usar MDB Tools

en http://rpm.pbone.net/index.php3/stat/11/vendor/1870/com/mdbtools_sourceforge_net.html despues de instalarla copie el archivo de acces a mi maquina de linux y ahi lo abri con la aplicacion gmdb2 y en ayuda te dice como migrarla a postgresql. atetamente marco antonio pacheco Christian Hache

[ADMIN] Panic involving a LC_COLLATE issue

le(). It looks like you need to initdb. Aborted Any ideas on how to solve this, desesperatly yours -- Marco Gaiani Unidad de Promoción y Relaciones FUNDACITE ARAGUA mailto: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/readi

[ADMIN] array[10]

hi there, i have got a problem concerning arrays in postgres i created a function in which i want to know if the index 8 of var_array ist not NULL: IF var_array[8] IS NOT NULL THEN (query)

[ADMIN] Oracle to PostgreSQL

Hi, I need to port data from an Oracle 8.0 base to PostgreSQL 7.2. I have scripts to create the base on Oracle and PostgreSQL (it is about 40 tables), but I need to port a great amount of data to PostgreSQL. Can anybody help me? Thanks, Marco Roda <> ---(end of bro

[ADMIN] Doubt about Database Migration Wizard

Gents, Whent I try to use Database Migration Wizard through pgAdminII and I select the MS Jet Ole DB in order to import a MS Access Database to PostgreSQL, there is a field named Provider String that I don't know what it means. Can you tell me what is this? Thank you. Rgds, Marco Au

[ADMIN] change datatypes

t work! i hope you can help me! thx marco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] User Defined Function

, and recreate , but...) ... I have another way to use my fuctions to validate datas ? regards, Tulio Marco Tulio Desenvolvimento de sistemas para Internet __ Quer ter seu próprio endereço na Internet? Garanta já o seu e

Re: [ADMIN] How to include plpgsql in table pg_language

> > On Fri, 15 Feb 2002, Pam Wampler wrote: > Goods documentations are in: www.postgresql.org/idocs And the excelent book of Bruce Momjian : http://www.postgresql.org/docs/aw_pgsql_book/index.html I sugest you studie too the SPI interface, and make "C" programs to contro

Re: [ADMIN] hanging psql session while granting...

er user to other user... > > How can i change the Grants over tables to other users ... is there any > round about way ? > Or where could be the problem. > > > Thanks > laks You can´t do that. Only the postgres super-user or the table creator can change this pe

Re: [ADMIN] How to include plpgsql in table pg_language

hanks > Pam > on console, as postgres user, type: createlang --dbname=dbtest --pglib=/usr/local/pgsql/lib pspgsql And have fun ! Marco Tulio Desenvolvimento de sistemas para Internet __ Quer ter seu próprio end

[ADMIN] null date fields

: INSERT INTO order (order_id, sales) VALUES (1,''); And I need write codes for translate the porting to: INSERT INTO order (order_id, sales) VALUES (1,NULL); Has any place to change this in configuration directory ? ((I need say that´s my English is soo poor ?? :-)) --- Marco Tul

Re: [ADMIN] Compile directive -8k limit

> What directives do I have to configure when compiling Postgresql 7.1 (on > Solaris and Debian/Gnu Linux) to remove the 8k record size limit? Since version 7.1 there is no limit in the row size. OK, the row size has a limit of 2 GB I think. ---(end of broadcast)---

[ADMIN] Backend closed the channel unexpectedly

you can help me. Thanks in advance, Marco A. Bravo