Obviously, you are coming from Oracle world. In PG according to:
http://www.postgresql.org/docs/current/static/errcodes-appendix.html
exception WHEN no_data THEN ...
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Karthikeyan
Sundaram
Hello!
I already searched in the archives for similar problems but didn't find any.
I want to have a hot backup server of my master server's database.
I am using NetBSD 3.0.1 with Postgresql 8.2.3.
It works so far, that I receive the WAL Files on the slave every few
minutes from the master. I
Damian Lubosch [EMAIL PROTECTED] writes:
My problem now is, how to continually feed the slave server with new
received WAL files?
You need to make the restore_command script wait until the next WAL file
is available, instead of failing immediately.
This is actually not that simple to get
Hi,
Found on the dev mailing list (hidden well)...
On the master postgresql.conf:
archive_command = 'rsync -arv %p
slave_hostname:/.../wal_archive/%f;'
(and maybe 'cp %p /.../wal_archive/%f;')
archive_timeout= 900
So, you need to perform a ssh-keygen on both sides.
Now, the slave
Hi, I'm looking in my log file with today's date. I'm using VIM and
have done a search for a pattern match on autovac, vacuum, and
auto VIM returned string not found for each search. Am I
looking for the wrong string, or is there another log file I should
be looking at?
Carol
On Mar
Hi,
A friend of mine getting following error
Error: xlog flush request 0/797FED50/ is not satisfied -- flushed only
to 0/797FC1D8
CONTEXT: writing block 681 of relation 1663/10819/16520
Detail: Multiple failures -- write error may be permanent
can anyone pls suggest if its indicative of some
Hi,
I tried to find, but I didn't, I would like to know what's the view to
list all sequences!
Thank you
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Alexander B. wrote:
Hi,
I tried to find, but I didn't, I would like to know what's the view to
list all sequences!
Thank you
\ds
or
select * from pg_class where relkind = 'S';
---(end of broadcast)---
TIP 4: Have you searched our list
On Wed, 4 Apr 2007, Alexander B. wrote:
Hi,
I tried to find, but I didn't, I would like to know what's the view to
list all sequences!
You can get the info from pg_class like so:
SELECT n.nspname
, c.relname
FROM pg_class c
, pg_namespace n
WHERE c.relnamespace = n.OID
AND
Rajesh Kumar Mallah [EMAIL PROTECTED] writes:
A friend of mine getting following error
Error: xlog flush request 0/797FED50/ is not satisfied -- flushed only
to 0/797FC1D8
CONTEXT: writing block 681 of relation 1663/10819/16520
Which PG version exactly? Has he had any crashes lately? The
Hi,
I have a quick question about my installation that puzzles me. pgsql
8.2.3on a debian box. Tested it out the database works. pgadmin III
connects fine
too. I used alter table on the template1 database to give postgres user a
password. I changed pg_hba to use md5 on all connections including
On Wed, Apr 04, 2007 at 04:25:17PM -0400, Dave Lazar wrote:
password. I changed pg_hba to use md5 on all connections including local.
did you restart?
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
One quick point - you don't need to alter anything in the template1
database to set user's passwords.
In PgAdmin III - use the Login roles section to set the passwords -
that way everything will get committed correctly.
Also, have you restarted PostgreSQL since changing pg_hba.conf?
Andy.
On Wed, 4 Apr 2007, Dave Lazar wrote:
I have a quick question about my installation that puzzles me. pgsql
8.2.3on a debian box. Tested it out the database works. pgadmin III
connects fine
too. I used alter table on the template1 database to give postgres user a
password. I changed pg_hba to
I'm in the process of moving a large database from an in-house Win32
server to a co-located Ubuntu Linux server. The data's in constant use,
so I can't really bring the server down for more than a half hour or so,
and I'd like to go ahead and use a base backup + WAL restore strategy to
sync the
On Wed, 4 Apr 2007, Dave Lazar wrote:
Most likely psql is picking up the password from ~/.pgpass when run as
your
user. Pgadmin3 stores passwords in .pgpass, so it's likely been put in
there
by pgadmin. As a test - move .pgpass to .pgpass.old and try to connect
via
psql -U postgres -d
From experience I would say NEVER NEVER try and do a direct copy across
different platforms (Windows - Linux.)
Someone may contradict me, but I think a dump/restore would be the way
to go.
What sort of size of data are we talking? You'll need to factor in the
time it takes to dump the data,
We're talking about 12 GB of data... to do the [probably ill-fated]
binary copy in any reasonable amount of time required a portable hard
drive and sneaker-net...
That's why I'm anxious, probably to the point of stupidity, to avoid a
situation where I'll have to bring the db down long enough to
Is there any chance of you setting up a temporary machine on the same
network as your Windows one but an identical build as your co-located
machine? Then you can transfer your Windows data to Linux using
pg_dump/restore, switch your apps over to the Linux machine, then use
WAL files to mimic
Sean Murphy wrote:
We're talking about 12 GB of data... to do the [probably ill-fated]
binary copy in any reasonable amount of time required a portable hard
drive and sneaker-net...
That's why I'm anxious, probably to the point of stupidity, to avoid a
situation where I'll have to bring the db
Slony doesn't do LOs...
Joshua D. Drake wrote:
Sean Murphy wrote:
We're talking about 12 GB of data... to do the [probably ill-fated]
binary copy in any reasonable amount of time required a portable hard
drive and sneaker-net...
That's why I'm anxious, probably to the point of stupidity, to
Actually the colo machine is running Windows as well (not my call, but
there are other workloads on it) but Ubuntu is running under VMWare, so
I could install a truly identical copy of the colo machine on the same
server I'm moving from...
Thanks!
Andy Shellam wrote:
Is there any chance of you
Sean Murphy wrote:
search of the Docs tells me that I can compile the server with a
different MAXALIGN, but the install docs don't give any indication
how this is achieved. Is there a configure or gmake option I can
feed, or do I need to change a line in one (or more) of the source
files?
On 4/5/07, Tom Lane [EMAIL PROTECTED] wrote:
Rajesh Kumar Mallah [EMAIL PROTECTED] writes:
A friend of mine getting following error
Error: xlog flush request 0/797FED50/ is not satisfied -- flushed only
to 0/797FC1D8
CONTEXT: writing block 681 of relation 1663/10819/16520
Which PG version
24 matches
Mail list logo
