Are you talking about inserting a lot of data at one time? If so, drop
the index on the tables involved before inserting. You may also want to
turn fsync off as well.
On Thu, 2002-03-07 at 12:27, Jodi Kanter wrote:
> Did my message below make it out to the list? or is it that no one has any idea
On Thu, 7 Mar 2002, Stephan Szabo wrote:
>
> On Thu, 7 Mar 2002, Joel Mc Graw wrote:
>
> > I had a table (job_documents) that referenced another (jobs). I no
> > longer needed job_documents, so I dropped it. Now, any attempt to
> > delete rows from jobs fails--it complains that job_documents do
Joel Mc Graw <[EMAIL PROTECTED]> writes:
> I had a table (job_documents) that referenced another (jobs). I no
> longer needed job_documents, so I dropped it. Now, any attempt to
> delete rows from jobs fails--it complains that job_documents doesn't
> exist. Is there a way to fix this?
Drop the
hi,
Before taking backup with pg_dump, give createdb and createuser
privileges to all the users of the first database.Then restore it
in the second database with pg_restore.I don't know why they made
the privileges required for taking backup.
--with regrard
chava
--
Srinivasa R Chava (Chava) <[E
Did my message below make it out to the list? or is it that no one has any
idea what I am referring to? If not, could someone point me to ways to improve
insertion time. I am vacuuming regularly.
thanks
Jodi
- Original Message -
From: Jodi Kanter
To: Postgres Admin List
Sent: We
"Tim Finch, FosterFinch Ltd" <[EMAIL PROTECTED]> writes:
> Hi. I have been posting messages on the cygwin list about trouble running
> the postmaster I will not re post it here but simply would like to ask if
> anyone knows what, even on a traditional unix platform, the log file
> message from
On Thu, 7 Mar 2002, Joel Mc Graw wrote:
> I had a table (job_documents) that referenced another (jobs). I no
> longer needed job_documents, so I dropped it. Now, any attempt to
> delete rows from jobs fails--it complains that job_documents doesn't
> exist. Is there a way to fix this?
You'll
What is the best way to use an integer variable that
contains some value for number of hours and
add that to a date field?
__
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
--
"Markus Wollny" <[EMAIL PROTECTED]> writes:
> This is the relevant bit of the Logfile:
What are your client(s) doing to provoke this crash? (If you don't
already know, try running the postmaster at -d2 to get logging of
queries. Might want to turn on log_connections and log_pid too.)
I doubt t
I had a table (job_documents) that referenced another (jobs). I no
longer needed job_documents, so I dropped it. Now, any attempt to
delete rows from jobs fails--it complains that job_documents doesn't
exist. Is there a way to fix this?
PostgreSQL 7.1.3/FreeBSD 4.2R
TIA
>
>I'm running PGSQL 7.1.3 and Debian Linux 2.4.14 on an Athlon 1.4Ghz box with
>512MB RAM & IDE drives.
>
>Any thoughts appreciated- I'm trying to decide whether I should cancel the
>vacuum & do an autopsy.
I do a nightly vacuum analyze of databases that are about 2-5 gig. The
longest one tak
I'm trying to backup and restore database from DBname to DBname2 (e.g. copy
database. it is for example).
When i'm trying to use these commands :
#pg_dump -f DBname.tar -b -o -Ft DBname
#createdb DBname2
#pg_restore -Ft -d DBname2 -f DBname.tar
pg_dump works fine, but pg_restore produce thi
Hi
Can someone please tell me the difference between
starting postgres with /etc/rc.d/init.d/postgresql
start/stop or making use of the option -D -l
start/stop to /usr/bin/pg_ctl that starts/stop the
postmaster.
And which are the better linux internet servers to run
with postgres?
Thanks
Nic
Hi
I want to program pg_dump in crontab but with authentification of user
pg_dump prompt a user name and password.
how can i backup my database automatic (one backup for a day).
pg_version :7.0
Thanks
--
___
Fouad Fezzi
Ingenieur Réseau
IUP Institut Universitaire Pro
Hi. I have been posting messages on the cygwin list about trouble running
the postmaster I will not re post it here but simply would like to ask if
anyone knows what, even on a traditional unix platform, the log file
message from the postmaster daemon process
PGSTAT: connect(2): Connection ref
Ladies and gents,
I've searched around a bit, and can't seems to find any solid opinion
as to which OS postgresql likes best. Surely some of you, my intrepid
fellow travelers, have done some investigation into this on your own.
What did you find?
I'll be more specific, and describe what I'm usi
The Debian packages of PostgreSQL 7.2 have now been installed in the
Debian archive (non-US unstable).
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 61
I installed pg on a Redhat 7 box but dont know which tool
i can us to admininstrate (visual) the databases.
Can anyone help me?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister Yo
On Thu, 2002-03-07 at 00:02, Peter Darley wrote:
> Ian,
> By better I guess I mean faster. I'm looking to get the most speed out of
> my database without having to invest in new hardware.
> Thanks,
> Peter Darley
You would be better off building your own. Debian, at least, configures
Post
Hello!
This behaviour is starting to get on my nerves...
Could somebody give me a hint as to what exactly happened here and how I
can avoid it in the future?
This is the relevant bit of the Logfile:
snip
2002-03-06 16:02:52 FATAL 1: Database "template0" is not c
> I'm wondering if there is a specific Linux distribution for the x86 that
> will provide a better PostgreSQL server than the other ones?
> Thanks,
> Peter Darley
Dear Peter,
PostgreSQL will only be PostgreSQL and there is no real difference, except
compilation choices and RPM package names.
I
21 matches
Mail list logo