retoring a PostgreSQL database from one server to another
by Beau BOB
Hi,
I have postgresql 7.4.1 and I'm restoring to another server that has postgresql 7.4.6
for dumping I'm using :
pg_dumpall --clean -h localhost -U postgres -p 5432 > dbfile
and for restoring I use many methods:
psql -h localhost -U postgres -d template1 -f dbfile
and I have this error message when I run the PgAdminIII to connect my data base:
"error relation pg_settings not found " & " error relation pg_user not found"
and when I use the commands:
psql -l
ERROR: relation "pg_catalog.pg_user" not found
notice that when I make restore , I have many error message about missing relation ;
please can anybody help me to resolv my problem
thanks for advance
_________________________________________________________________
Essayez Live.com et créez l'Internet qui vous ressemble : infos, sports, météo et bien plus encore !
http://www.live.com/getstarted
17 years, 2 months
Scanner permission
by Frank Cox
I am attempting to hook a USB scanner to a FC6 box and have the usual problem
of only being able to scan (and find the scanner) as root.
How do I go about fixing this?
--
MELVILLE THEATRE ~ Melville Sask ~ http://www.melvilletheatre.com
17 years, 2 months
Re: tzdata for Core 4 (Jakub Jelinek
by Randy Easley
On Tue, Feb 27, 2007 at 03:18:33PM -0500, Steven W. Orr wrote:
> I'm still running Core 4 and the new DST is coming at me like a
freight
> train. I got the latest src for Core 5: tzdata-2006p-1 and built it
and
> installed it so I now have tzdata-2006-1 on my system.
>
> % > rpm -q tzdata-2006p
> tzdata-2006p-1
>
> The problem is:
>
> % > date -d '27 March'
> Tue Mar 27 00:00:00 EST 2007
>
> Note that it says EST instead of EDT. I have no TZ variable set.
>
> Can someone *please* tell what I have to do to fix this?
FC4 glibc didn't have /usr/sbin/tzdata-update (it was only introduced in
FC5+ and later backported to RHEL4 and RHEL3). So, after you update
tzdata
package, if the changes are in your default timezone, you need to
return system-config-date or manually update /etc/localtime.
Jakub
Why can't you run yum update tzdata or use up2date???
BTW, you are saying FC5 machines do not need to do anything? The new DST
is already in place? I have 2 Fedora releases in the field. FC3 and FC5.
I also have several hundred legacy 7.2 redhat machines out there with no
internet connection. Any ideas on how to fix them?
Thanks
17 years, 2 months
SFTP servers do not show in nautilus network://
by Gérard Milmeister
I have one desktop computer connected via wired ethernet to a ADSL
modem-router an one laptop connected via wireless to this router. When I
open nautilus network:// on the desktop I can see both the desktop and
the laptop SFTP servers. However on the laptop I don't see either. The
avahi daemon runs on both computers and avahi-resolve -a as well as
avahi-discover show the same output on both computers.
What am I doing wrong?
--
Gérard Milmeister
Langackerstrasse 49
CH-8057 Zürich
17 years, 2 months
approved mechanism to switch to 32-bit firefox?
by Jack Howarth
I noticed that a fresh install of x86_64 FC6 resulted in
both i386 and x86_64 packages for firefox being installed.
I would like to configure my machine to default to the
i386 version of firefox and am wondering if there is
an approved mechanism to setting this (since FC6 went
out of its way to preinstall the i386 binaries on
x86_64)?
Jack
17 years, 2 months
fedora OS high memory usage
by Ravi Malghan
Hi: I have installed Fedora 6 on a laptop with 756MB
RAM. With no application started when the machine
boots up, the top is saying that, 601308K is being
used.
Mem: 774356k total, 601308k used, 173048k free,
19348k buffers
Is this normal? or is this not really what it means. I
read some postings that the memory usage shown here is
what is allocated for the processes and not how much
is being used.
Any thoughts?
Thanks
Ravi
____________________________________________________________________________________
Cheap talk?
Check out Yahoo! Messenger's low PC-to-Phone call rates.
http://voice.yahoo.com
17 years, 2 months
CLOCK_PROCESS_CPUTIME_ID clock doesn't increment seconds
by Jean-Rene David
The following test case works fine on Core3 but
fails on Core6.
$cat /etc/fedora-release
Fedora Core release 3 (Heidelberg)
$ cat test.c
#include <stdio.h>
#include <unistd.h>
#include <time.h>
int main(void) {
int i;
struct timespec start_rt, start_id;
struct timespec now_rt, now_id;
clock_gettime(CLOCK_REALTIME, &start_rt);
clock_gettime(CLOCK_PROCESS_CPUTIME_ID, &start_id);
for(i=0; i<5; i++) {
if(clock_gettime(CLOCK_REALTIME, &now_rt)!=0)
{
fprintf(stderr, "Error!\n");
return 1;
}
if(clock_gettime(CLOCK_PROCESS_CPUTIME_ID, &now_id))
{
fprintf(stderr, "Error!\n");
return 1;
}
// First column CLOCK_REALTIME
printf("%d.%d\t", now_rt.tv_sec - start_rt.tv_sec,
now_rt.tv_nsec - start_rt.tv_nsec);
// Second column CLOCK_PROCESS_CPUTIME_ID
printf("%d.%d\t", now_id.tv_sec - start_id.tv_sec,
now_id.tv_nsec - start_id.tv_nsec);
printf("\n");
sleep(1);
}
return 0;
}
$ gcc test.c -lrt
$ ./a.out
0.73000 0.68477
1.1563000 1.1142818
2.3410000 2.2632301
3.5258000 3.4122795
4.7106000 4.5611411
$ /lib/libc.so.6
GNU C Library stable release version 2.3.3, by Roland McGrath et al.
Copyright (C) 2004 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
Compiled by GNU CC version 3.4.2 20041017 (Red Hat 3.4.2-6.fc3).
Compiled on a Linux 2.4.20 system on 2004-10-27.
Available extensions:
GNU libio by Per Bothner
crypt add-on version 2.1 by Michael Glad and others
linuxthreads-0.10 by Xavier Leroy
The C stubs add-on version 2.1.2.
BIND-8.2.3-T5B
NIS(YP)/NIS+ NSS modules 0.19 by Thorsten Kukuk
Glibc-2.0 compatibility add-on by Cristian Gafton
GNU Libidn by Simon Josefsson
libthread_db work sponsored by Alpha Processor Inc
Thread-local storage support included.
For bug reporting instructions, please see:
<http://www.gnu.org/software/libc/bugs.html>.
$ uname -a
Linux x.x.x 2.6.9-1.667 #1 Tue Nov 2
14:41:25 EST 2004 i686 i686 i386 GNU/Linux
However on Core6:
$cat /etc/fedora-release
Fedora Core release 6 (Zod)
$ gcc test.c -lrt
$ ./a.out
0.5000 0.69347
1.3222000 0.113973
2.3297000 0.147403
3.3354000 0.180369
4.3417000 0.213781
Note the seconds don't increment on the right
column.
$ /lib/libc.so.6
GNU C Library stable release version 2.5, by Roland McGrath et al.
Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
Compiled by GNU CC version 4.1.1 20060928 (Red Hat 4.1.1-28).
Compiled on a Linux 2.6.9 system on 2006-10-08.
Available extensions:
The C stubs add-on version 2.1.2.
crypt add-on version 2.1 by Michael Glad and others
GNU Libidn by Simon Josefsson
GNU libio by Per Bothner
NIS(YP)/NIS+ NSS modules 0.19 by Thorsten Kukuk
Native POSIX Threads Library by Ulrich Drepper et al
BIND-8.2.3-T5B
RT using linux kernel aio
Thread-local storage support included.
For bug reporting instructions, please see:
<http://www.gnu.org/software/libc/bugs.html>.
$ uname -a
Linux x.x.x 2.6.18-1.2798.fc6xen #1
SMP Mon Oct 16 15:11:19 EDT 2006 i686 i686 i386
GNU/Linux
Any clue?
--
JR
17 years, 2 months
FC6 & DELL Optiplex GX745
by Jouk Jansen
Hi all,
Does anyone know if FC6 (latest kernel update) runs on a Dell Optiplex GX745?
Jouk Jansen
Bush : All votes are equal but some votes are more equal than others.
>------------------------------------------------------------------------------<
Jouk Jansen
joukj(a)hrem.nano.tudelft.nl
Technische Universiteit Delft tttttttttt uu uu ddddddd
Kavli Institute of Nanoscience tttttttttt uu uu dd dd
Nationaal centrum voor HREM tt uu uu dd dd
Lorentzweg 1 tt uu uu dd dd
2628 CJ Delft tt uu uu dd dd
Nederland tt uu uu dd dd
tel. 31-15-2782272 tt uuuuuuu ddddddd
>------------------------------------------------------------------------------<
17 years, 2 months
More on bittorrent
by Aaron Konstam
>>
>>Aaron Konstam wrote:
>> I wanted to download the latest FC6 respin CDs. I went to the web
>> location and found the correct bittorrent and clicked to download it.
>> The bittorrent GUI opened and the download started. Now I was
connected
>> to a system with an Internet speed of 45 Mb/s but the GUI said the
>> download would take 15 hours. Well the respin has 5 CDs. I have a
>> downloaded a single 600+ Meg CD in less than an hour (actually I
think
>> it was much less). So I can't understand why the bittorrent download
>> should take 15 hours.
>>
>> I have done this before but it has been a long time ago. I must be
doing
>> something wrong but what? Any ideas?
>
>A couple of things to check - do you have a download speed limit
>set, so that it does not use the full bandwidth when downloading? Do
>you have your firewall properly configured so that you can seed as
>well as download? If not, this can limit your download speed. How
>many seeds are there, compared to the number of clients, and how
>many are you connected to?
My download speed was set too high. I have no firewall set on my machine
but the university does however they tell me that they do not restrict
bittorrents. I don't know how to check the number of seeds and /or
number of clients.
So there are clearly holes in my knowledge. Can someone help fill in the
gaps.
>
>One other thing to keep in mind is that the time estimate when you
>first start downloading is usually high, and drops as you connect to
>more feeds. It also tends to change during the download. Depending
>on how the client calculates the time remaining, it may get less
>sensitive to rate changes as the download progresses - more data to
>average, so temporary fluctuations in download speed do not affect
>it as much.
The above is true but I waited 2 hours and not even 1 CD was downloaded.
--
Aaron Konstam <akonstam(a)sbcglobal.net>
17 years, 2 months