hope someone can suggest something - I'm desperate! It'll take weeks
to re-input that data automatically.
Thanks
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
Late as it is, I'll try this monday. I hope it works, other suggestions
still welcome of course, thanks very much.
On Fri, 27 Jun 2003, Tom Lane wrote:
Sam Barnett-Cormack [EMAIL PROTECTED] writes:
[ accidentally clobbered pg_control ]
It sounds like the main problem is too small a value
the db to a file, and cleanly
resotred from it. You should also manually check for inconsistencies,
although if you have correctly used contraints it should barf on input
if there are any. Assuming your DB is fully normalised.
Hope that helps
--
Sam Barnett-Cormack
Software Developer
it should barf on input
if there are any. Assuming your DB is fully normalised.
Hope that helps
--
Sam Barnett-Cormack
Software Developer | Student of Physics
Maths UK Mirror Service (http://www.mirror.ac.uk) | Lancaster
University
)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
--
Sam Barnett
On Tue, 1 Jul 2003, Tom Lane wrote:
Sam Barnett-Cormack [EMAIL PROTECTED] writes:
On Tue, 1 Jul 2003, Michiel Lange wrote:
_Could_ it be that you're hitting a filesystem limit here? I am not 100%
certain, but I believe ext2 by default supports only files of 2.? GB at
most... Yet I am
a really quite large DB, but I am *really* struggling with 1GB
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end of broadcast
On Thu, 3 Jul 2003, scott.marlowe wrote:
On Thu, 3 Jul 2003, Sam Barnett-Cormack wrote:
On Thu, 3 Jul 2003, scott.marlowe wrote:
We went from 512 Meg to 1.5 Gig and the change was tremendous. That box
ran Apache/Postgresql/auth_ldap/LDAP and now has 800 Meg of cache mem and
about
an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster
On Mon, 7 Jul 2003, Nick Fankhauser wrote:
-There is plenty of disk space available.
Does it stop at a filesize limit imposed by the OS or filesystem, such
as 2.0GB as commonly found on linux, or NFS?
Sam
---(end of broadcast)---
TIP 8: explain
On Thu, 31 Jul 2003, Joe Maldonado wrote:
I know in Oracle you can partition the tables into logical subsets and
was wondering if this was also possible in postgres.
I *think* that a partial index is probably your best bet.
--
Sam Barnett-Cormack
Software Developer
Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http
.
Only try it if you have a lot of time and/or already know linux well. If
you have a *lot* of time, you will gain the knowledge as you go. If you
decide to, I'll see you on *that* mailing list.
Also, I recommend slackware as an LFS base.
--
Sam Barnett-Cormack
Software Developer
a very very big database, with indexes,
with no such problems. The table details that get dumped setup the
indexes, and AIUI the indexes are kept up-to-date as items are added.
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http
version is 5.0
There doesn't seem to be a problem with the mdb file as we are using
it in some of our other programs.
If someone has encountered this problem before or knows a solution
please reply.
Jean-Michel Gaudel
[EMAIL PROTECTED]
--
Sam Barnett-Cormack
Software Developer
On Wed, 20 Aug 2003, Dani Oderbolz wrote:
Guys,
be careful,
it seems that several Mails in the List have contained
a virus - I guess its sobig.f.
Or that a copy of sobig learned the mailing list address and masqueraded
as being from the list.
--
Sam Barnett-Cormack
Software Developer
the TRUE and false
for other situations.
A more general question:
Can the planner tell which index to use if there is more than one that
fits the bill? Like if there is a full index and one or more partial
indexes on a field, can it determine which to use for a given query?
--
Sam Barnett-Cormack
eg.
If the password mechanism uses standard crypt() passwords, then only the
first eight letters count. It just happens that postgres is eight
letters long.
This has been a public service educated guess.
--
Sam Barnett-Cormack
Software Developer | Student of Physics
my_sequence;
where my_sequence is the sequence name.
try:
\d my_sequence; (same substitution as before)
for more info.
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
Is there any way to change the prompt in the psql CLI client? In the
same way as one does with bash, or other shells.
Ideally I want:
[EMAIL PROTECTED]:database $
as the prompt. Anyone got any ideas/references?
--
Sam Barnett-Cormack
Software Developer | Student
On Mon, 1 Sep 2003, Renney Thomas wrote:
Sam Barnett-Cormack wrote:
Is there any way to change the prompt in the psql CLI client? In the
same way as one does with bash, or other shells.
Ideally I want:
[EMAIL PROTECTED]:database $
as the prompt. Anyone got any ideas/references
seems a bad idea generally. Instead,
why not make it store a new record for each instance, and have a cronjob
each day update the statistics from that. It will be more efficient,
overall. It can be done hourly, even.
--
Sam Barnett-Cormack
Software Developer | Student
a charm. You do have
to allow that queries are going to take a long time. I use about 6
queries to summarise a quarter's data - each run for each month, so a
total of 18 queries. These run in a little over 24 hours. And there are
many, many records per month.
--
Sam Barnett-Cormack
Software
would expect.
However, you may want to ensure that all tuning in postgresql.conf is
correct, as it may not be using all possible resources. That will
probably only make a small difference.
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror
On Mon, 8 Sep 2003, Vasilis Ventirozos wrote:
I use the default comfiguration file with the tcpip enabled
any sagestion about the configuration file ?
Post a copy of it to the list, along with the specs of the machine it is
running on, and I'm sure we'll all pipe in.
--
Sam Barnett-Cormack
be changed)
LC_MESSAGES = 'C'
LC_MONETARY = 'C'
LC_NUMERIC = 'C'
LC_TIME = 'C'
Hope some of that helps.
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
data on to two different disks. if so how?
For data redundancy, I reccomend RAID level 0 or 5 - 5 is vastly
superior, if you can afford it.
2. Steps needed to recover the data in case of database crash or hardware crash.
Keep regular backups with pg_dump
--
Sam Barnett-Cormack
Software
On Mon, 6 Oct 2003, Sam Barnett-Cormack wrote:
On Mon, 6 Oct 2003, Somasekhar Bangalore wrote:
Hi ,
I am setting up a postgres 7.3 database for a big client.I don't want to lose any
data in case of database crash or hardware failure . I need help in
1. Steps needed to setup
)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
joining column's datatypes do not match
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end of broadcast)---
TIP 8: explain
?
many thanks for your quick help,
Terry
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end of broadcast)---
TIP 5
are required for linux and solaris)
1.2.2. Required software packages.
Thank you very much.
Best regards,
JCD.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
--
Sam Barnett-Cormack
Software Developer
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end of broadcast)---
TIP 7: don't forget to increase your free space map
)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end
it, or if it could do that by itself.
Just brainstorming.
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end of broadcast)---
TIP 5
On Thu, 5 Feb 2004, Edoardo Ceccarelli wrote:
after a VACUUM FULL ANALYZE (1h!!) things are ok
Only a hour - lucky you ;)
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
vacuum locks the tables?
'full' is an option to vacuum, essentially, as is 'analyze', so there
are four variants (ignoring the freeze option):
vacuum
vacuum analyze
vacuum full
vacuum full analyze
It's all pretty obvious from there.
--
Sam Barnett-Cormack
Software Developer
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
)---
TIP 7: don't forget to increase your free space map settings
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end of broadcast
(095)939-16-83, +007(095)939-23-83
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http
?
http://archives.postgresql.org
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end of broadcast)---
TIP 9: the planner
On Sat, 6 Mar 2004, Bruno Wolff III wrote:
On Sat, Mar 06, 2004 at 12:52:33 +,
Sam Barnett-Cormack [EMAIL PROTECTED] wrote:
In my perl scripts, I have:
use DBI;
use DBD:Pg;
So maybe this is what you need?
Pg.pm is an alternate perl module that is closer to libpq than DBD::Pg
that seems, from my experience, to be relevant - are the
referenced/referencing columns indexed?
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end
, and field types at least.
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end of broadcast)---
TIP 7: don't forget to increase your
to connect, and the
problem continues...
Somebody could help me?
Thanks a lot!
Eduardo
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.644 / Virus Database: 412 - Release Date: 26/3/2004
--
Sam Barnett-Cormack
to disable it and try to connect, and the
problem continues...
Somebody could help me?
Thanks a lot!
Eduardo
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ( http://www.grisoft.com).
Version: 6.0.644 / Virus Database: 412 - Release Date: 26/3/2004
--
Sam Barnett
want an index on both of them together,
a joint index.
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end of broadcast)---
TIP 9
database with this upgrade?
You will need to do a dump/restore, yes - you always do when the second
part of the version number changes.
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
, you're creating the wrong way around. You want to be
adding the foreign keep to table2.
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end of broadcast
a functional index.
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end of broadcast)---
TIP 6: Have you searched our list archives
of the database is 167GiB. It runs
just fine, and that's on linux on intel hardware.
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end of broadcast
. Any
ideas what may be the root of the problem or how I can find out more
about this error PQputline returned?
Perhaps the other machine has a filesystem limit forbidding such large
files? Various filesystems have historically been limited to 2GB
--
Sam Barnett-Cormack
Software Developer
, is equivalent to table1
INNER JOIN table2 ON (table1.table2_keyfield = table2.table2_keyfield)
Feel free to look in the documentation under 'joins' - it's well
described in there.
--
Sam Barnett-Cormack
Student of Physics Maths | Programmer (Perl, PHP, C++, C, whatever)
Lancaster University
On Wed, 7 Jul 2004 [EMAIL PROTECTED] wrote:
Hi,
Could you please send me an advice how to configure Postgres database
With non standard pg_xlog directory location i.e. on other (non db) physical
disk ???
One word: symlinks.
--
Sam Barnett-Cormack
Software Developer
command.)
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
---(end of broadcast)---
TIP 2: you can get off all lists at once
)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
--
Sam Barnett-Cormack
Software Developer | Student of Physics Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
56 matches
Mail list logo
