x.
pg_cursors is only accessible within the same transaction and as a DBA we want
to see that cursor of any active transactions.
Thanks,
-Dan
From: Greg Williamson gwilliamso...@yahoo.com
To:
Cc: pgsql-admin@postgresql.org pgsql-admin@postgresql.org
Sent
.
Additionally, how do I see the actual sql statement that shows as unnamed
portal x.
Thanks so much for any advice you all may have.
-Dan
I think the functions you are looking for are:
pg_last_xlog_receive_location();
pg_last_xlog_replay_location();
-Dan
On Fri, Apr 15, 2011 at 6:09 AM, Ray Stell ste...@cns.vt.edu wrote:
On Fri, Apr 15, 2011 at 08:52:24AM +0100, Simon Riggs wrote:
On Fri, Apr 15, 2011 at 2:25 AM, Ray Stell
access for ourselves so they can only run certain
types of queries on their own account.
I know this is possible with MS SQL Server tools, but we're bound to open
source solutions. Any information would be useful.
Thank you,
Dan
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org
look?
Thank you.
Dan
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
to establish some screen
sharing and skype sessions so that people on the net can participate.
--Dan
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
a certain computer
can access the database.
Does anyone know why I can't connect to the database from another computer
when specifying the IP address in 'listen_addresses' and how to fix my
problem?
Thanks a lot for the help.
Dan
Bill Willits wrote:
Hello:
We are in the process of upgrading posgres from v7.3.9 to v8.2.4 In our
current environment (v7.3), we run a reindex operation on all tables to
recover space and improve performance (we have several tables with high
insert/update load - no deletes). Is it likely
Andrew Sullivan wrote:
On Wed, Jun 06, 2007 at 04:04:44PM -0600, Dan Harris wrote:
of these operations or a full dump/reload. I do run VACUUM regularly, it's
just that sometimes we need to go back and update a huge percentage of rows
in a single batch due to changing customer requirements
very clean.
Can anyone recommend a good process for learning why exactly that transaction is
not completing? Or, is there a postgresql.conf setting that can automatically
kill these errant locks?
-Dan
---(end of broadcast)---
TIP 4: Have you
Our usage pattern has recently left me with some very bloated database clusters.
I have, in the past, scheduled downtime to run VACUUM FULL and tried CLUSTER
as well, followed by a REINDEX on all tables. This does work, however the
exclusive lock has become a real thorn in my side. As our
I'm trying to write a function that can do a select on an integer value from a
table and subtract that value from current_timestamp.
Let's say I have a table called users and a field called tz_offset..
I want my function to do something like :
select current_timestamp - '( select tz_offset
Dan Harris wrote:
I'm trying to write a function that can do a select on an integer value
from a table and subtract that value from current_timestamp.
Let's say I have a table called users and a field called tz_offset..
I want my function to do something like :
select current_timestamp
Steve Crawford wrote:
Dan Harris wrote:
I'm trying to write a function that can do a select on an integer value
from a table and subtract that value from current_timestamp.
Let's say I have a table called users and a field called tz_offset..
I want my function to do something like :
select
Carin Westblom wrote:
How can I easily find specific tables and/or databases with a lot of
space that may be reclaimed w a vacuum full?
I picked up this tip on the list a while ago:
SELECT pg_namespace.nspname, pg_class.relname, pg_class.reltuples,
pg_class.relpages, rowwidths.avgwidth,
Dan Harris wrote:
Carin Westblom wrote:
How can I easily find specific tables and/or databases with a lot of
space that may be reclaimed w a vacuum full?
I picked up this tip on the list a while ago:
SELECT pg_namespace.nspname, pg_class.relname, pg_class.reltuples,
pg_class.relpages
!
What say the sages?
Thanks
-Dan
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Dan Harris wrote:
Hello all:
I'm in a bit of a bind here. Today is my maintenance window for
upgrading from 8.0.3 to 8.2.3. I did a pg_dumpall overnight ( resulting
in a 72GB file ) and then a pg_dump on one of my small databases this
morning to test pg_restore. When trying to reload, I'm
Hi,
Does anyone know how to get the libpq++.so library added to a current
build? One of the developers wants to know where to find this library.
Is there a way to download or get that? We just have libpq.so, which is
the C library.
Thanks,
~Dan
Hi,
We are running v814 with 8 GB of RAM and 3.5 GB allocated to shared memory.
It's never been a problem for us before. We ran into a situation
yesterday where we received the message above. At that time our total
available memory took a dive to 4GB and cached memory stayed around 4 GB.
Hi,
We had to kill postmaster, and it's been ugly. The last backup finished
successfully not last night, but the night before. This is 161 GB database.
How long should I expect this to take before it starts. Developers are
coming into my office every 5 minutes asking for updates.
3000 of 492247 pages, containing 74065 live rows and
0 dead rows; 3000 rows in sample, 12152758 estimated total rows
Total query runtime: 2433517 ms.
From: Tom Lane [EMAIL PROTECTED]
To: Mr. Dan [EMAIL PROTECTED]
CC: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] COPY FROM command v8.1.4 Date
Hi Tom,
Sorry - to all my groupies out there for the time delay :) -
It's a rather time consuming endeavor.
Ok the ctid numbers did all seem to match for the group of 25 rows that
disappear.
For example., ctiid (146649,1) to (146649,25) represented a group or block
of 25 rows that go
Hi Ray,
I've tried it on both WAFL and Reiser filesystems and gotten either 0,1,
or 2 blocks of 25 rows missing. I haven't tried it on ext3 or JFS. No, I
haven't seen any problems in the syslogs and I haven't seen any drops on the
network in regards to WAFL. Reiser is the local
This is pretty confusing. You mean that groups of 25 adjacent rows were
missing in the output?
Yes, isn't that interesting? It's always in a group of 25 rows. This is
always random. Say 800,000 to 800,025 out of 12 million represents one
random group of 25 rows.
What's the (24+1)
blocks.
In summary, we are very concerned and have no idea of what direction to go
with this.
~DjK
If you repeat the entire experiment, are the same records missing each time?
I'm wondering about flaky hardware as much as anything.
From: Mr. Dan [EMAIL PROTECTED]
To: pgsql-admin
No, there are different blocks of records missing every time.
If you repeat the entire experiment, are the same records missing each
time? I'm wondering about flaky hardware as much as anything.
---(end of broadcast)---
TIP 1: if
Yes - we are doing select count(*) fromÂ… the stats are worthless until you
vacuum and we aren't running vacuum. Plus those change too often to be
reliable, they just make a good guess
---(end of broadcast)---
TIP 9: In versions below 8.0, the
This behavior is on big tables.
6.5 GB - 12+ million records
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
We are having some serious problems with the PostgreSQL COPY FROM command
and we have no clue what to do with this at this point. I think we need to
ask for 'guru' help in diagnosing this problem. Here is exactly what we are
doing:
We have a table with 12028587 records in it.
We do a COPY TO
Hi,
We have SLES set up to use UTC-4 right now, EDT. When we do a restore, we
have to set the time 1 hour earlier than we really want the restore time to
be. This is because we have a theory that something isn't defined quite
right. We think postgres is using UTC-5 for some reason. We
Hi,
Every day I'm arguing with 3 or 4 people on this point.
My point is that I have to do a tarball, a tar command as part of online
backup with postgresql v814. I keep saying that the reason we do a tarbal
(online backup) and not individual dumps is that we want the PITR
capability. I've
Hi,
When the postgresql.pdf for version 8.1 says that
Each buffer is 8192 bytes, unless a different value of BLCKSZ was chosen
when building the server.
When it says buildeing the server, is it talking about the postgres server
or the the OS server that the postgres instance is going on?
Has anyone found a nagios check_ or snmp MIB to use in NAGIOS to alert you
when someone has a row level or table level lock?
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi,
Does any one know of a nagios check alert or snmp MIB alert to notify you
when say 100 locks build up. We start to notice people getting blocked with
large numbers of locks.
~DjK
---(end of broadcast)---
TIP 9: In versions below 8.0,
Hi,
When I run an online-backup script(v810) on SLES, the process immediately
goes into the 'D' STATE.
The backup finishes in a couple of hours. The backup is good and I can
restore. Why does it do that though? If I run the backup script at 12:20
AM instead of 1:20 AM it finishes in 20
/19473856/19524666: file changed as we
read it
psql -d DBN -c SELECT pg_start_backup('somehting.backup');
tar -zcvf /something.tar.gz /PGDATA/dir/*
psql -d DBN -c SELECT pg_stop_backup();
Thanks,
~DjK
From: Marco Bizzarri [EMAIL PROTECTED]
To: Mr. Dan [EMAIL PROTECTED]
Subject: Re: [ADMIN
Another thing that conerns me is that the zipped file size keeps changing.
I'm backing up 10GB total. One night the backup file was 9 GB, one night it
was 874 MB and just now, 5 GB. I'm expecting a file around 1.5 GB (15% of
the 10GB) that's there.
---(end of
/bin/tar: /sqldata/Linux.pgsql/base/19473856/19524666: file changed as we
read it
Hi,
I'm seeing that a file changed during the /bin/tar process. Is that
anything to be concerned about?
This is the first time this happened in a month. Does that mean I'm still
backed up in regards to that
Hi,
I do an online backup with v814 and v810. I've noticed that there is a file
showing up in the PGDATA
directory/pg_xlog/0125100C2.0021CDDE.backup owned by
postgres 284 bytes in size that shows up in v810. That file isn't showing
up in v814. Is that by design?
~DjK
if that was by
design or I have a problem.
~DjK
From: Andy Shellam [EMAIL PROTECTED]
Reply-To: Andy Shellam [EMAIL PROTECTED]
To: Mr. Dan [EMAIL PROTECTED]
CC: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] online backup - v810 vs. v814
Date: Tue, 01 Aug 2006 17:05:45 +0100
That looks to be a file
Hi,
Using this query plan, an extra uid shows up in this example. We are in the
process of upgrading from v810 to v814. Does anyone see anything wrong with
this query plan that might be causing a problem?
Index Scan using pk_recent_projects on recent_projects (cost=0.00..5.81
rows=1
Hi help,
I just started my first instance of v814. It's giving these errors in the
logs with archiving. I saw one other post on this in the newsgroup, but my
problem is a littlie different. The WAL files all have a .ready suffix in
the the archive status folder in pg_xlog. None of
From: Tom Lane [EMAIL PROTECTED]
To: Mr. Dan [EMAIL PROTECTED]
CC: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] On-line backup Date: Mon, 17 Jul 2006 14:43:30 -0400
Mr. Dan [EMAIL PROTECTED] writes:
... What happens is that we have a 'hot' table (one with many many
transactions
Hi Tom,
Is this 2003 advice still relevant with postgresql 8.1.0? Our b-tree
indexes corrupt pretty often on our production server running 8.1.0 and we
are grasping for a solution. We perform online backups like this: In
addition, we archive the transactions and replay them for PITR.
##
Mr. Dan [EMAIL PROTECTED] writes:
Is this 2003 advice still relevant with postgresql 8.1.0? Our b-tree
indexes corrupt pretty often on our production server running 8.1.0 and
we
are grasping for a solution.
Corrupt how --- what's the exact symptoms?
The *first
Hi,
I have noticed that my full vacuum and re-index script is taking a day and a
half instead of 1/2 day.
Recently, the size of my database cluster has doubled to 130 GB. Would
anyone recommend increasing one or more of these to help get my full vacuums
to run a little faster?
Thanks,
Hi,
Pgadmin is amazing. You can log on with a user account that's been
authenticated through Linux PAM and then run a command like pg_dump or
createdb that you wouldn't have access to run on the linux command line as
long as postgres approves that access. Is there a way to bring that power
Hi,
Is there a way to hide or encrypt the postgres password when the postgres
user is required to be the user in a shell script? This way we could have
a function called in a program, and the users could do something with out
actually seeing the postgres user password.
We have tried
postgresql 8.1.0
Hi,
I have checkpoint_segments set to 18, yet I have 38 segmnet files in
pg_xlog. Is there a reason for that?
Thanks in advance,
~DjK
# WRITE AHEAD LOG
#---
# - Settings -
#fsync = on
I have a large database (20 Gb) on PostgreSQL 8.1.0 where I need to make a
copy of the structure and also copy the data from a few of the tables
(approximately 40 out of 140, resulting database is approximately 10 Mb)
which have dependencies on each other. The problem I am having is finding
Thanks Milen!
I use -P is bash shell scirpts. It used with with pgbench.
see pgbench --help.
~DjK
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
account such that attempts to connect
to it require authentication?
-Dan
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
to a lot. Perhaps we're running out of memory for some
sorting? We've dialled the logging down a little so we're not logging
pid's and statements to see what query that backend is doing.
Thanks again.
Dan
--
Confidential: This email is intended only for the person or entity to
which
considerably. So far, the
blocking problem seems to have gone.
Now to find some Postgres DBAs in Sydney to do some review / tuning of
our memory settings. :-)
Dan
--
Confidential: This email is intended only for the person or entity to
which it is addressed. The information contained in this email
almost continuously to it?
2. Why does that file not really exist in the file system according to
ls?
3. Where should I look to determine why Postgres is writing so much to
that disk?
Dan
--
Daniel Austin (+61 2 9358 7983)
Internet Technology Manager
--
Confidential: This email is intended only
Hi,
I found this old post - see the bottom of the message. I'm having a
similiar issue. After a PITR everything looks good. I do see the following
in the logs: Can that be safely ignored?
cp cannot stat `/sprj/sqldumps_Linux.pgsql_carp5442/0002.history': No
such file or directory
Hi,
I didn't build (./configure --with-perl) the makefile with perl and a
developer wants it now.
Is there a way to add perl with out a complete re-instsall like with the
create lang command?
Has anyone read anything about about the perl PL ? Someone in our group
said he read its really
Hi,
I'm running postgres on a Linux server SuSE SLES. When I run postgresql
8.0.3, I get /tmp/.s.PGSQLl.5432 socket open with group and owner
permissions. The group permissions are the default group of the postgres
account and the owner is postgres. If I want to start postgres with a
Hi,
I've been using postgresql v810 for a couple of weeks. I notice when I
start it up I get 'invalid lenth of startup packet' On a database that I
just initialized I get ' incomplete startup packet' after I first started
it. This never happened that I can see in 8.0.3.
Does any one
I want to create a postgresql user with restricted permissions--all it
should be able to do is select on a few views that I specify.
So I did the following, as the database owner:
create user viewer password '';
grant select on myview to viewer;
Then, when I start psql as the viewer user,
Thanks to both you and Jim--this was the missing piece that made things work.
On 11/29/05, Tom Lane [EMAIL PROTECTED] wrote:
Dan Tenenbaum [EMAIL PROTECTED] writes: ERROR: permission denied for schema myschema What do I need to do to get the correct permissions?GRANT USAGE ON SCHEMA myschema
Hi,
I have enough resources on my 3 postgresql servers to run more than one
instance of postgres. Is there a way to keep my production db up and
running in 8.0.3 while I also run 8.1.0 on the same server? Then, I could
copy the data and support two databases until things looked good. Then,
. The restore utility just stops when reaching a
certain point in the dump file.
Please help us, we cant afford loosing our
database with several years of work.
Thanks in advance.
/Dan
Here is some info on the dump file:
; Archive created at Wed Aug 17 21:09:56 2005
; dbname: a_db
; TOC
Hi all,
How do I figure out what's different in version 8.0.3 and how do I
upgrade on linux from v8.0.1 to v8.0.3?
Thanks,
~DjK
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I installed version 8.0.1 in feb/2005. There's no difference in the
changelog between that version and 8.0.3.
-Original Message-
From: tom [mailto:[EMAIL PROTECTED]
Sent: Friday, May 13, 2005 2:26 PM
To: Kavan, Dan (IMS)
Subject: Re: [ADMIN] version 8.0.3
Kavan, Dan (IMS) wrote
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Friday, May 06, 2005 3:31 PM
To: Kavan, Dan (IMS)
Subject: RE: [ADMIN] memory allocation ; postgresql-8.0
On Fri, 2005-05-06 at 14:12, Kavan, Dan (IMS) wrote:
ScottUnless you routinely actually handle data sets that are 1.9
.
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 12, 2005 11:21 AM
To: Kavan, Dan (IMS)
Cc: postgres
Subject: RE: [ADMIN] memory allocation ; postgresql-8.0
On Thu, 2005-05-12 at 10:10, Kavan, Dan (IMS) wrote:
Hi Scott,
Thanks again for all your
Scott,
If you had two applications that were each connecting to two different
databases, have you found that it's beneficial to have to different
instances of postgres running?
I have a few reasons why I think it would be better. One, it would be
beneficial to customize parameters for each
Hi Guys,
I''ve been running pgbench tests for a while. I have one server set up
to run pgbench tpc tests (7.x). A new server that I just configured
with SUSE and 8.0.0 just gets killed even though it has the same memory
8 GB and it's a x86-64 box. The other one is Solaris full 64-bit.
Yes, they are both running on the same hardware - NAS.
On Mon, 2005-01-24 at 10:48, Kavan, Dan (IMS) wrote:
Hi Guys,
I''ve been running pgbench tests for a while. I have one server set
up to run pgbench tpc tests (7.x). A new server that I just
configured with SUSE and 8.0.0 just
amount of
transactions, but actually the x86-64 system is performing better than
all, not worse.
~Dj
Yes, they are both running on the same hardware - NAS.
On Mon, 2005-01-24 at 10:48, Kavan, Dan (IMS) wrote:
Hi Guys,
I''ve been running pgbench tests for a while. I have one server set
for all your insight,
~DjK
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dick Davies
Sent: Sunday, January 16, 2005 4:11 AM
To: PostgreSQL Admin
Subject: Re: [ADMIN] PAM ldap
* Kavan, Dan (IMS) [EMAIL PROTECTED] [0149 18:49]:
Hi, I'm running postgresql
Hi, I'm running postgresql 8.0.rc5 on SUSE.
I have the pg_hba.conf file configured with
local all smith ident sameuser
hostall smith ident sameuser
The way authentication works with that is that configuration is that if
I'm logged in as smith with my company ldap server I can
into a similar duplicate
key error (or other import strangeness) in one of the other databases.
Can anyone shed more light on the implications of moving data from
en_US.UTF-8 locale to C locale?
regards,
Dan Libby
[1] http://www.postgresql.org/docs/7.4/static/charset.html
---(end
is running on Redhat 9 and was built with
./configure --prefix=/var/lib/pgsql --with-python --with-perl
I can probably come up with a clean test case using simplified data.
I'm still hoping someone has the magical solution though...
Dan Libby
---(end of broadcast
to clean this. I need my boss off my back. Please help me delete
these bad tuples.
Thanks again
Dan Hrabarchuk
This message was sent using IMP, the Internet Messaging Program.
---(end of broadcast
ownership and
permissions.
Thanks once again.
Dan
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing
extra trick here? I just want to delete the bad tuples. I can
restore the data from another source.
I really don't care if I need to take the database server down at 2am and use a
hex editor to clean this. I need my boss off my back. Please help me delete
these bad tuples.
Thanks again
Dan Hrabarchuk
disaster guide.
Thanks
Dan Hrabarchuk
-Forwarded Message-
From: Martijn van Oosterhout [EMAIL PROTECTED]
To: Dan Hrabarchuk [EMAIL PROTECTED]
Subject: Re: Question about pgfsck
Date: Thu, 07 Oct 2004 10:38:33 +0200
The problem is obviously with the structure of the tuples. So you need
complete (or at least
get working enough :)?
Thanks for the help
Dan Hrabarchuk
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
to have the database available while the dump is done.
Thanks is advance
Dan Hrabarchuk
---(end of broadcast)---
TIP 8: explain analyze is your friend
Quoting Michael Long [EMAIL PROTECTED]:
./psql template1
./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity
Is psql linked to the proper libraries?
--This is version 7.3.2
Below looks okay.
ldd /usr/bin/psql
libpq.so.3 = /usr/lib/libpq.so.3 (0x40015000)
On Sun, 2004-06-06 at 11:54, Tom Lane wrote:
Dan Thompson [EMAIL PROTECTED] writes:
I'm using version 7.4 on Red Hat Enterprise Linux 3.
I get this error:
createuser: relocation error: createuser: undefined symbol: get_progname
This is a fairly common symptom of a library version conflict
the bad posts. Long day. :-)
Thanks,
Dan
On Sun, 2004-06-06 at 11:54, Tom Lane wrote:
Dan Thompson [EMAIL PROTECTED] writes:
I'm using version 7.4 on Red Hat Enterprise Linux 3.
I get this error:
createuser: relocation error: createuser: undefined symbol: get_progname
This is a fairly common
to :
# su postgres
$ createuser -d sql-ledger
I get this error:
createuser: relocation error: createuser: undefined symbol: get_progname
I don't really know where to go from here.
Thanks,
Dan Thompson
I'm new to pgsql. I'm trying to install sql-ledger featured in Linux Journal
The install instructions saay to create the db admin account by:
bash$ createuser -D sql-ledger
This returns this error:
createuser: relocation error: createuser: undefined symbol: get_progname
Even if I only typ:
!
--
Dan Mahoney
[EMAIL PROTECTED]
AA6GF
How you behave towards cats here below determines your status in Heaven.
Robert Heinlein
There are two means of refuge from the miseries of
life - music and cats - Albert Schweitzer
---(end of broadcast
version, ...
Invoked via
pg_dump --clean --create --verbose --format=c --compress 9
OS is RedHat Linux, 2.4.18-3 kernel comoiled for SMP (I've got two CPUs).
Not sure the version of Postgres in use. I can't find a --version switch on
any of the executables.
Dan
number)
3.) createuser -i xx (sysid user of the unknown table owner)
4.) pg_dump / pg_dumpall
This solves the failed sanity check, table XX was not found
error when running
pg_dump / pg_dumpall
--- End of forwarded message ---
Feedback on this solution is appreciated.
--
Dan
On 7 Jan 2003 at 10:29, Tom Lane wrote:
Dan Langille [EMAIL PROTECTED] writes:
I am forwarding this on behalf of [EMAIL PROTECTED] who is at a client
site and cannot email.
I did a search and found a mail stating that its possibly related to
a deleted user having ownership of the table
On Mon, 23 Dec 2002, Bruce Momjian wrote:
Patch attached. Will appear in 7.3.2 and 7.4.
Looks good to me. Thank you.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Mon, 23 Dec 2002, Bruce Momjian wrote:
PostgreSQL is designed to _not_ require root access, so we just make
everything owned by the install user. I don't see how group checks can
help there. Also, there is no postgres group, at least by default, and
no special handling based on group,
'current_timestamp',
- remove key name from foreign keys
alter table element_pathnames
add foreign key FK_ELEMENT__REF_11730_ELEMENT (element_id)
references element (id) on update cascade on delete cascade;
Has anyone already done this?
--
Dan Langille : http://www.langille.org
some insight into this?
You should seek someone who provides PostgreSQL out-of-the-box. I
did a search on google.com yesterday for postgresql and web host and
found a few such places.
--
Dan Langille : http://www.langille.org/
---(end of broadcast
consistent backups even if the database is being used
concurrently.
--
Dan Langille : http://www.langille.org/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere
at my notes (http://www.freebsddiary.org/postgresql-
pgsql.php) I see that at one time I supplied a pathname :
CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
'/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C';
Please let us know.
--
Dan Langille : http://www.langille.org
standard
or ano= ther possibility that I am overlooking??
I would recommend #2.
--
Dan Langille : http://www.langille.org/
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
://www.postgresql.org/idocs/index.php?functions-sequence.html
Look for setval
--
Dan Langille : http://www.langille.org/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
be done someone else will
know.
--
Dan Langille : http://www.langille.org/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
1 - 100 of 146 matches
Mail list logo