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?
http://www.postgresql.org/docs/fa
> 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:
http://www.postgresql.org/docs/7
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
recipi
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 memo
> 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 m
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, m
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 d
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
i
"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 t
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 s
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 ver
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, CO
Hello!
I’m having same problems with managing databases. I
want to create a database for one user (that this user had access only to this
database) But when I create the user, it can
create new records in another's tables, not having privileges. In what there
can be a problem?
Thanks,
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]> wri
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
already
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 memo
On Mon, Oct 20, 2003 at 11:43:00AM -0500, Kris Kiger wrote:
> 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.
Please see the archives
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 dec
If it's a bash script you could use:
#
SomeTable=
TableTest=$(psql -d -U -ntc "select relname from
pg_class where relname='$SomeTable'")
[[ -n "$TableTest" ]] && psql -d -U -nc "drop
table $SomeTable"
#
It's not quite "in postgres's sql", but it could get the job done
>-Origina
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 r
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 th
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 serv
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 operati
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 mo
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 seconds
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
33 matches
Mail list logo
