schema. Also, given you're making this leap, I'd
strongly encourage you to try and migrate to Postgres 9.2 instead of
8.4, which is the next version to be EOL'd. It's unlikely the pain
will be significantly worse than what you are going through now.
Robert Treat
conjecture: xzilla.net
consulting
an
old project that dealt with this a little more fine grained, you might
want to take a look at it:
https://github.com/xzilla/secure_check_postgres/tree/master/sql
It certainly needs updating for 9.2, but the concepts might still be useful.
Robert Treat
conjecture: xzilla.net
consulting
work.
Robert Treat
play: xzilla.net
work: omniti.com
On Wed, Nov 28, 2012 at 1:46 PM, Gabriel Muñoz gabriel.mu...@gmail.com wrote:
I'm using WAL, I follow this tutorial:
http://blog.gomiso.com/2012/02/13/adventures-in-scaling-part-3-postgresql-streaming-replication/
It's work perfect for me
to do, you can use
the omnipitr scripts to manage this, see
https://github.com/omniti-labs/omnipitr/ for details.
Robert Treat
play: xzilla.net
work: omniti.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
.
Robert Treat
play: xzilla.net
work: omniti.com
hiring: l42.org/lg
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
to look into omnipitr, it can
create filesystem level backups from a slave (not the same as a
logical export, but it might do).
Robert Treat
play: xzilla.net
work: omniti.com
hiring: l42.org/lg
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription
and pgport for the second cluster,
as they will both need to run simultaneously during the upgrade
process.
You have shown a lot of text above, but not the error message you got.
Can I see that please?
Agree with Bruce, showing us any error messages would be helpful.
Robert Treat
play
, and then tune it *down* (change, measure,
asses, repeat). Won't work for every workload, but in general that's
the way to go.
Robert Treat
play: xzilla.net
work: omniti.com
hiring: l42.org/Lg
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
necessarily have to break your
standby; rather it can happily sit around waiting for the next xlog to show
up. If you can fix connectivity to the NAS, it will happily start replaying
log files and catching up again.
Robert Treat
play: http://www.xzilla.net
work: http://omniti.com/is/hiring
agressivly
than you should be. I'd suggest you look into the %r option for pg_standby.
HTH.
--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
a way to make it work (I'm hopeful that newer versions of the software
involved might work, but haven't had any luck in the combinations I've tested
so far).
--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com
--
Sent via pgsql-admin mailing list (pgsql-admin
* :-) There are still a number of shortcomings, so depending on how
large and/or complicated your systems are, it may or may not work for you,
but it's certainly worth a look if you're planning a migration.
--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com
--
Sent via pgsql-admin
when we login to the server, we login with our LDAP username and
password.
Thanks and Regards,
Shilpa
--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription
mess.
--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
as a reference on the topic.
HTH
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
that might need to be done
somewhere in there)
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
anything special with the
postgresql setup, or if just setting the correct date on the machine is a
safe enough operation that nothing else would need to be done (like re-doing
the base backup). Any thoughts?
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
--
Sent via
, all of this is pretty minimal anyway,
so I'd probably recommend just doing it in whichever way you find most
comfortable, and worry about optimizing things later if you find it's too
slow.
--
Robert Treat
http://www.omniti.com
Internet Scalability Consulting
--
Sent via pgsql-admin mailing
going stright to
8.3. 8.1 is a few years old, and 8.3 provides a number of features and
improvement you'll benefit from. Unless you have a strong reason to do
otherwise, go to 8.3. HTH.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
--
Sent via pgsql-admin
client_encoding=WIN1250;
SET
pagila=# insert into x (r) values ('Daniel Brühl');
INSERT 0 1
pagila=# insert into x (r) values ('Daniel Bruehl');
INSERT 0 1
pagila=# select * from x;
r
---
Daniel Brühl
Daniel Bruehl
(2 rows)
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware
On Tuesday 28 August 2007 18:44, Simon Riggs wrote:
On Tue, 2007-08-28 at 17:59 -0400, Tom Lane wrote:
Robert Treat [EMAIL PROTECTED] writes:
Is there some way to force checkpoints on a db doing wal replay?
No, it's hardwired to do it when it sees a checkpoint record in the WAL
stream
On Monday 27 August 2007 19:17, Tom Lane wrote:
Robert Treat [EMAIL PROTECTED] writes:
LOG: database system was interrupted while in recovery at log time
2007-07-30 19:17:37 EDT
I am curious how this date is determined by postgres/pitr?
It's the update timestamp in pg_control, which
to catch up 5 hours later :-).But it would be good
to be able to predetermine that kind of thing.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase your free
approach, rather than the
bazooka method your using now) The downside is that 7.4's pg_autovacuum is a
little more complex than what you'll find in more recent versions of
postgres, but if you're having trouble getting a handle on a good vacuum
scheme, it might be worth it.
--
Robert Treat
the disk systems out underneath, but maintain the same
mountpoint, and not let the db care about the difference.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our
be
nice to end up with a cert to show for all the monies spent. :)
SRA created a program back in the 7.4 days (I'm certified woohoo!), though I'm
not sure it is still activly offered in the USA (I believe it is in Japan
though). HTH
--
Robert Treat
Build A Brighter LAMP :: Linux Apache
...
http://www.postgresql.org/docs/8.2/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase your free
that you
keep a copy of your 7.1 databases running until your done testing, and make
sure to test your applications thoroughly. Also don't forget that any
applications /drivers/ libraries that are built against 7.1 should be
updated / recompiled against newer versions as well. HTH.
--
Robert
database size, or match things up manually on disk with select
oid,datname from pg_database.
--
Robert Treat
Database Architect
http://www.omniti.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
, but if you're sure a
function is the way to go, see the docs on set returning functions:
http://www.postgresql.org/docs/current/static/xfunc-sql.html#XFUNC-SQL-TABLE-FUNCTIONS
--
Robert Treat
Database Architect
http://www.omniti.com/
---(end of broadcast
of the config files since these were
changed? Try doing a select * from pg_settings where name ~ 'autovacuum' to
see what your db is currently using.
--
Robert Treat
Database Architect
http://www.omniti.com
---(end of broadcast)---
TIP 6: explain
pg_catalog.pg_views.definition.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
(and do with our servers @ omniti) is to have a script that does a
pg_dumpall -g for the global objects and then individual pg_dump -Fc's for
each database in the cluster.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast
a slave DBMS could limit the down-time.
Using slony is another option, though if your unfamiliar it certainly comes
with more complexity than the first solution.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast
?
http://archives.postgresql.org
!DSPAM:37,4559da5e40419901994390!
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
between two databases. As I
recall, if you have different schema it just blows up.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
(; http://www.postgresql.org/about/history). those should
bring back some relevant ideas though the code is probably written from that
time.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5
but are there
built-in features of the database itself that can implement automated
backups?
It's not built into the database, you need some function of the os to
run a script that makes use of pg_dump. In 'nix you can use cron, in
winders I believe you can use 'task scheduler'.
Robert Treat
google the relevant keywords if you want
to learn more.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org
will still
help a lot since growing the files will be in your 1 process connection
timeline.
taken from an interesting post at
http://blogs.sun.com/roller/page/jkshah?anchor=postgres_what_needs_to_be
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
sufficient to recreate
the entire database ?
Assuming your version of pg_dump dumps binary data with an -Fc dump, then yes.
(Check the docs if you want to verify)
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast
try and resolve some i/o issues.
AFAIK unless your actually doing something,it wont access your data files at
all. Note that something is pretty wide here, insert/update/vacuum/analyze
and even select will cause file access but otherwise it wont.
--
Robert Treat
Build A Brighter Lamp
referential integrity your database once had with
this data.
If you really are going to be deleting data that has a bunch of related data
in other tables, istm that that should be handled by some foriegn keys, so
I'm a bit suspicious of your db schema based on this email. Just my .02.
--
Robert
.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 6: explain analyze is your friend
something from scratch, just issue begins at the
start of each connection.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
the second option, if you want something fancier you
could look at http://nagios.sourceforge.net. HTH.
Robert Treat
On Mon, 2005-04-18 at 17:51, Garris, Nicole wrote:
Yes, I looked at pgMail, thinking I could put a trigger on some system
table(s). PgMail is a function which produces an e-mail
On Monday 27 December 2004 22:14, Leo Liou wrote:
(B Hello, I'm a newbie at using Postgresql.
(B I have a huge problem at using uppercase and lowercase.
(B
(B My question is if there is any possible way to set
(B my Postgresql7.4.3 to uppercase?
(B I mean if it's possible to set the DB
between two databases. As I
recall, if you have different schema it just blows up.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
retrieving 323 rows from at best 1323 rows in the table, so the database
figures it can grab all of the records much faster by just doing a seq scan
on the table. Try adding some more data to the table and/or selecting a
specific value and you'll see your index get used.
--
Robert Treat
databases from a system? If so, remove whatever
directory PGDATA is set to and then run initdb on the new PGDATA
directory. Be aware that this is basically like starting from scratch,
you will lose all of your information.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
message and version information.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
to produce SQL would that be feasible? Presumably pg does something
like this internally for rollforward recovery, so I guess it would be
possible.
If you want real SQL, you'll need to turn on SQL logging in
postgresql.conf.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware
the template1 database?
I want to make sure the normal users cannot edit the template1 database.
I usually hate posts like this, but I am pretty sure phppgadmin will do what
you want.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end
the
latest build.
Question: is this a real windows version? Not cygwin?
it is a native version for windows, not cygwin. (they are both real, since
they both exist, but i suspect this is just a language barrier issue).
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
not enter any password while adding the user. Could some
body help me with this?
You should be able to su to the postgres user from root. Otherwise I'd have
to point you to man adduser since that's an OS problem you have.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware
a single question in the main postgresql pointing to
both of the other faqs... anyone have a preference?
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 9: the planner will ignore your desire
, with a section on general stuff, cygwiun stuff, and native
stuff. Both projects could then just link to that faq.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 7: don't forget to increase
that they are actually making
worse by porting all their apps to ingres).
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
On Fri, 2004-07-16 at 10:42, Cardoso Patrick wrote:
Hi,
Is it possible to know the number of users connected to a
database ?
Regards
select * from pg_stat_activity;
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
that there is a slony mailing list at
http://gborg.postgresql.org/mailman/listinfo/slony1-general right? Does
that not serve your purposes?
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 1
do a vacuum full on template1 and see if it reappears.
Robert Treat
On Tue, 2004-06-15 at 13:10, Lee Wu wrote:
Hi Duane,
It seems it is not:
mxl=# show search_path;
search_path
--
$user,public
(1 row)
mxl=# select current_schema(), current_user
anyway to extract data and reconstruct a new database? We tried
pg_dump but had a host of errors.
My guess is that you have hit xid wrap around. Try vacuuming full
template1 and see if your info starts to reappear. Also watch to see if
it tells you some other db's need vacuum.
Robert Treat
at http://sourceforge.net/projects/pgsql/ which
has the main packages on it.
Robert Treat
On Wed, 2004-06-02 at 15:35, Bruno Wolff III wrote:
On Tue, Jun 01, 2004 at 16:44:30 -0700,
Mark Espinoza [EMAIL PROTECTED] wrote:
To whom it may concern,
I really had no idea who to send my email
benchmarks on the system, check the archives or the osdl site for more info
on getting these up and running.
Robert Treat
On Monday 24 May 2004 09:59, Greg Spiegelberg wrote:
Robert,
I am currently evaluating PolyServe Matrix Server which is a clustering
solution including a clustered file
start here: http://techdocs.postgresql.org/guides/GUITools
Robert Treat
On Fri, 2004-05-21 at 22:18, Paul Gimpelj wrote:
hi,
I was wondering if someone can give me some advice.
I presently use pgaccess tcl based.
But I would prefer a c or c++ client server admin , somewhat like
I am thinking that the entry for this ip has an issue with the username and/or
database specified in the line (or maybe conflicting entries?) Would you
mind posting your complete pg_hba.conf to the list?
Robert Treat
On Tuesday 25 May 2004 10:50, [EMAIL PROTECTED] wrote:
Yes sir, did
or available as a pdf?
Unfortunately neither. I've tried to get in contact with the sites owner
since I would be happy to add the content to techdocs, but haven't been
successful... anyone know how to get in contact with him?
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware
connecting from)
HTH
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 8: explain analyze is your friend
not heard of any reports on these lists of
how well it works. If you (or anyone else) gives it a spin please try to
post an account to the list and/or if you send me the info it could
probably make its way on to techdocs.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware
the trigger function check for the CURRENT_USER
setting and then act accordingly.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
reported
in the logs of type FATAL, can you send us that?
Robert Treat
On Friday 21 May 2004 17:01, [EMAIL PROTECTED] wrote:
Thanks Robert!
I did that as well and still didn't work. Any other ideas?
-Original Message-
From: Robert Treat [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21
On Thu, 2004-05-20 at 00:44, darshan patel wrote:
I had instal postgresql on suse Linux,now i want to Instal phpPgAdmin so
what is the procedure
Go to http://phppgadmin.sourceforge.net/?page=download
unpack the source code and read the INSTALL file.
Robert Treat
--
Build A Brighter
/projdisplay.php
If you run across any others please lmk, I think I'm going to need this
for a project in the next few days.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: Have you
you plan on using them that makes the difference. And even then it's
dependent on your hardware more than PostgreSQL itself.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Don't 'kill
with problem dumps
(though it will be slower)
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's
is available in 7.5. At least I seem to remember some
(Chris K-L) posting a patch and it getting committed. You could check
the developers docs to verify I suppose.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast
like this is not what you
want, you need to modify your pg_hba.conf file and change the settings
as appropriate. (See comments in the file or docs for specifics on the
different options)
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end
/Makefile?rev=1.65content-type=text/x-cvsweb-markup
Yep. IMHO this is more do to a political agenda they are trying to push
than any true basis in legal fact, as again, they could easily contact
this project for a letter of clarification if their goal was to protect
themselves legally.
Robert Treat
You might get better results using 7.4's pg_dump against the 7.2 database...
worth a try anyway.
Robert Treat
On Monday 16 February 2004 07:59, Jarmo Järvenpää wrote:
Dear all,
I've got an old 7.2.4 DB which I hoped to upgrade to 7.4.1.
The old syntax used for creating tables had lines like
case, but still a pretty serious one. You
should talk to your webhost about getting on 7.3.5 asap.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
the shell, not from inside the database,
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes
the core developers to change this behavior.
Robert Treat
On Sun, 2004-01-25 at 13:09, Andrew Biagioni wrote:
In the v7.3 docs:
http://www.postgresql.org/docs/7.3/interactive/transaction-iso.html#XACT
-READ-COMMITTED
http://www.postgresql.org/docs/7.3/interactive/transaction-iso.html#XAC
T
(follow-ups should go to pgsql-php which is at least slightly on topic)
You need to either find an rpm for suse that gives postgresql support to
php (on red-hat systems the rpm is php-pgsql iirc), or recompile your
php from source with postgresql support.
Robert Treat
On Sun, 2004-01-25
terribly compatible, and I think there are quirks
in how the two implementations actually work, so you'll want to test
this as well.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 7: don't
for folks to
do a test installation and test there apps out just to be on the safe
side.
Robert Treat
On Sun, 2003-12-07 at 03:54, Sai Hertz And Control Systems wrote:
Dear all ,
Permit me to gain some of your most valuable knowledge ...
Our intrAnet server has the following spec
should really either shut down the
database or get LVM going.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
do // drop database DB1 // the first database will drop,
though you might want to verify if it is really damaged.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 5: Have you checked our
if it's a pg_hba issue, he should get a FATAL authentication
failed-ish message. I'd check for tcpip_socket=true in postgresql.conf
first.
Robert Treat
On Fri, 2003-10-24 at 11:00, Oliver Scheit wrote:
edit your pg_hba.conf
regards,
Oli
-Ursprüngliche Nachricht-
Von: Per
://theregister.co.uk/content/53/33299.html
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
be seeing how many pages are used up
after each add/delete/vacuum cycle. One other thing to check on is if
you have an indexes involved in the process, you may get some index
growth issues that will require periodic indexing. HTH,
Robert Treat
* I'm pretty sure those aren't the exact names
by id having count(*) 1;
and actually just running that would allow you to skip the check from
above.
HTH
Robert Treat
psql database -Uuser -c 'select id,count(*) from table gropu by id' | grep -v '1$';
Alex Turner
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
application so I really do
not know what am I doing and this could be a really stupid mistake,
please be gentle
Many thanks for your assistance.
http://www.postgresql.org/docs/7.3/interactive/creating-cluster.html
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware
Personally I'd like to see effort go into getting fts.postgresql.org
back up and going; I've always had better results searching their.
Robert Treat
On Thu, 2003-09-04 at 14:38, Marc G. Fournier wrote:
k, try the search engine now ... I just found a 'missing index' on one of
the critical
.estado_cliente , ftcofi00.grupo_faturamento ) and it still
taking almost 4 min to return. Does anyone have a hint to give me to make it
faster ?
Make sure you have run vacuum analyze on your database, if it is still
slow post explain analyze query to pgsql-performance mailing list
Robert Treat
--
Build
://www.postgresql.org/docs/7.3/interactive/runtime-config.html
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister
a postgres database can grow? I
have huge data to store.
real big, most likely limited by your OS. i think the largest reported
is like 4TB
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 1
. It's on the 7.4 branch, not on the 7.3 branch, but the authors
mentioned that at least initially it would run against 7.3.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 4: Don't 'kill -9
Hey guys, one of my servers is running Red Hat 7.3, what's my best bet
for upgrading? Rebuild from postgresql-7.3.4-1PGDG.src.rpm? Rebuild from
postgresql-7.3.4-1PGDG.rh73.src.rpm in the aurora directory? Will
someone be submitting a 73 rpm for redhat 7.3 / i386 ? THanks in
advance,
Robert Treat
language. though i didn't notice any in the source
code, it is possible that someone has already done this, check out
http://pgsqlbr.querencialivre.rs.gov.br/ for more info.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast
1 - 100 of 171 matches
Mail list logo