We are using this bad piece of the software that does not close
connections to the postgres server. Is there some setting for closing
dead connections? And not TCP/IP keep alive does not work.
---(end of broadcast)---
TIP 6: explain analyze is yo
Did you even look for the information on postgresql.org?
http://www.postgresql.org/docs/8.2/interactive/sql-createuser.html
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
I hate to sound like a --- but did you read the README on starting the
server? You start the server by using the postmaster command:
/path/to/postmaster -D /path/to/data
look at the postgresql manual - it's all there.
J
---(end of broadcast)-
run this in the command line
locate postmaster.pid
or
find / -name "postmaster.pid" -print
that should locate any postmaster files and then remove whatever looks
like the postmaster.pif file
---(end of broadcast)---
TIP 2: Don't 'kill -9' the po
As anyone used pgmemcache? I would like to look more into a but I'm
having problems installing the sql. I'm on OS X 10.4 and the sql there
are lines causing errors:
(e.g. AS '$libdir/pgmemcache', 'memcache_server_add' LANGUAGE 'C' STRICT;)
thanks for any input and also will version 1.2 come
I had my database set to SQL_ASCII and switched to UTF8, but now I
notice that I must add a slash for periods/dots ( \. vs . ) to insert
into varchar. Is this normal?
Thanks,
J
---(end of broadcast)---
TIP 5: don't forget to increase your free spa
I have data in one table called articles and I would like to make a
function in which takes certain data from it and display the results.
Example:
CREATE TABLE articles (
article_id serial,
title varchar(200),
posted timestamp,
article_subject varchar(200),
article_body text,
allow_comments boole
Can I do something like this:
CREATE TABLE sample (id SERIAL, node INTEGER, parent INTEGER);
INSERT INTO sample(node,parent) VALUES(1,0);
INSERT INTO sample(node,parent) VALUES(2,0);
INSERT INTO sample(node,parent) VALUES(3,1);
INSERT INTO sample(node,parent) VALUES(4,3)
CREATE OR REPLACE FUNCTIO
Sorry for the attachment, but copying and pasting this data does not work.
I don't have any idea how to insert the type of data into PostgreSQL.
Basically, it's encrypted data in which I would like that keep raw format.
Thanks for any help,
J
sample_data.pdf
Description: Adobe PDF document
--
::1 is a function of the PHP $_SERVER[''] internal function, not a
PostgreSQL problem. It will display ::1 on any database, you program a
PHP custom function to call the whole IP address. The real question is
that a problem in a production environment? Of note, outside IP
addresses will display fi
I have a client who wants to use Delphi as a front end to a Database, I
would like to use PostgreSQL over MSSQL and have been looking at the
psqlodbc project. Will psqlodbc connect with Delphi 6? Basically, I'm
wondering if anyone has experience with it? Any help will be appreciated.
Thanks,
J
I have some clients that are looking to upgrade to MSSQL Server because
they use ACT!. I'm developing a web application for them that uses
PostgreSQL. Does anyone know if ACT! can use PostgreSQL? or if I can
hack it?
Suggestion welcome and Thanks,
J
---(end of broadcas
Hello,
Has anyone tried using PostgreSQL 8.0.x on Windows XPe?
I tried installing and it failed on the "Initialise database cluster" step
saying that it could not open the "Secondary Logon service". The message
indicated that the specified service does not exist as an installed service.
The prob
You're php install isn't finding the postgresql libs it needs. When you
do the ./configure --with-pgsql check the output of the config run, and
you'll see something like:
checking for PostgreSQL support... no
You may want to set include flags when compiling
CPPFLAGS=-I/usr/local/pgsql/inc
Hello list,
I just want to upgrade from 7.4.2 to 7.4.7 on Fedora Core 1. Is it
safe to simply
download the 7.4.7 rpms and then install/upgrade them with:
rpm -U postgresql-7.4.7.rpm
Kind Regards,
Devin
---(end of broadcast)---
TIP 1: subscribe and
> pg_restore -U admin -C -d staging /home/postgres/staging-dump
pg_restore: [archiver (db)] could not execute query: ERROR: database
"staging" already exists
-C tells it to create (and then connect to) the target DB, rather than
connect to an existing DB and restore into that.
on the
backup DB box.
btw, these are both running version 7.4.2.
Here's the command I am issuing on the primary DB server:
pg_dump -U admin staging -Fc -b -f /home/postgres/staging-dump
And, it seems to work - creating a 20MB archive that has some readable text in
it near the top, and a bun
Hello list,
I know this is a complicated issue, but I'll throw it out there...
Our DB box has 3GB of ram - which is supposed to be used by
postgres. Whenever I use top, it only shows about 800MB being
used with 2.2GB free. What can I do to tell postgres to use more
of that memory - maybe 2GB ?
I
Hello list,
1. Where should the postgresql.conf file be to be recognized by the
service on startup? currently, it is inside my $PGDATA directory but
all of its contents are commented out.
2. I can't find any log files for postgres. Inside my /var/log/
directory, there is an empty
file call
I am trying to install postgres 7.3.4 on my B180L HPUX workstation.
I am having some problems getting the configure script to complete
properly.
It actually finished once or twice(not how I would like the configs) but
then the make failed.
The config errors are in the attached text document, and t
bonjour,
juste un petit mail pour vous informer qu'il y a du 'nouveau' sur le web:
LE RETOUR DU GRATUIT !
http://www.chouab.com/
vous propose:
- Une mail-liste gratuite,
- Un monitoring serveur gratuit,
- une regie publicitaire gratuite,
- un memo-mail gratuit ...
Le site vous propose aussi u
[EMAIL PROTECTED] writes:
>Hello:
>
>I am trying to get rserv working, so that I can do replication between a
>master and a slave DB. I seem to be getting an error when I attempt
>replication:
>
> ./Replicate testmaster testslave
>
> > ERROR
Try this.
./Replicate --snapshot=/tmp/_
Hi,
I am trying to migrate from 7.0.3 to 7.1.2. I just got the
rpms from rawhide of redhat.
While loading the 7.0.3 dump_file to 7.1.2, I got these errors...
ERROR: stat failed on file '/usr/lib/pgsql/plpgsql.so': No such file or
directory
ERROR: PL handler function plpgsql_call_handler() doe
[EMAIL PROTECTED] writes:
>Dear Mike,
>
>I am trying to create the user but it was giving folllowing errors
>
>[postgres@ns data]$ su siddharta
>su: user siddharta does not exist
>
>This is how I created the user
>
>[postgres@ns data]$ createuser siddharta
>Enter
[EMAIL PROTECTED] writes:
>Dear Mike,
>
>I am trying to create the user but it was giving folllowing errors
>
>[postgres@ns data]$ su siddharta
>su: user siddharta does not exist
>
>This is how I created the user
>
>[postgres@ns data]$ createuser siddharta
>Enter
it's like
SELECT *
FROM :table
WHERE :condition
LIMIT :limit
OFFSET :offset
Sherwin
[EMAIL PROTECTED] writes:
>I read on a website dedicated to MySQL, that the limit clause allows
>someone to restrict the result of a query to a certain domain.
>Exemple : "selec
Thank you anyway.
I have solve my problem in 6.5.3 (too old server) by
creating pg_options
verbose=2
query=1
syslog=0
hostlookup
showportnumber
I
I set syslog=0 'coz I can't make it log to /var/log/postgresql.
I removed "-d 2" in /etc/rc.d/init.d/postgresql:
su -l postgre
[EMAIL PROTECTED] writes:
>William L James writes:
>
>> script - su -l postgresql -c "/usr/bin/pg_ctl -D $PGDATA -p
>> /usr/bin/postmaster start >>/var/log/postgresql 2>&1"), but
>> when the weekly logrotate.d function kicks in, Postgres logging
>> stops.
>
>The logging probably continues to go to
Hello All!
Somebody told me that DB2 has replication.
Does PostgreSQL has it also?
Anyway, does anybody here know the difference between
PostgreSQL and DB2?
Thanks.
Sherwin
---(end of broadcast)---
TIP 2: you can get off all lists at once with
a followup to my reply...
you can try 'copy'.
database=# \h copy
Command: COPY
Description: Copies data between files and tables
Syntax:
COPY [ BINARY ] table [ WITH OIDS ]
FROM { 'filename' | stdin }
[ [USING] DELIMITERS 'delimiter' ]
[ WITH NULL AS 'null string' ]
COPY [ BINARY
[EMAIL PROTECTED] writes:
>Is there an SQL command to inherit an entire database.
>
>Sean.
AFAIK, there is none but you can use 'pg_dump'.
Sherwin
try
INSERT INTO table2
SELECT DISTINCT ON key key, name, field1, field2
FROM table1;
sherwin
[EMAIL PROTECTED] writes:
>Hello,
>
>I'm sure I'll be flagged as a moron for asking this question, so be it.
>
>I have some tables of info with no primary keys. As a result the field I
>want to key
[EMAIL PROTECTED] writes:
>On Fri, 20 Oct 2000, pgsql-admin wrote:
>
>> The postgres server was started with the command:
>> /usr/bin/postmaster -i -S -D/var/lib/pgsql
>
>Have you tried changing the values of -B to see if increasing the
>number of buffers helps?
ly need some additional information:
>
>What settings did you start the server with, what queries are you running
>that are slow (with schema, index information), what does explain show for
>the queries?
>
>Stephan Szabo
>[EMAIL PROTECTED]
>
>On Thu, 19 Oct 2000, pgsql-adm
I'm using
PostgreSQL 6.5.3 on i686-pc-linux-gnu.
I have a backup of our database (sql dump and large object)
backup.tar.bz2 with the size of 10121985.
We have users accessing our database from http and
odbc (ms excel).
Can someone pls tell how to solve this problem?
Thank you very much.
Sherwi
t(text);
>create function image_import(text) returns int4 as '
>declare
> tci check_images%rowtype;
> ttext alias for $1;
> tint int4;
>begin
> update check_images set image = 0 from check_images t1 where t1.number =
>0 and check_images.num
you can also try this:
#!/bin/sh
# Backing up each database...
pg_dumpall -o | bzip2 > /var/lib/pgsql/backups/pgdumpall_`date
"+%Y%m%d"`.bz2
# Removing backups of last seven days...
find /var/lib/pgsql/backups -mtime +7 -exec rm -f {} \;
Sherwin
[EMAIL PROTECTED] writes:
>>I use PostgreSQL ve
Has anyone tried to backup all Pg databases with large objects?
Pls share. Thanks.
Sherwin
configset pgsql-admin delivery_rules << ENDAAK
/(\.fi|\.no|\.dk|\.se)$/
sort
maxaddrs=50
minseperate=5
hosts=(towerguard.unix.edu.sollentuna.se=(esmtp,pipelining,onex))
backup=(hub.org=(esmtp,pipelining,onex))
/(\.nz)$/
sort
maxaddrs=50
minseperate=5
hosts=(postgresql.godzone.net.nz=
For Digital UNIX 4.0D, shared libraries are created by:
$ ld -shared -expect_unresolved "*" -o foo.so [objects]
This presents a problem for mkMakefile.tcldefs.sh.in. In tclConfig.sh:
TCL_SHLIB_LD='ld -shared -expect_unresolved "*"'
>From mkMakefile.tcldefs.sh.in
cat @TCL_
A few questions about src/interfaces/libpq++/Makefile.in:
1. How about changing:
ifeq ($(CXX), g++)
CXXFLAGS= -Wno-error
else
CXXFLAGS=
endif
to
ifeq ($(CXX), g++)
CXX
42 matches
Mail list logo
