that copy of the database in question to your primary
server.
Jason Minion
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Monday, February 26, 2007 7:57 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN
some other db's with regards to recovery
time in a DR scenario. I am very eager to see where we go in the future.
Jason Minion
[EMAIL PROTECTED]
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Yogvinder Singh
Sent: Thursday, January 18, 2007
spersed amongst millions of rows) then you
may be back to the seq scan.
Jason Minion
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Subbiah, Stalin
Sent: Wednesday, August 23, 2006 11:44 PM
To: Dave Dutcher
Cc: pgsql-performance@postgresql.o
full
and retrieving system space, you'll want to read:
http://www.postgresql.org/docs/8.0/interactive/maintenance.html#VACUUM-FOR-SPACE-RECOVERY
Jason Minion
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Szabolcs BALLA
Sent: F
Usually a dump is significantly smaller than a live database due to
space taken up by indexes and discarded tuples from MVCC. If it's
significantly smaller you may also want to take a look at your vacuuming
procedure.
But I'm not sure database_size() is.
Jason Minion
[EMAIL
You're using single quotes inside single quotes, you'll need to either
escape them or switch to double-quotes for your outer string delimiter
(preferred). ie:
/usr/local/pgsql/bin/psql -d temp -c "insert into temp.ip_mapping_tb(ip,
location) values('192.100.9.51','
If by "broken connection" you are referring to the "invalid startup
packet" lines - that has been known to be caused by pretty much anything
other than a postgresql client connecting to the pg server port, ie
portscanner, someone telnetting, net bot, etc.
Jason Minion
-
also want to make sure to read and
understand the relevant sections in the manual:
http://www.postgresql.org/docs/8.1/interactive/client-authentication.htm
l
Good luck!
Jason Minion
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of German Raul Hoy
Title: sql copy does not work
You probably need to add escaped slashes into your perl
string to escape the quotes on the command line. Maybe try:
system ("su - postgres -c \"echo \"\\\"\"copy test from
\'/data/log/20060115.out\'\;\"\\\"\"
/interactive/sql-createsequence.html
Jason Minion
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Suvarna
Sent: Monday, February 27, 2006 11:51 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] problem in sequence
In postgresql 7.3.2 if the server
Assuming your New.dt is a date type and NEW.months is an integer, you
probably want to change your expression to something like:
NEW.dt + (NEW.months * INTERVAL '1 month')
Also a good read:
http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html
Jason Minion
---
Does the local postgresql user account on machine B have the correct
permissions for the files you copied over? Also make sure to try
starting postgresql from the command line using pg_ctl, and check your
service properties to get an idea of the command being used there to
attempt to start postgres
Instead of:
interval "numDays day"
use:
(numDays * (interval '1 day'))
Also, note that in your "select to_char" you have misspelled (sp?)
interval as "inteval".
And last but not least, you can do simple day addition and subtraction
with dates using integers. For example:
> select '2
Perhaps a BEFORE UPDATE trigger, setting NEW.do_not_change_me =
OLD.do_not_change_me?
Jason Minion
IT Developer
Sigler Printing & Publishing
413 Northwestern Ave
Ames, IA 50010
515-232-6997
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Be
reSQL at a command prompt check:
> pg_ctl.exe --help
You'll want to use the runas command to run the pg_ctl.exe under another
(unprivileged!) user account:
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/runas.mspx
Jason Minion
IT Developer
Sigler Printin
Take a look at the .pgpass file, some info at:
http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html
Doing that, your password is still as secure as your .pgpass file,
which hopefully is more secure than your script.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
Check out http://www.postgresql.org/docs/8.0/interactive/functions-sequence.html
You'll want to use something like "SELECT currval('')". The
thing
is, your orderid field in orderstemp has a sequence which it uses to grab the
next value. The currval function called with the name of the sequence as
It looks like you're using two different fields in the where clause which
is kind of bad form. Try (pm.global_id is null or pm.global_id = 2915). The
thing
is, if you have matching records in project_members for every record in project
with the IDs, then pm.project_id will never be null. Thus, the
If he's using a restriction upon an outer joined table in the where clause
it might be returning results like it was an inner join, ie:
select * from A left outer join B on A.id=B.id
where B.accessed>'2005-10-31';
Instead you'd want to check for the outer joined field having a null
value in the w
Go for it, it's suggested:
http://www.postgresql.org/docs/8.0/interactive/wal-internals.html
Jason Minion
IT Developer
Sigler Printing & Publishing
413 Northwestern Ave
Ames, IA 50010
515-232-6997
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
I think the way you want to look at it is: if a record exists in
sample_attributesjoin, then it needs to reference both samples
and attributes. You don't need to worry about samples or attributes
being "off" because they don't have "enough" references, instead
you want to ensure that if a record ex
C, Perl, etc you should directly
connect using libpq, DBI, etc and pass the credentials that way.
Good luck!
Jason Minion
IT Developer
Sigler Printing & Publishing
413 Northwestern Ave
Ames, IA 50010
515-232-6997
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[ma
returndate IS NULL THEN NEW.returndate :=
\'now\'; END IF; END IF; RETURN
NEW;END;' LANGUAGE 'plpgsql' VOLATILE;
In that case
returndate is a timestamp. Hope it helps!
Jason Minion
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTE
If you are running version 8, you may want to look into the WAL archiving:
http://www.postgresql.org/docs/8.0/interactive/backup-online.html
That would form the basis of your incremental backup strategy. I haven't had
the joy of using them myself however, and do not know of any tools to make it
pg_ctl reload [ -s ] [ -D datadir ]
You might want to check man page on pg_ctl, it's very useful!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of David Wagoner
Sent: Wednesday, March 16, 2005 8:28 AM
To: PgSQL Admin
Subject: [ADMIN] Re-initialize pg_hba.conf
25 matches
Mail list logo
