Re: [ADMIN] Postgre Eating Up Too Much RAM

On Wed, Jan 2, 2013 at 1:38 AM, Jesper Krogh jes...@krogh.cc wrote: I do suspect you have too much IO going on for the hardware. I would trim down. /proc/sys/vm/dirty_ratio and dirty_background_ratio to 2 and 1 and see if the problem goes away. And establish graphing of the io-wait numbers

Re: [ADMIN] Postgre Eating Up Too Much RAM

I replied to this a few days ago but forgot to include the group. It appears that increasing our server swap space has fixed our problems. I will keep my fingers crossed. (there are currently a little over 200 active connections to the database): How many cores do you have on the

Fwd: [ADMIN] Postgre Eating Up Too Much RAM

I replied to this a few days ago but forgot to include the group. It appears that increasing our server swap space has fixed our problems. I will keep my fingers crossed. (there are currently a little over 200 active connections to the database): How many cores do you have on the

Re: [ADMIN] Postgre Eating Up Too Much RAM

of the problem - something I could put in a cron job or a monitor app I could run on the server that would at least tell us what is going on if / when it happens again? Thanks for all the help! Aaron == Aaron Bono Aranya Software

[ADMIN] Postgre Eating Up Too Much RAM

== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ==

[ADMIN] System in Recovery Mode

finished querying and updating the database. This batch runs constantly and has not been changed in months. What are the things that could be causing this? Thanks! Aaron -- == Aaron Bono Aranya Software Technologies, Inc

Re: [ADMIN] System in Recovery Mode

On Mon, Feb 25, 2008 at 9:42 AM, Simon Riggs [EMAIL PROTECTED] wrote: On Mon, 2008-02-25 at 08:11 -0600, Aaron Bono wrote: Our database was going along just fine this morning when, out of the blue, we started getting the following errors: FATAL: the database system is in recovery mode

Re: [ADMIN] System in Recovery Mode

On Mon, Feb 25, 2008 at 10:48 AM, Simon Riggs [EMAIL PROTECTED] wrote: On Mon, 2008-02-25 at 09:53 -0600, Aaron Bono wrote: 2008-02-25 07:15:24 CST username 127.0.0.1ERROR: unrecognized node type: 4260493 ... 2008-02-25 07:15:49 CST username 127.0.0.1CONTEXT: PL/pgSQL function

Re: [ADMIN] System in Recovery Mode

On Mon, Feb 25, 2008 at 9:53 AM, Aaron Bono [EMAIL PROTECTED] wrote: On Mon, Feb 25, 2008 at 9:42 AM, Simon Riggs [EMAIL PROTECTED] wrote: On Mon, 2008-02-25 at 08:11 -0600, Aaron Bono wrote: Now I am getting: 2008-02-25 10:51:08 CST username 127.0.0.1LOG: unexpected EOF on client

[ADMIN] System in Recovery Mode

finished querying and updating the database. This batch runs constantly and has not been changed in months. What are the things that could be causing this? Thanks! Aaron -- == Aaron Bono Aranya Software Technologies, Inc

Re: [ADMIN] System in Recovery Mode

On Mon, Feb 25, 2008 at 2:48 PM, Michael Monnerie [EMAIL PROTECTED] wrote: On Montag, 25. Februar 2008 Aaron Bono wrote: We did have a hard drive problem (errors on the drive) in the past and they had to swap out a drive. It is a RAID configuration so no backup/restore was necessary

Re: [ADMIN] example of insert timestamp

this? The sample on the page above looks like overkill.http://www.postgresql.org/docs/faq In your create table statement: create_dt TIMESTAMP WITHOUT TIME ZONE DEFAULT now() NOT NULL -- == Aaron Bono Aranya Software

Re: [ADMIN] example of insert timestamp

of your tables so you don't have to create a function for each table as long as the column name is the same. -Aaron -- == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ==

[ADMIN] ERROR: could not write block

to get more information? The database is still receiving data fine. Could this be a problem on the hard drive? Thanks, Aaron -- == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ==

Re: [ADMIN] Intermittent Postgres Connection refused Errors (JDBC)

? I would start by checking the PostgreSQL logs. If nothing shows up, it may be a network or application configuration issue. -Aaron -- == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http

Re: [ADMIN] Intermittent Postgres Connection refused Errors (JDBC)

PROTECTED] *On Behalf Of *Aaron Bono *Sent:* Tuesday, May 01, 2007 5:59 PM *To:* [EMAIL PROTECTED] *Cc:* pgsql-admin@postgresql.org *Subject:* Re: [ADMIN] Intermittent Postgres Connection refused Errors (JDBC) On 5/1/07, Srinivas Kotapally [EMAIL PROTECTED] wrote: Hi I am managing

Re: [ADMIN] Kill a Long Running Query

/pgsql-hackers-win32/2004-12/msg00039.php -- == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ==

Re: [ADMIN] [pgadmin-support] Motivations for PostgreSQL

database I use (I am an application service provider), they still make a big deal out of it. Thanks! http://br.messenger.yahoo.com/ -- == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http

Re: [ADMIN] PostgreSQL and Performance of Functions

On 12/1/06, Rajesh Kumar Mallah [EMAIL PROTECTED] wrote: On 12/1/06, Aaron Bono [EMAIL PROTECTED] wrote: Recently I have been put on a project that uses DB2 (not my choice). I am using functions for reports and was told this may not be allowed. They said: One gap is the ability

[ADMIN] PostgreSQL and Performance of Functions

normally use PostgreSQL for all my applications (this being an exception). Does anyone know what this statement is about and, more importantly, does PostgreSQL have the same limitations? Thanks, Aaron -- == Aaron Bono Aranya Software

[ADMIN] Monitoring PostgreSQL Process

PostgreSQL 8.1.5 on CentOS Linux. Thanks, Aaron -- == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ==

Re: [ADMIN] Monitoring PostgreSQL Process

and most frequently. -- Husam http://firstdba.googlepages.com -- *From:* [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] *On Behalf Of *Aaron Bono *Sent:* Tuesday, November 21, 2006 9:50 PM *To:* pgsql-admin@postgresql.org *Subject:* [ADMIN] Monitoring PostgreSQL

Re: [ADMIN] Monitoring PostgreSQL Process

. -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Aaron Bono *Sent:* Wednesday, November 22, 2006 1:46 PM *To:* Tomeh, Husam *Cc:* pgsql-admin@postgresql.org *Subject:* Re: [ADMIN] Monitoring PostgreSQL Process On 11/22/06, Tomeh, Husam [EMAIL PROTECTED] wrote

Re: [ADMIN] Monitoring PostgreSQL Process

. I know the application is causing the problem, I am just trying to figure out what part of the application is taking postgres so much. Thanks, Aaron -- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Aaron Bono *Sent:* Wednesday, November 22, 2006 1

Re: [ADMIN] Monitoring PostgreSQL Process

with the stats_command_string parameter turned on will give you some of the SQL per transaction:- SELECT datid, datname as DB Name, substr(procpid,1,6) as Procpid, substr(usesysid,1,5) as UseSysid, usename, current_query as SQL, query_start FROM pg_stat_activity order by procpid; On 11/22/06, Aaron Bono [EMAIL

Re: [ADMIN] Recursive use

/2001-11/msg00438.php-- == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com==

Re: [ADMIN] Copying data from table to table (cloned tables)

. -- == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com==

[ADMIN] Monitoring Connections

to fix in the application but I need to do some digging before I know this is indeed the problem. I am using PostgreSQL 8.1.3 on CentOS.Thanks!-- == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http

Re: [ADMIN] Monitoring Connections

, September 20, 2006 11:22 AMTo: Aaron Bono; pgsql adminSubject: Re: [ADMIN] Monitoring Connections Query the pg_stat_activity. For more detailed stats activities, you may query the pg_stat_* and pg_statio_* system views. http://www.postgresql.org/docs/8.0/static/monitoring.html -- Husam http

Re: [ADMIN] Combining output of several fields in SQL query

tableA;I get 1 as the result(which is not what I want).What does tableA look like (DDL and the data)?== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com==

Re: [ADMIN] Combining output of several fields in SQL query

:?column?4_21_23_2 Are you sure you are not getting the correct results? == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com==

Re: [ADMIN] SELECT and DATE Function question

On 9/11/06, Tom Lane [EMAIL PROTECTED] wrote: Aaron Bono [EMAIL PROTECTED] writes: Use: select start_date + (cast(number_of_days as text) || ' days')::interval from blah This is a pretty awful way to do it, much better isselect start_date + number_of_days * '1 day'::interval ...which reduces

Re: [ADMIN] SELECT and DATE Function question

this calculation? Use:select start_date + (cast(number_of_days as text) || ' days')::interval from blahSee http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html for more== Aaron Bono Aranya Software Technologies, Inc. http

Re: [ADMIN] archive logs recovery

stop access to the tables you are working with without having to change the pg_hba.conf or restarting the database. == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com==

Re: [ADMIN] Help about types please

to do this? Also list the tables and column types for tables you are selecting from and inserting into.== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com==

Re: [ADMIN] duplicate records after restore

backup/restore, I just use pg_dump to do the backup and then psql to import the backup. Note that before restoring, I drop the database and recreate it. This ensures the database is clean before the import. == Aaron Bono Aranya

Re: [ADMIN] pg_hba changes not honored

the postmaster, will it disconnect already connected clients or does it only reject new connections? I say this since you said doing a restart fixes the problem.== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http

Re: [ADMIN] Postgres Max JDBC Connection Allowed

because the default for users was to limit their memory and number of processes. == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com==

Re: [ADMIN] Strange UTF8 issue with pg_dump/pg_restore

it while compressed but you should be able to fix it after it is uncompressed, right? Have you tried to set the encoding just like the client before you do a restore from backup?== Aaron Bono Aranya Software Technologies, Inc. http

Re: [ADMIN] Getting rid of postgres output

redirecting standard output to /dev/null and sending the errors to your email? For example: pg_dump --clean -U postgres mydb | psql -q -h remote_host -d mydb -U postgres /dev/null 2 output_to_be_emailed.txt== Aaron Bono Aranya Software

Re: [ADMIN] running PostGres without installing it

you guys have would be deeply appreciated.== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com==

Re: [ADMIN] running PostGres without installing it

subquery support recently or not. == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com==

Re: [ADMIN] Controlling CPU Usage in PostgreSQL

On 7/31/06, Thomas Pundt [EMAIL PROTECTED] wrote: On Monday 31 July 2006 10:06, Aaron Bono wrote:| Is there a way I can tell PostgreSQL to give session a low priority so even| if it does take the full CPU, it only does so if it would otherwise be| idle? the nice command might do what you want...OK

Re: [ADMIN] Controlling CPU Usage in PostgreSQL

On 8/1/06, Scott Marlowe [EMAIL PROTECTED] wrote: On Tue, 2006-08-01 at 13:59, Aaron Bono wrote: On 7/31/06, Thomas Pundt [EMAIL PROTECTED] wrote: On Monday 31 July 2006 10:06, Aaron Bono wrote: | Is there a way I can tell PostgreSQL to give session a low priority so even | if it does take

[ADMIN] Controlling CPU Usage in PostgreSQL

== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com==

Re: [ADMIN] Scheduled backup in postgresql

. See:http://www.postgresql.org/docs/8.1/interactive/backup.html == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com==

Re: [ADMIN] ODBC connection problem

configuration issue than a PostgreSQL issue.What error message are you getting when it fails to connect? Did you add any debugging to the application? What does your connection string look like in each of the 3 above situations? == Aaron Bono

Re: [ADMIN] Read db files directly

again?You can dump the whole database contents with pg_dump. This dumps your whole database with data into a text file. Is this what you mean? == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com==

Re: [ADMIN] Out of memory when vacuuming

the memory limits for the postgres user? Try a ulimit on postgres. I had similar problems on my Linux server. == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com==

Re: [ADMIN] Insert NULL value with to_numeric()

());stmt.setTimestamp(index++, new java.sql.Timestamp(value2.getTime()));if (value3 == null) { stmt.setNull(index++, Types.INTEGER);} else { stmt.setInt(index++, value3.intValue());}== Aaron Bono Aranya Software Technologies, Inc. http

Re: [ADMIN] Tables not restored from V7.4 to v8.1.4

reported in the restore. What am I missing please, and what should I check next? You say you see the tables in the restore. Do you see the data in the restore file as well?== Aaron Bono Aranya Software Technologies, Inc. http

Re: [ADMIN] *** How can I install two postgresqls in the same machine? *****

some of them at a time. Thanks!Aaron== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com ==

Re: [ADMIN] 8.1 Unique Index Issue/Bug???

://www.thescripts.com/forum/thread400192.html http://archives.postgresql.org/pgsql-bugs/2004-07/msg00099.phpYou are probably going to need to write a trigger if you want to enforce that NULL is unique for that field. == Aaron Bono Aranya Software

Re: [ADMIN] PostgreSQL 8.1.4 install failure on Win XP Home laptop

the install? You may want to check what privileges postgres has. Not sure if this will help but is worth a look at. == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com==

Re: [ADMIN] Restore Database

. == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com==

Re: [ADMIN] How to get rid of unicode

On 7/10/06, Vishal Mailinglist [EMAIL PROTECTED] wrote: Dear All ,I am reciving unicode text in one of the table field this actually breaks my frontend. I want to create a trigger which will actually detect a unicode character in the field and change/filter it out. How to go about this

Re: [ADMIN] Wrap (obfuscate) code

On 7/4/06, Jonah H. Harris [EMAIL PROTECTED] wrote: On 7/4/06, Rodrigo De Leon [EMAIL PROTECTED] wrote: I was wondering if there's a mechanism (or if not, a workaround) to obfuscate server code (PL/PgSQL), a la Oracle's PL/SQL Wrap Utility: No, there is no such utility for PostgreSQL.And, even if

Re: [ADMIN] Using GUIDs

By its definition, GUID ( http://en.wikipedia.org/wiki/GUID ) is not guaranteed to be unique.As a result, it could cause problems in tables that have a large number of rows - actually this could result in hard to reproduce, seemingly random errors in your systems that use the database.How does

Re: [ADMIN] PosgreSQL with Joomla

Their online documentation says it uses MySQL so my guess is no.Of course it is an open source project so you could create a PostgreSQL port if you wanted.I would suggest posting questions like this to Joomla though as they know how to answer these questions better. -AaronOn 6/26/06, Sistemas

Re: [ADMIN] Using GUIDs

By its definition, GUID ( http://en.wikipedia.org/wiki/GUID ) is not guaranteed to be unique. As a result, it could cause problems in tables that have a large number of rows - actually this could result in hard to reproduce, seemingly random errors in your systems that use the database. How does a

Re: [ADMIN] Problem Setting DateStyle

Also, and I know this sounds stupid, you may check to see if the database really restarted. I recently got a new server and for some reason when I use the restart script found in /etc/init.d/postgres it doesn't actually restart the server (the shutdown fails) but when I go to the control panel

Re: [ADMIN] Hiding table structure information

Would there be a way to set up the 2 databases - one with the tables and data and the other that connects to the first with views into the second database?Actually I am interested because I will soon need to set up a way to feed data to multiple databases and would love to have a stored procedure

Re: [ADMIN] Dump size bigger than pgdata size?

== Aaron Bono PresidentAranya Software Technologies, Inc. http://www.aranya.com We take care of your technology needs. Phone: (816) 695-6071==

Re: [ADMIN] pg_restore

I agree. When restoring a database from back up, I do a drop database and recreate it to make sure everything is properly intact (tables, columns, views, triggers, foreign keys, etc...). We do this a lot for testing. We backup the production database, copy to test server and do a restore on the

Re: [ADMIN] Database wont start anyway

My guess is that [EMAIL PROTECTED] is not a valid value for LANG. You can see a list of acceptable language identifiers in the RFC at http://www.i18nguy.com/unicode/language-identifiers.html .-AaronOn 6/8/06, Fourat Zouari [EMAIL PROTECTED] wrote: Hello all,My database wont start, here's the log

Re: [ADMIN] Standalone Postgres

You might check out Knoppix. If your app will run on Linux you could create a full bootable Knoppix CD with everything installed - then they can play around all they want and just reboot to reset everything. I am not sure if there is a Knoppix distro that can run within Windows. I do video demos.

Re: [ADMIN] Creating a table in a different database

I just create .sql files with all the commands I want to run and then run them in psql with the \i myscript.sql.If you want to switch databases in psql, use the \c[onnect] [DBNAME|- [USER]] . For example \c my_database my_user. I recommend going into psql and typing in \? for a list of common

[ADMIN] Separating Databases on Different Partitions

Is there a way to get Postgres to store each database in a separate directory? I first hoped I could just use symbolic links under the data directory but I have no idea which files are assigned to which database.The reason I am wanting to do this is that I have a database set up for each user on

Re: [ADMIN] Separating Databases on Different Partitions

I think the tablespace option will work best - I will check it out. I do not give the users control of the database since I do the development, I just need a way to allocate the space and charge for space used. Since cPanel monitors user space, I don't want to rely on having to query the database