Thanks, I saw that page earlier; what I'm looking for is kind of the
opposite - instead of comparing a single value to see if it matches any of
a list of patterns, I'm trying to take a list of values and see if any of
them match a given pattern.
Best,
Ryan
On Tue, Sep 5, 2017 at 8:01 AM Hellmuth
> I'm pretty sure it doesn't work syntactically. Don't recall the details
offhand.
Ok, thanks!
>
> I'm not sure why we've never got round to providing such a thing
> in core ... probably lack of consensus on what to name the reverse
> operator. You'd need to support regex cases as well, so there's
> more than one operator name to come up with.
>
Interesting! It seems like one "simple"
s well as =.
But is there any way to do:
select * from post
where any(tags) LIKE 'music%';
??
This doesn't work because ANY is only allowed on the right.
Thanks!
Ryan
).
With Appreciation,
Ryan
From: David G. Johnston <david.g.johns...@gmail.com>
Sent: Tuesday, November 8, 2016 3:19:02 PM
To: Ryan Mahoney
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Running on Docker, AWS with Data Stored on EBS
On Tue, Nov 8, 2016 at
is served from the same instance.
If my application was larger, all of this would be moot because I'd run a
dedicated PostgreSQL instance or just use RDS... but it isn't so I'd rather
save money :)
Thanks in advance for your help,
Ryan
> Because I specifically aliased the first task reference using AS task_1.
>
>
Ok, totally. I missed that when I first read your query, didn't read it
closely enough. Thanks.
> You're confused about the input vs. the output. The output columns
> of a view all have to have distinct names, just like you can't do
> "create table foo (f1 int, f1 int)". They can be reading the same
> values, though.
>
> regards, tom lane
>
Ok, that makes sense.
> You're confused about the input vs. the output. The output columns
> of a view all have to have distinct names, just like you can't do
> "create table foo (f1 int, f1 int)". They can be reading the same
> values, though.
>
> regards, tom lane
>
Ok, that makes sense.
Interesting, thanks! Do you know why the first one fails instead of doing
that renaming process, while your version succeeds?
On Monday, September 5, 2016, Adrian Klaver <adrian.kla...@aklaver.com>
wrote:
> On 09/05/2016 12:55 PM, Ryan Murphy wrote:
>
>> Hello, I have a qu
ason why views can't be allowed to have duplicate columns, just like the
result set above?
Thanks!
Ryan
Hi Devrim, I have already installed that:
"Package mysql_fdw_94-2.0.1-1.rhel6.x86_64 already installed and latest
version..."
We're looking into some other options though. Thanks though.
Ryan King
Internet Dissemination Group, Kansas City
Shared Infrastructure Services Branch
Nation
When attempting to create the required functions and extensions for the
MySQL FDW, I get the following errors:
dbname=# CREATE FUNCTION mysql_fdw_handler()
RETURNS fdw_handler
AS '$libdir/mysql_fdw'
LANGUAGE C STRICT;
ERROR: could not access file $libdir/mysql_fdw: No such file or directory
I tried that too - same result. I updated another box w/ the same issue to
9.4.4, and all is well there. Thanks for your reply.
On Tue, Jul 14, 2015 at 8:59 AM, Andy Colson a...@squeakycode.net wrote:
On 7/13/2015 7:08 PM, Ryan King - NOAA Affiliate wrote:
Apologies ahead of time
Apologies ahead of time for not knowing which group to send to, but I
wanted to see if anyone has encountered and resolved this type of error.
I'm setting up postgresql 9.2 streaming replication on RH and after copying
the master data directory over to the slave, the psql service refuses start
and
Have you considered using dblink() or foreign data wrappers to transfer the
data?
You can do a select from source, insert into target using one of these methods.
RC
On Mar 3, 2015, at 12:09 PM, Francisco Olarte fola...@peoplecall.com wrote:
Hi Adrian:
On Tue, Mar 3, 2015 at 4:44 PM,
I have archiving enabled for PITR but it has been causing problems. So I
changed the archive_command to ‘cd .’ to disable for now.
However, I’m currently looking for a script/process that will rotate the logs
every week or so, and also ensure archived wal files don’t pile up.
I
On Feb 27,
BY, it throws another exception. If I put
something there that doesn't belong, I get a different exception. So it already
knows how to do this! :P
--
Regards,
Ryan Delaney
ryan.dela...@gmail.com
https://github.com/rpdelaney
GPG ID: 4096R/311C 10F2 26E0 14E3 8BA4 3B06 B634 36F1 C9E7 771B
I having trouble with correct syntax to get this trigger function to compile.
I have tried every combination of removing the ‘;’ characters but the function
will not compile. Can someone tell me what I am doing wrong, I am stumped. I
will be adding addition when clauses the case statement
or
feature requests feel free to open an issue on github.
-Ryan Kelly
On Tue, May 6, 2014 at 4:22 PM, David G Johnston
david.g.johns...@gmail.com wrote:
So, I am trying to import a file into a table and want to assign a sequence
value to each record as it is imported.
I know that I can pre
routines. It looks like it would be relatively
straightforward to add two calls to ConnectionUp in ProcessResult and
ProcessResult to resolve this. But it would be a change in behavior.
-Ryan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
is that psql should
refuse to execute further commands on a line of input if any of them fails
due to a terminated connection.
Err, meant SendQuery and PSQLexec in my last mail. Not sure how I typed
ProcessResult twice...
-Ryan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
the new API:
http://www.postgresql.org/message-id/caeykp92z2w3vbs4uxwpwub7k4hgw-vepw_wnsui9r5t+cgp...@mail.gmail.com
-Ryan Kelly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
not exist
Which I would assume is because greatest is variadic and not simply a
function of two arguments.
I'm sure I'm just being dense and missing something obvious here...
-Ryan P. Kelly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
:
http://www.postgresql.org/docs/9.2/interactive/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT
-Ryan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
is a simple example where the location
'/some/path/to/file/file.csv' is owned by another user and it would be
very spiffy if I could run the COPY TO as that user. Any ideas?
You should use \copy if you're using psql. That will run on the client
side, as the user running psql.
-Ryan Kelly
--
Sent
: 2009-01-01 00:00:00
I've tried
date_trunc('year', table2.timestamp) = table1.year
You want date_part, not date_trunc.
-Ryan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
too have the same question.
Perhaps you could provide an example where an replacing the tuple would
be required in the presence of multiple transactions?
-Ryan Kelly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
to
make this work, or figuring out why it won't work. I've also been trying to
understand CREATE OPERATOR and CREATE OPERATOR CLASS, but those are over my
head for now. Could anyone point me in the right direction?
CREATE EXTENSION btree_gist;
-Ryan Kelly
--
Sent via pgsql-general mailing list
You can use \i /path/to/file.txt
-Ryan
On Tue, Feb 02/12/13, 2013 at 03:14:03PM +, Andrew Taylor wrote:
Hi,
As per title I need to import a load of csv files. So I wrote a bash script
to generate the statements I needed (attached). However, this is failing on
my ubuntu laptop
On Fri, Dec 12/07/12, 2012 at 05:33:45PM -0800, Jeff Janes wrote:
On Fri, Dec 7, 2012 at 1:58 PM, Ryan Kelly rpkell...@gmail.com wrote:
I have a very large query that also touches quite a bit of data. It
generates a large temporary file (actually, several, because the total
size is about
in memory instead by increasing
work_mem to a suitable value?
Thanks,
-Ryan Kelly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
it to use that index for clustering? If the latter I assume I need to add a
CLUSTER gen1011 ON xgen1011_si_sn line at the end along with an ANALYSE
line?
Thanks,
Bob
-Ryan Kelly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
--mssql
SELECT 'text for insertion';
SELECT vl FROM a_002;
WITH data AS (
INSERT INTO a_001
SELECT 'text for insertion'
RETURNING *
)
INSERT INTO a_002
SELECT * FROM data;
This is one possible solution.
-Ryan P. Kelly
--
Sent via pgsql-general mailing list (pgsql-general
% correct here. But that was the ballpark.
Thanks, Mike Jarmy
-Ryan Kelly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-sql.html#XFUNC-SQL-FUNCTIONS-RETURNING-SET
but it doesn't seem to be explicitly mentioned there.
And yes, I understand doing this is deprecated and my results would
probably be better achieved with LATERAL when 9.3 comes out.
-Ryan Kelly
--
Sent via pgsql-general mailing list (pgsql-general
and syntactically correct?
Reload it and test your application against it?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
Would that entail over-writing good data with possibly bad data?
Ryan
, or you can do it by timing
your query, so that the overhead of EXPLAIN ANALYZE does not come into
play.
Also, I assume you've read this:
http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html
That link will be helpful in understanding how partitioning could
benefit you.
-Ryan Kelly
--
Sent
put in place.
Thanking you in advance.
-Ryan Kelly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Sep 27, 2012 at 08:51:31AM +1000, Ondrej Ivanič wrote:
Hi,
On 26 September 2012 21:50, Ryan Kelly rpkell...@gmail.com wrote:
The size of our database is growing rather rapidly. We're concerned
about how well Postgres will scale for OLAP-style queries over terabytes
of data
On Thu, Sep 27, 2012 at 08:58:05AM +1200, Gavin Flower wrote:
On 26/09/12 23:50, Ryan Kelly wrote:
Hi:
The size of our database is growing rather rapidly. We're concerned
about how well Postgres will scale for OLAP-style queries over terabytes
of data. Googling around doesn't yield great
approach.
Thanks,
Stephen
Thanks,
-Ryan Kelly
signature.asc
Description: Digital signature
On Wed, Sep 26, 2012 at 03:18:16PM -0600, Scott Marlowe wrote:
On Wed, Sep 26, 2012 at 5:50 AM, Ryan Kelly rpkell...@gmail.com wrote:
Hi:
The size of our database is growing rather rapidly. We're concerned
about how well Postgres will scale for OLAP-style queries over terabytes
of data
), but given my experiences with Postgres and the
support provided by the community that is second to none, I'd very much
like to stay with PostgreSQL.
Thoughts?
-Ryan Kelly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
WITH SUPERUSER;
But this is an even worse idea.
If one role owns all the tables in that database, you can make your role
a member of that role:
GRANT owner_role TO your_role;
But are you really sure that your user needs permissions on everything?
-Ryan Kelly
--
Sent via pgsql-general mailing list
On Mon, Sep 17, 2012 at 10:58:30PM +0400, niXman wrote:
Hello,
Tell me please, whether there is an official C++ API for postgresql?
http://pqxx.org/development/libpqxx/
Thanks,
--
Regards,
niXman
-Ryan Kelly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
trying to
use?
Thanks,
Edson
-Ryan Kelly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Sep 17, 2012 at 11:52:13PM +0400, niXman wrote:
2012/9/17 Ryan Kelly:
http://pqxx.org/development/libpqxx/
Last question...
According to the link provided by you, it is said that libpqxx comes
with postgres. But in the archive with postgres sources I haven't find
libpqxx
?
I think this is explicitly disallowed by the spec.
And by Tom:
http://archives.postgresql.org/pgsql-general/2002-11/msg01411.php
Thanks in advance,
Daniel Serodio
-Ryan Kelly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
/ |
cheaptickets.comhttp://www.cheaptickets.com/ |
ratestogo.comhttp://www.ratestogo.com/ |
asiahotels.comhttp://www.asiahotels.com/
-Ryan Kelly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
) An empty specification specifies a collection whose cardinality
is zero.
-Ryan Kelly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-Ryan Kelly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Jul 27, 2012 at 09:49:06PM +0800, Craig Ringer wrote:
On 07/27/2012 09:28 PM, Ryan Kelly wrote:
I recently switched from OSX to Linux and \copy in psql no longer
accepts multi-line queries. For instance:
\copy (
select
*
from
pg_settings
) to '/tmp
On Fri, Jul 27, 2012 at 02:06:01PM +, Mark Morgan Lloyd wrote:
Craig Ringer wrote:
On 07/27/2012 09:28 PM, Ryan Kelly wrote:
I recently switched from OSX to Linux and \copy in psql no longer
accepts multi-line queries. For instance:
\copy (
select
*
from
a password.
Ryan Magruder
Is there a way to list the installed pl languages for a database and/or
server cluster?
thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
('english', description), 'B') from
profile_profile;
I would prefer not to store the precomputed tsvector in a separate
column if I can avoid it, although I'll do that if I can't get this to
work. Thanks for any help.
Ryan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
4/07/2011 1:45 AM, David Johnston wrote:
On Jul 3, 2011, at 11:13, Daron Ryan daron.r...@gmail.com
wrote:
I have strings
from
java and need to check which ones are not present in the
db. Can
I use
I have strings from
java and need to check which ones are not present in the db. Can
I use a select statement to do this by making it search my
strings as though they are a table?
Hello,
I need to search a table to find sets of rows that have a column
matching itself for the whole set and another column matching row for
row with a list I am going to supply. The result I should receive should
be value of the column that matches itself.
For example given the following
Thanks.
On 19/06/2011 8:09 AM, David Johnston wrote:
An alternative approach would be to select using a IN condition on the where
clause and group by column 1 and column 2. Then, using this as a sub-select
group by the resultant column 1 and a count on column two. The matching
identifiers
I am designing a database that will include at lot of duplicated data.
Does Postgres perform many optimisations to eliminate duplications of
fields or should I create additional tables to reference myself?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
Problem: Cannot start Postgres
Platform: Postgres 8.3, Windows Vista Home
Error Message: pg_ctl: invalid data in PID file C:/Program
Files/PostgreSQL/8.3/data/postmaster.pid
I run postgres on Windows Vista Home Edition. It normally runs as a
service but is not starting. I created a command
to figure out which field was matched using this approach,
however. Does anyone have any thoughts or ideas on this issue?
Any pokes in the right direction would be much appreciated.
Thanks,
Ryan Wallace
an explicit cast to 'text'? I thought varchar and text were
functionally identical data types.
Thank you so much for your help. PostgreSQL is a phenomenal product.
Ryan VanMiddlesworth
conversion issue, but I wanted to
check and make sure there's not some obvious database angle we're missing.
Does anyone have any experience with or insight into these sorts of string
compatibility issues?
Thanks!
Ryan
Ryan Wells
Application Developer, SOAPware, Inc.
www.SOAPware.com http
DEBUG: 0: StartTransactionCommand
LOCATION: start_xact_command, postgres.c:1981
DEBUG: 0: ProcessQuery
LOCATION: ProcessQuery, pquery.c:128
STATEMENT: INSERT INTO links VALUES ($1, $2, $3)
PANIC: XX000: right sibling is not next child in
pg_depend_reference_index
LOCATION:
Greetings,
I am running postgres 7.4.7 on debian sarge.
I need to run an SQL query and store the results in a file. The format
needs to be comma separated values (CSV), so I can import this later in
Excel.
Any ideas on how to accomplish this?
much appreciated,
Ryan
/PostgreSQL8.1/data
==
I have tried removing the postgres user and letting the installer
create it, installing to different directories, ect without any luck.
Any pointers would be appreciated.
Ryan
---(end of broadcast)---
TIP 2: Don't 'kill
for information on this issue!
Ryan Griggs
[EMAIL PROTECTED]
is that when creating databases, is
there a way to deny everyone except for the owner? Is this something
that would be done in the pg_hba.conf. Is there a way to specify
permissions on an entire database?
If I overlooked something in the manual, please send me the link. Thank you.
- Ryan
unsubscribe [EMAIL PROTECTED]
unsubscribe ryan richards
___
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now.
http://messenger.yahoo.com
---(end of broadcast)---
TIP 4: Don't 'kill
Hello,
Is there any way to reuse a column label in a select list like this:
SELECT 1 + 1 AS a, a + 1 AS b;
I vaguely remember being able to do something like this in oracle. Any
ideas? Thanks!
~RvR
---(end of broadcast)---
TIP 1: subscribe
with a trigger or another method - if there is a better way.
-Ryan Riehle
http://www.buildways.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bruno Wolff III
Sent: Saturday, May 01, 2004 9:40 PM
To: Ryan Riehle
Cc: [EMAIL PROTECTED]
Subject
|| |
+--++-++--+
Kind Regards,
-Ryan Riehle
http://www.buildways.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bruno Wolff III
Sent: Saturday, May 01, 2004 4:18 PM
To: Ryan Riehle
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] 1 foreign key to 2
since
I have not created a check onstraint that is above common complexity and and
have never tried a trigger.
Kind Regards,
-Ryan Riehle
http://www.buildways.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ryan Riehle
Sent: Saturday, May 01
: syntax error at or near $1 at character 30
CONTEXT: PL/pgSQL function list_devices line 6 at for over select rows
Any help would be greatly appreciated!
Thanks,
Ryan
CREATE FUNCTION list_devices(macaddr) RETURNS text AS '
DECLARE
macAddress ALIAS FOR $1;
rowval record;
devices text
Hi All!
Trying to upgrade to Apache 2.0.49 and getting compile errors related to
mod_auth_pgsql, any clue?:
make[1]: Entering directory `/usr/src/httpd-2.0.49'
/usr/src/httpd-2.0.49/srclib/apr/libtool --silent --mode=link gcc -pthread
-I/ =500 -D_BSD_SOURCE -D_SVID_SOURCE -D_GNU_SOURCE
Trying to upgrade to Apache 2.0.49 and getting compile errors related to
mod_auth_pgsql:
make[1]: Entering directory `/usr/src/httpd-2.0.49'
/usr/src/httpd-2.0.49/srclib/apr/libtool --silent --mode=link gcc -pthread
-I/
=500 -D_BSD_SOURCE -D_SVID_SOURCE -D_GNU_SOURCE
I'm using mod_auth_pgsq, version 2.0.1... it's for use with apache 2.0.x got
it from their site: http://www.giuseppetanzilli.it/mod%5Fauth%5Fpgsql2/
-Ryan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of joseph speigle
Sent: Thursday, April 01, 2004 10
Hello,
I have a single table that just went over 234GB in size with about 290M+
rows. I think that I'm starting to approach some limits since things
have gotten quite a bit slower over the last couple days. The table is
really simple and I'm mostly doing simple data mining queries like the
to find them in the archive. Also, please reply to me
directly, I am not subscribed.
Thank you, Ryan Mack
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
--
Ryan Mahoney [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't
Hi,
I've dropped an primary key index in order to re-create it. but i realized
that i can't recreate a primary key index. Will a unique index be an adequate
replacement? will the database integrity be at risk as a result?
Thanks!
--
Ho Siaw Ping, Ryan
---(end
in this direction as well as who else may be interested in this
project. Although I only occasionally chime in, I read the general and
hackers lists daily (er, hourly ;) ) and have a deep respect for the
individuals who participate on these lists.
Looking forward to your feedback,
Ryan Mahoney
BTW, I have
postgresql.com takes you to greatbridge.com as of today - did it always -
or am I losing my mind?
-r
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
The website is currently undergoing a rewrite.
Vince.
Are there architectural designs, use cases, mock-ups, color schemes,
requirements, etc. that we can view online so we can understand the
direction things are moving in and offer our input and talents? If this
project is worked on by a
What does your data look like? If you have a lot of duplicate id's, a
sequential scan may be better than an index scan.
If you are not sure if this is the case, try:
SELECT id, count(*) AS count FROM test GROUP BY id ORDER BY count DESC
LIMIT 50;
This should show you the top 50 most
Hi,
Thanks to everyone who answered my questions.. I got the problem solved.
Thanks
Ryan
-Original Message-
From: Fernando Schapachnik [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 12:28 PM
To: Ryan C. Bonham
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [ODBC
: ERROR: relation_info: Relation 41069 not found
Ryan
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
on
the form the update fails. I tried running hte dame update from PGAdmin and
it also fails with the following message. I just dont understand what i need
to create i guess.. Thanks for the help..
Ryan
***
* pgAdmin v7.1.0: Error - 2001-07-19 11
SELECT datname FROM pg_database WHERE datname NOT LIKE 'template_';
-r
At 04:22 PM 7/30/01 -0400, Peter Choe wrote:
how do i get the names of the databases that are created in postgres?
is there a select statement similar to oracle?
peter choe
---(end of
manipulate and display returned values.
Hope this answers your question!
-Ryan
At 11:03 PM 7/28/01 +0200, Svenne Krap wrote:
Hi,
is there any way to get the number of the tuple in the result set...
in Oracle you can write
select rownum, * from mytable;
and then get (handmade example) :
rownum
Call phpinfo() and see if you have postgres support compiled into
php. This would cause your error.
Good Luck!
-r
At 04:13 PM 7/26/01 +1200, Mike C wrote:
Hello,
Err message within a
browser(http://its-macman.otago.ac.nz/~mike/index.php) =
Fatal error: Call to
undefined function:
Possibly. If your OS does not support or is not currently configured for
dual processor utilization, then your machine will not use the other
CPU. What OS/Version are you running?
-r
At 04:31 PM 7/23/01 -0500, Jack Long wrote:
uh-oh, top looks like this for me:
3:35pm up 43 min, 3
http://www.greatbridge.org/genpage?replication_top
All you could ever want to know about pgsql replication.
God Luck!
-r
At 04:31 PM 7/18/01 -0400, Fran Fabrizio wrote:
Does postgres support replication? I think this is the feature I need.
I have a table in one db that I need to use from
If you
already have the information on the labels, all you need is to set the font on
the text box to a "Bar Code Font". If you dont have a barcode font, try "elfring
soft fonts" http://64.21.138.30/. Hope that
helps.. If you have any question email me directly and i wil see if i can
help.
(usually
located in /usr/local/pgsql/data/postgresql.conf). Your Connection
Parameters section should read like this:
#
# Connection Parameters
#
tcpip_socket = true
#ssl = false
Good Luck!
-Ryan Mahoney
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
In my logs, I find a lot of these:
NOTICE: current transaction is aborted, queries ignored until end of
transaction block
should I be concerned? Is there a place where I can read about the
difference messages that may appear in the log file?
Thanks!
- Ryan Mahoney
---
Outgoing
Hi Mark, This is being worked on now. I believe the 7.2 release will have
enable you to run a vacuum with no downtime.
-r
At 03:39 PM 7/11/01 -0600, Mark wrote:
Is Postgresql ready for 24/7 uptime? Our tests have shown that vacuumdb
requires downtime, and if one does this nightly as
1 - 100 of 128 matches
Mail list logo