we have made 4 databases in postgresql, now we want to know how can be
recognize these database files in /var/lib/pgsql/data/base.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
we have made 4 databases in postgresql, now we want to know how can be
recognize these database files in /var/lib/pgsql/data/base.
Execute this query:
select datname, datid from pg_stat_database;
Bye, Chris.
---(end of broadcast)---
TIP 6:
after login into pgsql through a user, when i try to connect some other
database it always says that permission denied.
what do i do?
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
after login into pgsql through a user, when i try to connect some other
database it always says that permission denied.
what do i do?
Read this about pg_hba.conf:
http://www.postgresql.org/docs/7.3/static/client-authentication.html
And this about DB users:
One good and very usefull script for that is oid2name .
You can find it in contrib/oid2name
Thierry Missimilly
Ashok Chauhan wrote:
we have made 4 databases in postgresql, now we want
to know how can be
recognize these database files in /var/lib/pgsql/data/base.
---(end
-
Warm Regards
Shÿam Peri
II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalore-575003
Ph : 91-824-2451001/5
Fax : 91-824-2451050
DISCLAIMER: This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended
Hi all..
i've got a problem with the memory that postgresql 7.3.2 used in RedHat 9.
When the memory usage reached 80% or more of the total memory in the
system..
the memory just keep stuck there..The thing did not reduce bt itself...
Then i decided to stop the postgresql service. But ...the
i've got a problem with the memory that postgresql 7.3.2 used in RedHat 9.
When the memory usage reached 80% or more of the total memory in the
system..
the memory just keep stuck there..The thing did not reduce bt itself...
Then i decided to stop the postgresql service. But ...the memory
Ben Kim [EMAIL PROTECTED] writes:
Thanks for the reply. I haven't looked at the source code yet, but
assuming I understood it correctly, if we can simply add double quotes
around tab-completed names, it alone would be very convenient.
On Thu, 16 Oct 2003, Tom Lane wrote:
Actually, maybe
Hi all.
I've a problem with a database restoring.
I've executed the dump command from a Linux 6.8 Red Hat version, Postgres
7.1: this file executes a corrected restore under itself.
If I transfer the backup file to another Linux machine, Red Hat 9, Postgres
7.3, I'v some problem during the
It sounds like you are using pg_pconnect. First, try using pg_connect and
see if it can handle the load. If it can't, write back and I'll tell you
how to configure apache / php / postgresql to handle the load you want
with pg_pconnect. pg_pconnect is dangerous, and pg_close will NOT close
Monica Robustelli [EMAIL PROTECTED] writes:
If I transfer the backup file to another Linux machine, Red Hat 9, Postgres
7.3, I'v some problem during the database restoring. The error is:
ERROR: copy: line 13, CopyReadAttribute: end of record marker corrupted
A likely bet is that you
I have two databases set up, one designated as a master (w/database
named masterdb) and one designated as a slave (w/ database named
slavedb). My problem is that the two are inexplicably not replicating.
First, I checked the replication.cfg files on each machine to verify
that the master and
Thanks.
Regards,
Ben
On Mon, 20 Oct 2003, Tom Lane wrote:
Ben Kim [EMAIL PROTECTED] writes:
Thanks for the reply. I haven't looked at the source code yet, but
assuming I understood it correctly, if we can simply add double quotes
around tab-completed names, it alone would be very
Thanks for the information.
Regards,
Ben
On Thu, 16 Oct 2003, Adam Witney wrote:
I think the tablefunc module in contrib will do crosstab queries
HTH
adam
Is there a plan to implement crosstab query feature? Are there ways
other than using some frontend tool, COPY or
Thanks for the reply. I haven't looked at the source code yet, but
assuming I understood it correctly, if we can simply add double quotes
around tab-completed names, it alone would be very convenient.
Regards,
Ben
On Thu, 16 Oct 2003, Tom Lane wrote:
Bruno Wolff III [EMAIL PROTECTED]
I am new to postgres and your mailing lists, please let me know if I
am posting in the wrong list.
I am working on creating my first database in Postgres. In the
script that will create all the tables for the firs time, I would
like to have a conditional statement to delete a table, if it
Hi all..
i've got a problem with the memory that postgresql 7.3.2 used in RedHat 9.
When the memory usage reached 80% or more of the total memory in the
system..
the memory just keep stuck there..The thing did not reduce bt itself...
Then i decided to stop the postgresql service. But ...the
On Sat, 18 Oct 2003, Sam Carleton wrote:
I am working on creating my first database in Postgres. In the
script that will create all the tables for the firs time, I would
like to have a conditional statement to delete a table, if it
already exists.
As far as I know, there is no way to do
On Mon, 20 Oct 2003, dotaku wrote:
Hi all..
i've got a problem with the memory that postgresql 7.3.2 used in RedHat 9.
When the memory usage reached 80% or more of the total memory in the
system..
the memory just keep stuck there..The thing did not reduce bt itself...
Then i decided to
If it's a bash script you could use:
#
SomeTable=Table you're about to create
TableTest=$(psql -d your new db -U its owner -ntc select relname from
pg_class where relname='$SomeTable')
[[ -n $TableTest ]] psql -d your new db -U its owner -nc drop
table $SomeTable
#
It's not quite in
At 09:40 AM 10/20/2003, Tom Lane wrote:
Monica Robustelli [EMAIL PROTECTED] writes:
If I transfer the backup file to another Linux machine, Red Hat 9,
Postgres
7.3, I'v some problem during the database restoring. The error is:
ERROR: copy: line 13, CopyReadAttribute: end of record marker
Use pg_dump -c
this will drop the db objects before creating them
Priya
From: Sam Carleton <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [ADMIN] sql scripts
Date: Sat, 18 Oct 2003 22:37:00 -0400
I am new to postgres and your mailing lists, please let me know if I
am posting in the
Is there any encrypt function in postgres? like encrypt('string')...
Thanks,
pn See when your friends are online with MSN Messenger 6.0. Download it now FREE!
On Mon, 2003-10-20 at 23:46, Priya G wrote:
Is there any encrypt function in postgres? like encrypt('string')...
Yes, there is. See contrib/crypt - there's a library with crypto stuff, C source code
and SQL bindings (i.e. external functions).
Cheers,
Thanks,
pn
On Mon, 20 Oct 2003, Priya G wrote:
Is there any encrypt function in postgres? like encrypt('string')...
Yes, but they're not built in, you need to look in the
source/contrib/pgcrypto directory to find them.
---(end of broadcast)---
TIP 4:
On Fri, 2003-10-17 at 05:18, Greg Reeves wrote:
Hi There,
I am new to postgresql and we are thinking of migrating from MS-SQL to
postgresql, but I am having trouble getting postgresql to keep up with the
load.
Hmm, the website seems to be loading pretty slow as it is.
I am using it to
Robert W. Kernell wrote:
Hi. I want to start helping with the nuts and bolts of postgresql.
That is, I want to begin helping to update it with programming, etc.
What group should I read (which postgresql one, that is...). Also, is
this going to be possible on a 486? That is all I am operating
On Saturday 18 October 2003 04:39 am, Eric M. Wulff wrote:
Hi, I am relatively new to Linux and just installed postgres via rpms.
I think. However, I can't for the life of me figure out how to start up
postmaster or psql.
Well, Eric, you got some bad advice already. I hope you didn't do most
Hi List,
I got a P4 1.7Ghz , 512MB RAM , HD 7200 RPM, on RED HAT 9 running PostgreSQL
7.3.2-3 Database.
I have a Delphi aplication that updates the Oracle database using .dbf
file's information ( converting the data from the old clipper aplication ) and
it takes about 3min and 45
On Mon, 20 Oct 2003 12:13:26 -0200
Rhaoni Chiu Pereira [EMAIL PROTECTED] wrote:
Hi List,
I got a P4 1.7Ghz , 512MB RAM , HD 7200 RPM, on RED HAT 9 running
PostgreSQL
7.3.2-3 Database.
[clip]
Please send schema queries or we will not be able to help you. Also,
if you could provide
31 matches
Mail list logo