Hello All
I am trying to test the following function, But I dont know how to test
these functions. Please help me how to test these functions, and also give
some examples
1. pg_get_viewdef
2. pg_get_ruledef
3. pg_get_indexdef
4. pg_get_userbyid
5. obj_description
thanks in advance
I think its fair to say that the documentation is outdated on this subject,
becuase it had in mind a different definition of consistent snapshots.
See:
http://marc.theaimsgroup.com/?l=postgresql-adminw=2r=1s=LVM+snapshotsq=b
where Tom Lane and Peter Eisentraut agree that if your hardware or
Is there any way in postgres that you canforce a table to be in memory.Tired of spam? Get advanced junk mail protection with MSN 8.
On Wed, 13 Aug 2003, Murthy Kambhampaty wrote:
On Monday, August 11, 2003 17:26, [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] wrote:
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, August 11, 2003 17:26
To: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Backup routine
In article
Hi,
According to some answers about the consistency of
a database in a snapshot of a whole
HD (excluding proc, tmp, and dev, of
course)and without stopping the postmaster service,
it is said it should work because it's like
if the system has
crashed, so restoring files from
the HD and
I have two questions about restoring and moving databases (in pg 7.3), to
which I have not been able to find a suitable answers in the documentation
(and searching the list archives has been painfully slow and fruitless).
1) What is the fastest way to restore a database *with indexes*?
We have
On Monday, August 11, 2003 17:26, [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] wrote:
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, August 11, 2003 17:26
To: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Backup routine
In article [EMAIL PROTECTED],
Bruce Momjian [EMAIL PROTECTED]
Bruce Momjian [EMAIL PROTECTED] writes:
Just a question --- if you link readline against -ltermcap when the
library is created, you don't need to add -ltermcap when you link apps
to readline, right? You somehow bind the dependency in to the shared
library, right?
It could be done that way,
Hello,
How do I go about resolving the undefined ncurses references in
libreadline?
I have Mandrake Linux.
Did you install the readline-devel?
Daniel
---(end of broadcast)---
TIP 6: Have you searched our list archives?
Hornyak Laszlo writes:
I made a failure. I changed operating system under my database from Red
Hat 8.0 to Debian 3.0 (Woody), without pg_dump-ing the database. The
database version haven`t changed. Now I cannot start my database on the
same data directory, it stops with the following failure:
Marco Roda [EMAIL PROTECTED] wrote ..
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?
I never see any
A checkpoint would also have reason to wait for a page-level lock, if
the stuck backend was holding one. I am wondering though if the stuck
condition consistently happens while trying to fire a trigger? That
would be very interesting ... not sure what it'd mean though ...
Hmm. I'm really at
Hello.
I have this problem:i'm runningthe
postgre 7.3on awindows 2000 serverwith P3 1GHZ DUAL/1gb
ramwithgood performance.For bestperformancei have
change the server for a XEON 2.4/1gb ram andformy
suprisethe performance decrease 80%.anybody have a similar
experience?does exist anyspecial
Wilson A. Galafassi Jr. wrote:
hello.
my database size is 5GB. what is the block size recommend?
thanks
wilson
Hmm, IMHO this depends more on your IO System
rather than on the DB size.
It doesnt make sense to have a blocksize which your IO System
(HD, Controller...) cannot fetch in one
On Friday 08 August 2003 18:59, Enio Schutt Junior wrote:
Hi
Here, where I work, the backups of the postgresql databases are being done
the following way: There is a daily copy of nearly all the hd (excluding
/tmp, /proc, /dev and so on) in which databases are and besides this there
is also
Arthur Ward [EMAIL PROTECTED] writes:
I'm back with more on the funky glibc-syslog-Postgres deadlocking behavior:
It looks to me like the guy doing VACUUM is simply waiting for the other
guy to release a page-level lock. The other guy is running a deferred
trigger and so I'd expect him to be
Arthur Ward [EMAIL PROTECTED] writes:
An idea just popped into my head, though. Perhaps I can create procedures
in plpgsql and plpython which do nothing but spew notices (which would in
turn be sent to syslog), and run one or two copies to see if they'll die
on their own given sufficient time.
In theory, the news2mail gateway is back in place ...
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
I could connect to
my posgres server and select any database but i could see my
tables
What´s
wrong??
RGDS
Uh, I am not sure. I would re-install readline and see if it picks up
those libraries this time.
What failures are you seeing, exactly? Oh, I remember, it is linking
failures. You can fix it manually if you add -ltermcap to the link
line, and you can even have configure add it using one of
It looks to me like the guy doing VACUUM is simply waiting for the other
guy to release a page-level lock. The other guy is running a deferred
trigger and so I'd expect him to be holding one or two page-level locks,
on the page or pages containing the tuple or tuples passed to the
trigger.
Hi all!
I made a failure. I changed operating system under my database from Red
Hat 8.0 to Debian 3.0 (Woody), without pg_dump-ing the database. The
database version haven`t changed. Now I cannot start my database on the
same data directory, it stops with the following failure:
Failed to
It appears your readline needs -ltermcap, -lterminfo, or -lcurses to
link properly. I think this happens when the readline library is not
linked against those when it is created.
---
Randolph Jones wrote:
I am getting
In article [EMAIL PROTECTED],
Tom Lane [EMAIL PROTECTED] wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Just a question --- if you link readline against -ltermcap when the
library is created, you don't need to add -ltermcap when you link apps
to readline, right? You somehow bind the
From: Bruce Momjian
It appears your readline needs -ltermcap, -lterminfo, or -lcurses to
link properly. I think this happens when the readline library is not
linked against those when it is created.
---
Randolph Jones wrote:
Matt Clark [EMAIL PROTECTED] writes:
I've noticed that the cost estimates for a lot of my queries are
consistently far to high.
You seem to be under a misapprehension. The cost estimates are not
in units of milliseconds, they are on an arbitrary scale with 1.0
defined as one disk fetch.
LIMIT
Deacitvate the HyperThreading and it should run
like a young cat *g*
-- postgreSQL on Netware - the red elephanthttp://postgresql.dseichter.org
"Wilson A. Galafassi Jr." [EMAIL PROTECTED] schrieb
im Newsbeitrag news:[EMAIL PROTECTED]...
Hello.
I have this problem:i'm runningthe
I'm back with more on the funky glibc-syslog-Postgres deadlocking behavior:
It's really too bad that your gdb backtrace didn't show anything past
the write_syslog level (which is an elog subroutine). If we could see
whether the elog had been issued from a signal handler, and if so what
it
Thanks to bruce momjian and tom lane, I installed ncurses-devel and all
is well.
Thanks so much
rfjones
---(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
Dear peoples,
I'm setting up a database in postgres which will have light traffic writing to a few
tables (and somewhat heavier traffic reading them). We'd like to mirror that databse
using dbmirror to two others.
Let's assume that we're humming along and the master goes down. We switch
The world rejoiced as [EMAIL PROTECTED] (Peter and Sarah Childs) wrote:
However there is a third way. That should be safe but some
people may disagree with me! If you can freeze the disk while you
take the backup. The backup can be used as if the computer had
crashed with no hard disk
On Wed, 6 Aug 2003, Marco Roda wrote:
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?
There's a script in
Hi!
I have a customer asking to me: is possible one app whit two-fase-commit
transactions using posgresql+informix?
Well, I was searched in the web and the postgresql web site, but I
wasn't found nothing about. I hope this is the correct list to post this
ask, and, of course, someone to help me
On Mon, 2003-08-04 at 10:15, Mendola Gaetano wrote:
Hi,
I used to install postgres 7.3.3 from RPM,
today I needed to take a look at pg_utovacuum but I didn't
find it ?
Should I download it somewhere else ?
you'd have to check it out from CVS and then compile it into a 7.3 cvs
pull.
There's an extensive discussion of doing file system level backups off an
LVM snapshot taken on a frozen XFS filesystem (XFS provides xfs_freeze
command which allows the sysadmin to freeze and unfreeze a given file system
at will). See
nice stuff (the whole presentation, full of stuff i did not know), thanks.
of course, a question...
the bit that reads:
If you know the maximum value of an integer column and have an index on
it:
SELECT COUNT(*) FROM t2 WHERE c2 100;
made me think that the above would do an index
On Sat, 2003-08-09 at 08:17, Daniel Seichter wrote:
Hello,
How do I go about resolving the undefined ncurses references in
libreadline?
Yeah, that's the thing that fails when I run ./config of the
postgres7.3.3 build under Mandrake 7.3 .
ld checks libreadline.so for various calls and then
Hello,
I have seen a number of links via google describing build problems
(./configure)
with postgres and libreadline.so .
How do I go about resolving the undefined ncurses references in libreadline?
I have Mandrake Linux.
Thanks for the help
Peter
---(end of
hi,
At 10:25 07.08.2003 +0200, Bruno BAGUETTE wrote:
Marco Roda [EMAIL PROTECTED] wrote ..
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
On Thu, 14 Aug 2003, Yuji Shinozaki wrote:
I have two questions about restoring and moving databases (in pg 7.3), to
which I have not been able to find a suitable answers in the documentation
(and searching the list archives has been painfully slow and fruitless).
1) What is the fastest way
Aha! Thanks for the reply, because it got me thinking, and I reexamined
the schema and discovered that the problem was that we had a foreign key
constraint involving two columns of different type (varchar vs. integer!).
[Yeesh.] I think the type conversion was what was making reindexing (not
to
Marco Kaerger wrote:
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)
Hi,
I've noticed that
the cost estimates for a lot of my queries are consistently far to high.
Sometimes it's because the row estimates are wrong, like
this:
explain analyze
select logtime from loginlog where
uid='Ymogen::YM_User::3e2c0869c2fdd26d8a74d218d5a6ff585d490560' and result =
See my other reply, but the problem was that I had a foreign key
constraint between an integer and varchar. (The column was a varchar and
the foreign key was an integer field). Seems to me postgres shouldn't
have allowed me to do this at all, but I guess it did a slow automatic
type conversion.
[EMAIL PROTECTED] (Bruce Momjian) writes:
No, I don't think that is possible. We don't even have 2-phase commit
between PostgreSQL backends.
---
Wagner Sales wrote:
Hi!
I have a customer asking to me: is possible one
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
Yeah. Instead, exclude the directories below it ($PGDATA/base, etc).
Yes, but if he restores everything but /base, he gets xlog and clog, and
other stuff he shouldn't be restoring.
That's why I said etc. Only the loose files in the
Matt Clark [EMAIL PROTECTED] writes:
consider:
begin;
update a set col1 = 'p' where id = '1';
update a set col2 = 'q' where id = '1';
commit;
versus:
update a set col1 = 'p', col2 = 'q' where id = '1';
Does the first case generate any more dead tuples that will need
vacuuming
hello sir,
i am small programmed in visual basic and database as postgresql. Recentrly i have some problem please help me for the following
Can i possible touse two postgresql database files in linux with multiple harddisk.
If so please help me to do
Do you Yahoo!?
Yahoo! SiteBuilder - Free,
Hi,
I upgraded postgresql 7.2.1 in to
7.3.4
New postgresql works fine.
But after upgrade, zope can't connect to the
postgresql.
Zopeuses "Z PoPy DataBase
Adaptor"
Zope shows error: "Invalid connection
string".
Maybe somebody knows - what is the problem
?
Thanks
[AU]
No, I don't think that is possible. We don't even have 2-phase commit
between PostgreSQL backends.
---
Wagner Sales wrote:
Hi!
I have a customer asking to me: is possible one app whit two-fase-commit
transactions using
Morning all, bit of a general question here...
consider:
begin;
update a set col1 = 'p' where id = '1';
update a set col2 = 'q' where id = '1';
commit;
versus:
update a set col1 = 'p', col2 = 'q' where id = '1';
Does the first case generate any more dead tuples that will need
sir,
i have installed postgresql 7.1.3 in redhat8 O.S
i can start and stop the postmaster, but
i can not create a DB using createdb command.it is
showing error
error while loading shared libraries - libpq.so.3
please help me.
Thank you
Johnson
__
Title: Hi Sir
hi Sir,
There is some problem with some program face me especially in Java Applet.
So, can you help me in this problem?
please if youcan help me with any solve or web site help me in solve it send it to my e-mail
[EMAIL PROTECTED]
Bruce Momjian wrote:
Have you looked in the src/contrib/reindex directory?
Ahem, nope I didn´t have, until you told me so!
Its exactly what I needed.
Cheers, Dani
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
In article [EMAIL PROTECTED],
Bruce Momjian [EMAIL PROTECTED] wrote:
Also, I assume you have to stop the server just for a moment while you
do the freeze, right?
It depends on if you need known state or just consistent state.
Taking a snapshot of the system will get you a consistent state just
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)
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Bruce Momjian) would write:
Christopher Browne wrote:
The world rejoiced as [EMAIL PROTECTED] (Peter and Sarah Childs) wrote:
However there is a third way. That should be safe but some
people may disagree with me! If you can
Hello,
I used postgresql 7.0. I install new instalation 7.3.4.
Could you tell me how I can import my base from 7.0 to 7.3.4?
I used in base 7.0 pg_dumpall -o base.sql and try import to 7.3.4 (psql -U
postgres -f base.sql template1).
Of course I read a lot of errors;
In Relase Notes from
Oh, good point. By grabbing xlog along with the data files, you do get
a consistent snapshot just like if it had crashed.
---
Mike Castle wrote:
In article [EMAIL PROTECTED],
Bruce Momjian [EMAIL PROTECTED] wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
It appears your readline needs -ltermcap, -lterminfo, or -lcurses to
link properly. I think this happens when the readline library is not
linked against those when it is created.
On Red Hat 8.0, readline depends on -ltermcap. I would imagine the same
Cool :)
Thanks,
Laszlo
On Thu, 7 Aug 2003, Peter Eisentraut wrote:
Hornyak Laszlo writes:
I made a failure. I changed operating system under my database from Red
Hat 8.0 to Debian 3.0 (Woody), without pg_dump-ing the database. The
database version haven`t changed. Now I cannot start
Just a question --- if you link readline against -ltermcap when the
library is created, you don't need to add -ltermcap when you link apps
to readline, right? You somehow bind the dependency in to the shared
library, right?
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
i need to get a row count on a large table. it appears that
select count(*) from table;
always does a table scan, whether i have an index or not, and that is too
slow.
so i found this:
select reltuples from pg_class where relname = 'table';
this is nice and fast, but not all that accurate
I am getting configure failures due to missing readline.
I have redhat 9, 2.4.21, with readline and readline-devel 2.4.2 installed.
I am trying to build 7.3.3
Below is part of my config.log
Any help greatly appreciated
TIA
rfjones
}
configure:5786: result: no
configure:5800: checking for readline
shreedhar wrote:
Hi All,
I Updated my Postgresql Server from 7.2.4 which came along with RH7.3 to
7.3.2. After updating I could not able to connect database through PHP. So I
recompiled PHP4.1.2 (same version which have earlier in my system), even
then I am not able to connect through
The Hermit Hacker wrote:
On Wed, 6 Aug 2003, Wilson A. Galafassi Jr. wrote:
do you now how to turn off the xeon Hyperthreading ??
Not sure ... in Unix, you just dont' enable it ... at least under FreeBSD
(its disabled by default) ... check in your BIOS though, I *thought* I
heard mention
Ludwig Isaac Lim [EMAIL PROTECTED] writes:
I'm guessing that the spinlock error occurs after
there are around hundreds (or thousands) of queued
postmaster processes.
Thousands? How large is your max_connections parameter, anyway
(and do you really have big enough iron to support it)?
The
Hi:
--- Tom Lane [EMAIL PROTECTED] wrote:
What can cause a stuck spinlock?
In theory, that shouldn't ever happen. Can you
reproduce it?
regards, tom lane
I could not reproduce it, but I'll describe how
error happen. I have a program that read a file large
file
Raymond Chui [EMAIL PROTECTED] writes:
drop table whitepage;
delete from state where state_code = 'GU';
ERROR: Relation whitepage does not exist
Why I got this error message??!!
I could not duplicate this error. What PG version are you running?
regards, tom lane
On Mon, 11 Aug 2003, Jie Liang wrote:
1. No doc said % should escape by %%, and
select replace('whatever%20sites','%20','%%20') won't work also.
2. v7.3.2 haven't resolved this problem yet, I am not sure the later version.
I seem to get the expected results on my 7.3.4 system.
I made a modification on DBMirror.pl,
an addition in the slavedatabase.conf file,
and added another replication table specialtables.
The goal was to have a way of controlling
when a row of table (if the table is present in specialtables),
will be mirrored to the remote slave.
Lets assume, we
Jie Liang [EMAIL PROTECTED] writes:
1. No doc said % should escape by %%, and
select replace('whatever%20sites','%20','%%20') won't work also.
2. v7.3.2 haven't resolved this problem yet, I am not sure the later version.
In 7.3.3 release notes:
* Fix misbehavior of replace() on strings
urldb=# select replace('whateveritis','a','A');
replace
--
whAteveritis
(1 row)
urldb=# select replace('whateveritis','e','E');
replace
--
whatEvEritis
(1 row)
urldb=# select replace('whatever%20itis','e','E');
replace
Here are the simple things I did
create table state (
state_code char(2) not null,
state varchar(15) not null,
primary key (state_code)
);
create table whitepage (
user_id char(8) not null,
email varchar(50),
telephone char(16) not null,
contact_namevarchar(30) not
insert into state (state_code,state) values ('GU','Guam');
drop table whitepage;
delete from state where state_code = 'GU';
ERROR: Relation whitepage does not exist
Old version of PostgreSQL? Effort went into cleaning up inter-object
dependencies in 7.3. I don't recall having that
On Wed, 13 Aug 2003, Raymond Chui wrote:
Here are the simple things I did
create table state (
state_code char(2) not null,
state varchar(15) not null,
primary key (state_code)
);
create table whitepage (
user_id char(8) not null,
email varchar(50),
telephone
Hi
did you configure php for PostgreSQL support
./configure --with-pgsql
Regards
Conni
---(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
-rw-r--r--1 root root99586 Aug 6 20:37 libpq.a
lrwxrwxrwx1 root root 12 Aug 6 20:37 libpq.so -
libpq.so.3.0
lrwxrwxrwx1 root root 12 Aug 6 20:37 libpq.so.3 -
libpq.so.3.0
-rwxr-xr-x1 root root92088 Aug 6 20:37 libpq.so.3.0
I
79 matches
Mail list logo