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
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 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
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 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
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!
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
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
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
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
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, 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
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 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
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
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 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
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
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
"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
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
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
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
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
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
> 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
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
-
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
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
> 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
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
> 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
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
33 matches
Mail list logo
