Brian Wong writes:
> I'm getting a "Out of memory" error on a 9.1.9 server. What do these lines
> in the log mean? ~ Brian
It's a memory usage map. Your problem is evidently here:
> MessageContext: 3046113280 total in 374 blocks; 24584 free (5 chunks);
> 3046088696 used
As far as I recall
I'm getting a "Out of memory" error on a 9.1.9 server. What do these lines
in the log mean? ~ Brian
TopMemoryContext: 738160 total in 82 blocks; 11792 free (52 chunks); 726368
used
Type information cache: 24576 total in 2 blocks; 11888 free (5 chunks);
12688 used
Operator lookup cache: 24576
t;".
pg_cursors is only accessible within the same transaction and as a DBA we want
to see that cursor of any active transactions.
Thanks,
-Dan
From: Greg Williamson
To:
Cc: "pgsql-admin@postgresql.org"
Sent: Thursday, January 24, 2013 1:08 A
Dan --
>
> From: Michael Holt
>To: Raghavendra ; Dan Ng
>Cc: "pgsql-admin@postgresql.org"
>Sent: Wednesday, January 23, 2013 9:55 PM
>Subject: Re: [ADMIN] Getting
>
>
>
>Of course you can also see what the query plan w
behalf of Raghavendra [raghavendra@enterprisedb.com]
Sent: Wednesday, January 23, 2013 9:52 PM
To: Dan Ng
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Getting
On Wed, Jan 23, 2013 at 11:50 PM, Dan Ng
mailto:surf...@yahoo.com>> wrote:
Hello,
I am a newb in Postgres coming from Oracle
On Wed, Jan 23, 2013 at 11:50 PM, Dan Ng wrote:
> Hello,
> I am a newb in Postgres coming from Oracle. Does anyone know if it's
> possible to see the plan being executed by Postgres for an active sql
> statement (from pg_stat_activity). This is to be able to troubleshoot poor
> performing ones an
Hello,
I am a newb in Postgres coming from Oracle. Does anyone know if it's possible
to see the plan being executed by Postgres for an active sql statement (from
pg_stat_activity). This is to be able to troubleshoot poor performing ones and
in Oracle we are able to retrieve such a plan.
Addition
Magnus Hagander, 04.05.2012 15:22:
I'm trying to enable "ident" authentication on my Windows machine using
PostgreSQL 9.1
However as soon as I add the following line to pg_hba.conf
hostall all ::1/128ident sameuser
"sameuser" was removed in PostgreSQ
On Fri, May 4, 2012 at 3:33 PM, k...@rice.edu wrote:
> On Fri, May 04, 2012 at 01:57:47PM +0200, Thomas Kellerer wrote:
>> Hi,
>>
>> I'm trying to enable "ident" authentication on my Windows machine using
>> PostgreSQL 9.1
>>
>> However as soon as I add the following line to pg_hba.conf
>>
>>
On Fri, May 04, 2012 at 01:57:47PM +0200, Thomas Kellerer wrote:
> Hi,
>
> I'm trying to enable "ident" authentication on my Windows machine using
> PostgreSQL 9.1
>
> However as soon as I add the following line to pg_hba.conf
>
>hostall all ::1/128id
On Fri, May 4, 2012 at 1:57 PM, Thomas Kellerer wrote:
> Hi,
>
> I'm trying to enable "ident" authentication on my Windows machine using
> PostgreSQL 9.1
>
> However as soon as I add the following line to pg_hba.conf
>
> host all all ::1/128 ident sameuser
Hi,
I'm trying to enable "ident" authentication on my Windows machine using
PostgreSQL 9.1
However as soon as I add the following line to pg_hba.conf
hostall all ::1/128ident sameuser
I get an error message when trying to login (after a server reload
Wells Oliver wrote:
> Is there a way to get the date that starts week 14, or 15 (etc)?
Which week numbering do you use?
http://en.wikipedia.org/wiki/Week_number#Week_numbering
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscrip
Wells Oliver, 22.04.2012 00:58:
Is there a way to get the date that starts week 14, or 15 (etc)?
Try this:
select to_date('201214', 'iyyyiw')
That uses the ISO week definition.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www
Is there a way to get the date that starts week 14, or 15 (etc)?
--
Wells Oliver
wellsoli...@gmail.com
On Thu, 2012-02-02 at 15:40 +0100, Mario Splivalo wrote:
> How can I get the master server host data from a running slave, without
> reading recovery.conf file?
>
> I've tried with SHOW, but that just gives me:
>
> postgres=# show primary_conninfo;
> ERROR: unrecognized configuration parameter "
How can I get the master server host data from a running slave, without
reading recovery.conf file?
I've tried with SHOW, but that just gives me:
postgres=# show primary_conninfo;
ERROR: unrecognized configuration parameter "primary_conninfo"
Mario
--
Sent via pgsql-admin mailing list
On 08/22/2010 05:27 PM, c k wrote:
As I am using MS Access for a long time, many tools like ms access
provides a way to get the list of columns from a query. (using filed
list in combo boxes in ms access). But is it possible to get such list
of columns from a query where it is not known to the
Hi all,
As I am using MS Access for a long time, many tools like ms access provides
a way to get the list of columns from a query. (using filed list in combo
boxes in ms access). But is it possible to get such list of columns from a
query where it is not known to the user, that which columns are de
su - postgres
psql dbname -c "show all"
> Date: Tue, 13 Apr 2010 13:13:58 -0400
> From: g...@2ndquadrant.com
> To: sburn...@cisco.com
> CC: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Getting the initdb parameter values
>
> Satish Burnwal (sburnwal) wr
Satish Burnwal (sburnwal) wrote:
I have an existing postgres database and I want to know what are the
values of the parameters that were determined during initdb. Is there
any way to know those values ?
I normally use:
select name,current_setting(name) from pg_settings where
source='conf
"Satish Burnwal (sburnwal)" wrote:
> I have an existing postgres database and I want to know what are
> the values of the parameters that were determined during initdb.
> Is there any way to know those values ?
> Is there any pg_* table which I look into for such params?
There is:
http://w
I have an existing postgres database and I want to know what are the
values of the parameters that were determined during initdb. Is there
any way to know those values ? For example, doc
http://www.postgresql.org/docs/8.1/interactive/runtime-config-resource.h
tml says that the max value of 'shared_
On Dec 23, 2009, at 7:36 AM, Mohammed Rashid wrote:
> I am using the postgres database in one of my project.
> I am getting "message type 0x43 arrived from server while idle" messages
> while querying the database and getting erroneous results.
>
> I am using libpq library for querying databa
Mohammed Rashid wrote:
> I am getting "message type 0x43 arrived from server while idle"
> messages while querying the database and getting erroneous
> results.
>
> I am using libpq library for querying database.
> I am having two different processes accessing the same database.
More details
Mohammed Rashid writes:
> I am getting "message type 0x43 arrived from server while idle" messages
> while querying the database and getting erroneous results.
> I am using libpq library for querying database.
> I am having two different processes accessing the same database.
I'll bet what yo
Hi All,
I am using the postgres database in one of my project.
I am getting "message type 0x43 arrived from server while idle" messages
while querying the database and getting erroneous results.
I am using libpq library for querying database.
I am having two different processes accessing the s
Well, using pg_unescape_bytea I was able to get the image. How can I stream
it directly to the users's browser??
- Original Message -
From: "Andy Shellam"
To: "Félix Sánchez Rodríguez"
Cc:
Sent: Friday, May 08, 2009 8:26 AM
Subject: Re: [ADMIN] Getting im
Hi Felix,
I've not written an image specifically, but I have read/written byte
data which is all an image is.
Your PostgreSQL database column that holds the image should be of type
"bytea." Your PHP application must then use the following functions:
Writing to the database - http://uk2.php
Hi:
Has anybody here had to capture an image from a PostgreSQL Data Base using
PHP?? I used a simple query: select photo from people where id = 3, for
instance. The problem is that when I write the image to disk it's not a valid
image. I opened it using an HEX editor and saw that the question i
jan-peter.seif...@gmx.de writes:
> Hello raf,
>>> Easier is just
>>> select oid::regprocedure from pg_proc where
>> note that this method doesn't produce a complete function
>> signature. the precision and scale of numerics are not
>> included in the output. hopefully, that won't matter for
>> yo
Hello Tom,
> > I combined your suggestions into this query I'll be using for now:
>
> > SELECT DISTINCT n.nspname || '.' || p.oid::regprocedure::text FROM
>
> This is flat *wrong*, as you'll soon find if you are working with
> functions in more than one schema. regprocedure already puts a
> sch
Hello raf,
> > > Easier is just
> > > select oid::regprocedure from pg_proc where
> note that this method doesn't produce a complete function
> signature. the precision and scale of numerics are not
> included in the output. hopefully, that won't matter for
> your needs.
Oh. So functions expe
jan-peter.seif...@gmx.de wrote:
> Hello Ashish, Hello Tom,
>
> thank you very much for your quick and helpful replies - I really appreciate
> that.
>
> > > May be this will help you:
> >
> > Easier is just
> > select oid::regprocedure from pg_proc where
>
> I guess I'll go with the very
jan-peter.seif...@gmx.de writes:
> I combined your suggestions into this query I'll be using for now:
> SELECT DISTINCT n.nspname || '.' || p.oid::regprocedure::text FROM
This is flat *wrong*, as you'll soon find if you are working with
functions in more than one schema. regprocedure already put
Hello Ashish, Hello Tom,
> > before I reinvent the wheel I'd like to know whether there's a shortcut
> for getting the 'full' name (incl. argtypes) of the functions within a
> database in order to REVOKE priviliges on them given to certain users.
I combined your suggestions into this query I'll b
Hello Ashish, Hello Tom,
thank you very much for your quick and helpful replies - I really appreciate
that.
> > May be this will help you:
>
> Easier is just
> select oid::regprocedure from pg_proc where
I guess I'll go with the very nifty type cast suggested by Tom though as this
cove
Ashish Karalkar writes:
> Jan-Peter Seifert wrote:
>> Obviously you can't just use the specific_name from
>> information_schema.routine_privileges for this.
> May be this will help you:
Easier is just
select oid::regprocedure from pg_proc where
regards, tom lan
Jan-Peter Seifert wrote:
Hello,
before I reinvent the wheel I'd like to know whether there's a shortcut for
getting the 'full' name (incl. argtypes) of the functions within a database in
order to REVOKE priviliges on them given to certain users.
I don't see anything in the docs:
http://www.po
Hello,
before I reinvent the wheel I'd like to know whether there's a shortcut for
getting the 'full' name (incl. argtypes) of the functions within a database in
order to REVOKE priviliges on them given to certain users.
I don't see anything in the docs:
http://www.postgresql.org/docs/8.3/inter
Jaume Sabater a écrit :
> [...]
> Sorry to ask this, I had it noted down but now I cannot find it and
> I've been googling for 30 minutes now without success. There is a way
> to query the system database to get the current value of a
> configuration parameter, something in the form of SELECT value
You can configuration parameter value from psql prompt by typing
show all ;
or
show [paramter name]
e.g show shared_buffers;
Jaume Sabater wrote:
Hi all!
Sorry to ask this, I had it noted down but now I cannot find it and
I've been googling for 30 minutes now without success. There is a way
t
Hi all!
Sorry to ask this, I had it noted down but now I cannot find it and
I've been googling for 30 minutes now without success. There is a way
to query the system database to get the current value of a
configuration parameter, something in the form of SELECT value FROM
some_table WHERE field_na
Dean Gibson (DB Administrator) wrote:
> I'm getting this loading some large (1 million row) tables. Is this
> anything to be concerned about?
No, it's normal. It means the autovacuum task was cancelled in order to
avoid blocking your regular Postgres sessions.
If it's only during table loadin
I'm getting this loading some large (1 million row) tables. Is this
anything to be concerned about?
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
"Tena Sakai" <[EMAIL PROTECTED]> writes:
> I installed postgres v 8.2.4 on a new linux server (not upgrade,
> but a virgin install) and created a couple of users. For the
> sake of clarity and concreteness, I will call this server S824.
> There is another server on the network where S824 resides t
From: "Tena Sakai" <[EMAIL PROTECTED]>
To:
Subject: [ADMIN] getting service from a local server (v8.2.4)
Date: Wed, 18 Jul 2007 21:13:11 -0700
Hi,
I am new to postgres and having a strange problem. Please help.
I installed postgres v 8.2.4 on a new linux server (not upgra
Hi,
I am new to postgres and having a strange problem. Please help.
I installed postgres v 8.2.4 on a new linux server (not upgrade,
but a virgin install) and created a couple of users. For the
sake of clarity and concreteness, I will call this server S824.
There is another server on the networ
AFAICS, log_statement and friends are much cheaper than any other
alternative could be.
Dear Sir,
thanks for the reply and clarifying.
regds
mallah.
regards, tom lane
---(end of broadcast)---
TIP 7: You can help support
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> This issue has been posted before also but this time i wanted
> to know, if it is possible to know what statements have been
> executed by the backend in the same transaction which is currently
> idle. this can probably help us in identifying the
This may help you...
http://archives.postgresql.org/pgsql-announce/2006-01/msg7.php
- Original Message -
From: Rajesh Kumar Mallah
To: Lista Postgres
Sent: Monday, January 22, 2007 9:55 AM
Subject: [ADMIN] Getting previous statements executed a backend currenly in
an
On 1/22/07, Umesh Shastry <[EMAIL PROTECTED]> wrote:
This may help you...
thanks for reply.
but thats for slow queries. Blocked queries are different
regds
mallah.
http://archives.postgresql.org/pgsql-announce/2006-01/msg7.php
---(end of broadcast)
Dear Friends,
Due to some bug(s) in our apps , in a mod_perl environment
many backend remain in in transaction state. This
backends sometimes block other statements in batch
processes which in turn blocks access to some production
tables.
This issue has been posted before also but this time i w
First, you need to upgrade to 8.1.4.
You can redirect STDOUT to /dev/null. Error messages will be sent to
STDERR.
On Aug 7, 2006, at 9:00 AM, Nicola Mauri wrote:
I scheduled a dump between two databases, via network:
pg_dump --clean -U postgres mydb | psql -q -h remote_host -d mydb -
U po
On Mon, 2006-08-07 at 09:00, Nicola Mauri wrote:
> I scheduled a dump between two databases, via network:
>
> pg_dump --clean -U postgres mydb | psql -q -h remote_host -d mydb -U
> postgres
>
> I'd like to have no output being generated, unless an error condition
> occurs, so that crond will em
On 8/7/06, Nicola Mauri <[EMAIL PROTECTED]> wrote:
I scheduled a dump between two databases,
via network:
pg_dump --clean -U postgres mydb |
psql -q -h remote_host -d mydb -U postgres
I'd like to have no output being generated,
unless an error condition occurs, so that crond will email me only
I scheduled a dump between two databases,
via network:
pg_dump --clean -U postgres mydb |
psql -q -h remote_host -d mydb -U postgres
I'd like to have no output being generated,
unless an error condition occurs, so that crond will email me only when
something goes really wrong.
Unfortunately I'
On Tue, May 23, 2006 at 05:47:31PM +0200, Mario Splivalo wrote:
> I'm doing backup on a second, spare server, by backing up WAL files. I'm
> using that server for analysis queries and reporting. Every 15 minutes I
> need to shut down that server, place in new WAL files, and restart
> server. That i
I'm doing backup on a second, spare server, by backing up WAL files. I'm
using that server for analysis queries and reporting. Every 15 minutes I
need to shut down that server, place in new WAL files, and restart
server. That is ok, except that I need to backup whole database cluster.
That wasnt't
Hi,
I am using PostgreSQL 8 and adodb. adodb has a built-in function which
scans and retrieves db structure as assotiative array. Unfortunately,
it do not list indexes and constrains. What would be a SQL statement
to retrieve them?
Thanks in advance for any suggestion(s).
***
alf Of Tom Lane
Sent: Sunday, August 14, 2005 5:25 PM
To: Shilpa Tisgaonkar
Cc: pgsql-admin@postgresql.org; [EMAIL PROTECTED]
Subject: Re: [ADMIN] Getting an error in connection refused
"Shilpa Tisgaonkar" <[EMAIL PROTECTED]> writes:
> I'm getting the following error
>
"Shilpa Tisgaonkar" <[EMAIL PROTECTED]> writes:
> I'm getting the following error
> psql: could not connect to server: Connection refused
> Is the server running on host "localhost" and accepting
> TCP/IP connections on port 5432?
Looks like the postmaster hasn't been started. S
Hi,
I'm trying to connect to databasewhich has been already created. But
when I use following command
psql -Utest1 -hlocalhost -p5432 -W testone
I'm getting the following error
psql: could not connect to server: Connection refused
Is the server running on host "localhos
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I would normally just set minimum value to something greater than what
> already in the table,
That's the way to go.
> but the manually keyed values are all over the place, and I guess I'd
> really like to remove the gaps in the current values.
I'm trying to add a
sequence function to an already existing field. All the 4000 records for this
table currently have a value already in this field, but I'd like new ones to
just get the next value by default as opposed to users being forced to type
something. What I'd like to do is to relo
Hello,
I am very confused. I have a Debian server with PostGreSQL running. I have
everything installed and working.
Here is my wish list:
1. To do anything, I have to "su - postgres". This has no password. How do I
put a password on it. I have tried "passwd postgres wackypass" but it did
not wo
Ah!
I didn't know that!
Michael, thank you so much! No, I don't have anything sharing these
sessions, they are rules in the back end so they should (unless someone
tells me differently) AFAIK be in their own threads.
Top man!
Brad
Michael Fuhr wrote:
On Wed, Sep 22, 2004 at 04:30:06PM +0100, Bra
Bradley Kieser wrote:
Hi Michael,
But what if another insert happens in the mean time? Then the sequence
would have advanced that the data will be scrambled. |Given that this
could be a very active dataset, that situation is almost certain to occur.
I think you are wrong, the sequence are not af
On Wed, Sep 22, 2004 at 04:30:06PM +0100, Bradley Kieser wrote:
> Michael Fuhr wrote:
>
> >CREATE RULE v_ins AS ON INSERT TO v DO INSTEAD (
> > INSERT INTO a (xxx) VALUES (NEW.xxx);
> > INSERT INTO b (col1, col2, col3) VALUES (NEW.col1, NEW.col2,
> > currval('a_id_seq'))
> >);
>
> But what if ano
Hi Michael,
But what if another insert happens in the mean time? Then the sequence
would have advanced that the data will be scrambled. |Given that this
could be a very active dataset, that situation is almost certain to occur.
Brad
Michael Fuhr wrote:
On Wed, Sep 22, 2004 at 02:21:42PM +0100, B
On Wed, Sep 22, 2004 at 02:21:42PM +0100, Bradley Kieser wrote:
> I have a rule on a view that needs to insert into two tables. The one
> table has a serial ID as its unique key. The second table links to the
> first one in one of its columns.
>
> I would prefer to keep this as a rule-based solu
I have a rule on a view that needs to insert into two tables. The one
table has a serial ID as its unique key. The second table links to the
first one in one of its columns.
I would prefer to keep this as a rule-based solution and not have to
write a function as I hope to relicate the solution
Title: -- CONFIDENTIALITY NOTICE --
>How do I get the
postgresql statistics? I would like to know queries
>per second etc.
>
>The stats_start_collector variable is on, and I can see the
>stats collector process running. But how do I query it?
>
>Thanks a lot for any input.
Check out
www.postgresq
Naomi Walker wrote:
>
>> >How do I get the postgresql statistics? I would like to know queries
>> >per second etc.
>> >
>> >The stats_start_collector variable is on, and I can see the
>> >stats collector process running. But how do I query it?
>> >
>> >Thanks a lot for any input.
>>
>>Check out ww
hi,
Victor Sudakov wrote:
I still cannot find the average number of queries per second. Could
you please be more specific.
there is no such. You have to write it for your own if you want. Or you
can log statements to a log file, and then parse that file.
C.
---(end of br
Colleagues,
How do I get the postgresql statistics? I would like to know queries
per second etc.
The stats_start_collector variable is on, and I can see the
stats collector process running. But how do I query it?
Thanks a lot for any input.
--
Victor Sudakov, VAS4-RIPE, VAS47-RIPN
2:5005/[EM
Hello folks,
I want to state right off the bat that I _know_
these are very basic questions, and most can be answered
with an understanding of SQL. I am very new to databases,
but I am _not_ asking for answers. You folks have much
more important (or fun) things to do with your time. :
Hi,
I'm trying to log all SQL queries sent to postgres v6.5.
I have set PGECHO=yes in the postmaster.init file but nothing about the
SQL queries
appears in the log. I know that the config file is being read and that I
am looking
at the right log file because changes to the init file PGDEBUG leve
$fsize=$query->fsize($i);
# print "$i:$fname:$fnumber:$ftype:$fsize\n";
$value=$query->getvalue($tup_num, $i);
print "$tup_num:$fname=$value\n";
}
}
On Thu, 27 May 1999, áÎÄÒÅÊ îÏ×ÉËÏ× wrote:
> Date: Thu, 27 May 1999 15:46:48 +0
On Thu, May 27, 1999 at 03:46:48PM +0400, @ mdpei Mnbhjnb wrote:
> Is there any way to get table structure from perl script
> (for instance using Pg). I need it very much, but now have
> to use copy/paste algorythm :)
Since I don't use Perl, I cannot offer a perl specific solution.
General
Hello.
Is there any way to get table structure from perl script
(for instance using Pg). I need it very much, but now have
to use copy/paste algorythm :)
Andrey Novikov
On Tue, 25 May 1999, Jim Burnett wrote:
> In access when I try to link a table I get an authentication failed. I
> tried to add a user using createuser, but i didnt pompt me for a
> password. Also, do i need to add users to each database i make or just
> using the createuser in ./bin ? i tried to
On Tue, 25 May 1999, Jim Burnett wrote:
> Ok I am getting somewhere now,
>
> In access when I try to link a table I get an authentication failed. I
> tried to add a user using createuser, but i didnt pompt me for a
> password.
correct. You create a DB user not a Linux user.
> Also, do i need
Ok I am getting somewhere now,
In access when I try to link a table I get an authentication
failed. I tried to add a user using createuser, but i didnt pompt me for a
password. Also, do i need to add users to each database i make or just using the
createuser in ./bin ?
i tried to use the
I built the postgres-6.3.2 package on my NetBSD-current/pc532
machine over the last few days. My problem is that it failed
several of the regression tests. int2 and int4 scared me until I
saw that my machine said something like "number too big" and the
expected output was something like "bad for
85 matches
Mail list logo
