Guys,
postgres : 7.4.5
Os: linux
I need to restore my back up database with production data.
the steps i follow on backup database are:-
1) dropdb
2) createdb
3) psql or pg_restore to import data into the backup database.
Am i doing the correct steps?.
Problems:-
If some clients are connected
Hi,
I've just sturted using postgresql 8 and I faced the following
problem: I want to use the "password" method for the user
authentication. In previous release, I linked the password_file to the
dbms through the pg_passwd command, placed in the POSGTRES_HOME/bin
directory.
Though the "password"
Dear Sir/Madam,
I am installing the software of GRASS, but I
met a prblem. When I do "./configure"
the last information on the screen as following:
"
checking for tcl.h... yes
checking for tk.h... yes
checking Tcl version... 8.4
checking Tk version... 8.4
checking for location of Tcl/Tk library..
Well ... I don't have an old version running to make a dump - that would
be easy.
I just got the files in a backup-directory ...
Any ideas?
Thanks!
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
"Chris White \(cjwhite\)" <[EMAIL PROTECTED]> writes:
> Just checked and found that the checkpoint interval is the same between
> 7.4.2 and 7.4.5. We also brought up a 7.4.2 version and didn't see these
> files being written/updated every 5 minutes. In which module are these files
> created?
See t
Tom Lane escreveu:
Sigh. I coulda sworn I tested this in December, but it's definitely
busted now:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=149237
(I might have messed up by only testing PG 8.0 --- 8.0 does not have
this problem, since initdb is no longer a shell script.)
The short-ter
Hello,
I'm trying to connect to a postgresql database through the postgresql
jdbc driver, but appears the errors below:
"$ java TesteJDBC_PGSQL
libgcj-java-placeholder.sh
This script is a placeholder for the /usr/bin/java
master link required by jpackage.org conventions. libgcj's
rmiregistry, rm
Tom Lane wrote:
> [EMAIL PROTECTED] writes:
>
>>I'm currently looking at using WAL / PITR backups for a database, and I
>>need to keep the backups as up to date as possible. As such, keeping a
>>copy of the current WAL file, as suggested in the manual, would seem to be
>>a very good idea. I'm s
Just checked and found that the checkpoint interval is the same between
7.4.2 and 7.4.5. We also brought up a 7.4.2 version and didn't see these
files being written/updated every 5 minutes. In which module are these files
created?
Chris White
-Original Message-
From: [EMAIL PROTECTED]
[ma
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 22 Feb 2005, Pallav Kalva wrote:
I still cant see RedHat 9 Source RPMS for the Postgres 8.0.1 in FTP mirror
sites , any ideas when it will up on FTP mirror site ?
It seems that I've forgotten to upload it before :(
It will be in main FTP si
Thanks for information. We will have to look at the changes we made in
postgresql.conf.
Chris White
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Tuesday, February 22, 2005 3:45 PM
To: [EMAIL PROTECTED]
Cc: pgsql-admin@postgresql.org
Subj
"Chris White (cjwhite)" <[EMAIL PROTECTED]> writes:
> We are noticing on our 7.4.5 system the following files are being written
> approximately every 5 minutes
> /tmp/.s.PGSQL.5432
> /tmp/.s.PGSQL.5432.lock
> Anybody know why they are being written?
So they don't get eaten by overenthusiastic /t
We are noticing on our 7.4.5 system the following files are being written
approximately every 5 minutes
/tmp/.s.PGSQL.5432
/tmp/.s.PGSQL.5432.lock
Anybody know why they are being written? The reason I ask is because we are
running on a system that uses a laptop disk drive and requires at least 10
On Tue, 2005-02-22 at 14:03, Indibil wrote:
> Hi:
>
> I want migrate to PostgreSQL 8.0.1 for Windows from PostgreSQL 7.4.1, but I
> have a big problem.
>
> In 7.4.1 I have a large view with nested views. It lasts 1 minute and 20
> seconds to finish. In 8.0.1 for Windows it lasts I don't know.
Dear,
I have the following problem :
On an win32 box (win2003 server) we selected as encoding SQL_ASII, we store
data into the tables with accents ... If we look at it with pgadminIII it
looks nice. From the cmd-prompt and via ODBC on the same box, the accents
are strange characters. Is we conne
Scott Marlowe wrote:
Why not change the keys that currently connect them to something
different (i.e. random noise) and make a NEW table that could join them
with those random keys that is restriced access wise to only the chosen
few.
This might work rather nicely. It would enable us to restrict d
On Tue, Feb 22, 2005 at 20:15:26 +0100,
denis moeller <[EMAIL PROTECTED]> wrote:
> Well ... I don't have an old version running to make a dump - that would
> be easy.
> I just got the files in a backup-directory ...
> Any ideas?
> Thanks!
You can try reinstalling the old version and doing the d
On Tue, 2005-02-22 at 14:30, Heather Johnson wrote:
> One of the tables contains personally identifiable information (PII)
> (e.g., email, first and last name, etc.). The other contains "click
> stream" data (information about where on our website users have gone).
> In order to be sensitive to
One of the tables contains personally identifiable information (PII)
(e.g., email, first and last name, etc.). The other contains "click
stream" data (information about where on our website users have gone).
In order to be sensitive to users privacy, we don't want to ever (even
accidentally) ru
On Tue, Feb 22, 2005 at 02:51:09PM -0500, Heather Johnson wrote:
> Is there a way to revoke permission to join two or more tables, even for
> users who have all other permissions (e.g., select, insert, update,
> delete) on those tables?
For what purpose? If this were possible, then users could
Heather Johnson wrote:
Is there a way to revoke permission to join two or more tables, even for
users who have all other permissions (e.g., select, insert, update,
delete) on those tables?
I don't think you can, and I'm not sure it makes sense to. If I can
select from tables ta,tb then I can mat
Hi:
I want migrate to PostgreSQL 8.0.1 for Windows from PostgreSQL 7.4.1, but I
have a big problem.
In 7.4.1 I have a large view with nested views. It lasts 1 minute and 20
seconds to finish. In 8.0.1 for Windows it lasts I don't know. One
hour, two hour, one day... I always cancel the view b
Is there a way to revoke permission to join two or more tables, even for
users who have all other permissions (e.g., select, insert, update,
delete) on those tables?
Heather Johnson
Senior Database Programmer
New York Post
---(end of broadcast)---
I still cant see RedHat 9 Source RPMS for the Postgres 8.0.1 in FTP
mirror sites , any ideas when it will up on FTP mirror site ?
Sander Steffann wrote:
Hi again,
I've checked the mirrors and although there is a directory for x86
64 bit rpms, it's empty. Are there plans to build these any time
Well ... I don't have an old version running to make a dump - that would
be easy.
I just got the files in a backup-directory ...
Any ideas?
Thanks!
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.po
On Tue, Feb 22, 2005 at 18:36:22 +0100,
denis moeller <[EMAIL PROTECTED]> wrote:
>
> situation: old server backup. Backup of Postgresql data files. Postgres
> 7.3.x was running.
You can't take file system level backups under a running postmaster and expect
to use those to recover a database. Y
On Tue, 2005-02-22 at 11:36, denis moeller wrote:
> Hi,
>
>
> situation: old server backup. Backup of Postgresql data files. Postgres
> 7.3.x was running.
> New server has version 7.4.5 - how do I get the old data in my new database?
> Copying didn't work - complains about different versions.
R
Hi,
You try to dump with -d (dump data as INSERT, rather than COPY,
commands) option of pg_dump and import this in 7.4?
Atenciosamente,
Gustavo Franklin Nóbrega
Infraestrutura e Banco de Dados
Planae Tecnologia da Informação
(+55) 14 2106-3514
http://www.planae.com.br
- Original Message --
Hi,
situation: old server backup. Backup of Postgresql data files. Postgres
7.3.x was running.
New server has version 7.4.5 - how do I get the old data in my new database?
Copying didn't work - complains about different versions.
TIA!
---(end of broadcast)-
* Tom Lane <[EMAIL PROTECTED]> [0218 15:18]:
> Perhaps easier would be to set "PGSSLMODE=allow" (or even "disable") in
> the client environment. This will work for libpq-based clients; there
> may be something equivalent if you are using other software.
Thanks Tom, I'll give that a go.
> Also:
On Tue, 2005-02-22 at 08:07, Zouari Fourat wrote:
> Hello,
> i forgot the postgres user password, how to resolve this problem.
> once i have my postgres user working, how to list all users on the server ?
> thanks a bunch
First off, PostgreSQL stores passwords as md5 hashes (well, the last few
ver
Hello;
I've just installed the pgsql 8 on a fedora core 3 server, and when
attempting to connect with
psql -Ueserve -W
i got it workin (eserve is a username i've created)
and with pgadmn3 or phppgadmin i didnt get it working
---(end of broadcast)-
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> The host entry is the one that applies. But the host entry will allow either
> ssl or nonssl, so it doesn't do what you want without cooperation from the
> connecting client. You can use hostnossl to match without allowing ssl.
> You will also want to u
On Tue, Feb 22, 2005 at 15:07:45 +0100,
Zouari Fourat <[EMAIL PROTECTED]> wrote:
> Hello,
> i forgot the postgres user password, how to resolve this problem.
> once i have my postgres user working, how to list all users on the server ?
> thanks a bunch
Edit pg_hba.conf to use trust or ident auth
On Tue, Feb 22, 2005 at 11:56:41 +,
Dick Davies <[EMAIL PROTECTED]> wrote:
>
> Just needed clarification on how pg_hba.conf operates.
> Does a specific host take precedence over a more general network setting?
No. The first line that matches the triple connection type, database name
and use
* Donald Fraser <[EMAIL PROTECTED]> [0257 13:57]:
> If postgres has ssl enabled then it will by default negotiate to use ssl,
> regardless of the host or hostssl settings in pg_hba. Your client software
> needs to refuse ssl connections then it will fall back to a non-ssl
> connection so long as th
On Tue, Feb 22, 2005 at 12:09:28 +0100,
KÖPFERL Robert <[EMAIL PROTECTED]> wrote:
> Hi,
> what is to do if somehow, someif the data directory went corrupt?
> (kill -9, Plug out)
> Are there any tools or other ways to rescue that or is the only way
> rm *; initdb
> and restore a backup?
You just
Hello,
i forgot the postgres user password, how to resolve this problem.
once i have my postgres user working, how to list all users on the server ?
thanks a bunch
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index
If postgres has ssl enabled then it will by default negotiate to use ssl,
regardless of the host or hostssl settings in pg_hba. Your client software
needs to refuse ssl connections then it will fall back to a non-ssl
connection so long as there exists a host setting in pg_hba. The hostssl
setting i
* K?PFERL Robert <[EMAIL PROTECTED]> [0228 12:28]:
> According to the excelent doc, the _first_ matching entry will be used.
If that were true, the below would work, surely?
> C:\> I have this:
> C:\>
> C:\> [EMAIL PROTECTED]:postgresql80-server$ cat /opt/pgsql/data/pg_hba.conf
> C:\> # TYPE
According to the excelent doc, the _first_ matching entry will be used.
C:\> -Original Message-
C:\> From: Dick Davies [mailto:[EMAIL PROTECTED]
C:\> Sent: Dienstag, 22. Februar 2005 12:57
C:\> To: PostgreSQL Admin
C:\> Subject: [ADMIN] pg_hba.conf
C:\>
C:\>
C:\>
C:\> Just needed clarif
Just needed clarification on how pg_hba.conf operates.
Does a specific host take precedence over a more general network setting?
The local socket is only accessible to a certain group, but I don't want
the overhead of SSL for loopback connections. If I connect to the server
from the local machin
Hi,
what is to do if somehow, someif the data directory went corrupt?
(kill -9, Plug out)
Are there any tools or other ways to rescue that or is the only way
rm *; initdb
and restore a backup?
---(end of broadcast)---
TIP 3: if posting/reading throug
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 22 Feb 2005, Sander Steffann wrote:
I should have built them. Sorry it took so long. Everything was delayed
because of some problems at work adn at home. I will try to catch up with
the RPM building tomorrow!
I couldn't sleep anyway, and I
44 matches
Mail list logo
