I am attempting to remove a "role" from Postgresql-9.3.6. I've already
reassigned ownership for the role's tables, functions, sequences, types,
views, etc... However, I am still unable to remove the role. Postgresql
reports that "8 objects in the database 'postgres'" depend on this role.
How do
Apologies for the typo of your name in my last post, Tom.
On Mon, Apr 13, 2015 at 12:16 PM, Dennis Jenkins <
dennis.jenkins...@gmail.com> wrote:
> Doh. I found my answer. Tome posted it years ago..
> http://www.postgresql.org/message-id/18994.1325874...@sss.pgh.pa.us
>
> I
on, Apr 13, 2015 at 12:05 PM, Dennis Jenkins <
dennis.jenkins...@gmail.com> wrote:
> I am attempting to remove a "role" from Postgresql-9.3.6. I've already
> reassigned ownership for the role's tables, functions, sequences, types,
> views, etc... However, I am
On Fri, May 22, 2015 at 10:02 AM, Tom Lane wrote:
> Alban Hertroys writes:
> > On 22 May 2015 at 04:46, Bill Moran wrote:
> >> With all that being said, if I were to build a patch, would it be likely
> >> to be accepted into core?
>
>
How feasible would it be to write a network proxy, like pg_b
On Wed, Jan 5, 2011 at 1:03 PM, Bill Moran wrote:
>
> But the point (that you are trying to sidestep) is that the UUID namespace
> is finite, so therefore you WILL hit a problem with conflicts at some point.
> Just because that point is larger than most people have to concern themselves
> with isn
Hello Everyone,
My goal is to install a 64-bit build of the latest Postgresql 8.4
(not ready for 9.0 yet) onto a Solaris 10u9 server (Intel chips,
X4270), with dtrace support. Postgresql compiles just fine when
configured with "--disable-dtrace". Attempting to compile when
configured with "-
On Fri, Jan 28, 2011 at 1:19 PM, dennis jenkins
wrote:
> Hello Everyone,
>
> My goal is to install a 64-bit build of the latest Postgresql 8.4
> (not ready for 9.0 yet) onto a Solaris 10u9 server (Intel chips,
> X4270), with dtrace support.
> ".../no-dtrace-postgres
I'm working on a project to convert a large database form SQL_ASCII to
UTF-8. I am using this procedure:
1) pg_dump the SQL_ASCII database to an SQL text file.
2) Run through a small (efficient) C program that logs each line that
contains ANY "unclean" ASCII text.
3) Parse that log with a small p
On Thu, Feb 10, 2011 at 1:02 PM, Scott Ribe wrote:
> I know that I have at least one instance of a varchar that is not valid
> UTF-8, imported from a source with errors (AMA CPT files, actually) before
> PG's checking was as stringent as it is today. Can anybody suggest a query to
> find such v
>
> If you are interested, I can email to you the C and Perl source.
>
> It runs like this:
>
> # time pg_restore /db-dumps/some_ascii_pgdump.bin | ./ascii-tester |
> ./bad-ascii-report.pl > unclean-ascii.rpt
http://www.ecoligames.com/~djenkins/pgsql/
Disclaimer: I offer NO warranty. Use at your
On Wed, Mar 23, 2011 at 5:08 AM, Adrian Schreyer wrote:
>
> you are right, it returns a char *.
>
> The prototype:
>
> char *function(bytea *b);
>
> The actual C++ function looks roughly like this
>
> extern "C"
> char *function(bytea *b)
> {
> string ism;
> [...]
> return ism.c_str();
> }
>
On Fri, Jul 18, 2014 at 10:16 AM, Andrew Pennebaker <
andrew.penneba...@gmail.com> wrote:
> Could we please have the PostgreSQL lexer treat #!... on the first line of
> a file as a comment? This would enable .psql scripts to be run with
> dot-slash notation preferred by many unix users:
>
> ./scri
On Fri, Jul 5, 2013 at 7:00 AM, Stuart Ford wrote:
> Dear community
>
> Twice today our PG 9.1 server has caused a "soft lockup", with a kernel
> message like this:
>
> [1813775.496127] BUG: soft lockup - CPU#3 stuck for 73s! [postgres:18723]
>
> Full dmesg output - http://pastebin.com/YdWSmNUp
>
On Fri, Jul 5, 2013 at 8:58 AM, Stuart Ford wrote:
> On Fri, Jul 5, 2013 at 7:00 AM, Dennis Jenkins wrpte
>
> No. iSCSI traffic between the VMWare hosts and the SAN uses completely
> separate NICs and different switches to the "production" LAN.
> I've had a look a
Stuart,
I'm simply curious - did you resolve your issue? What NAS
(vendor/model/config) are you using?
On Fri, Jul 5, 2013 at 11:31 AM, Dennis Jenkins wrote:
>
> On Fri, Jul 5, 2013 at 8:58 AM, Stuart Ford wrote:
>
>> On Fri, Jul 5, 2013 at 7:00 AM, Dennis Jenkin
Hello.
I have several tables in a database that I want to use with "full
text searching". Some of the fields in some of these tables are not
character types, but for the purposes of searching, I'd like to
include their "character representation" in the tsvector.
Unfortunately, I cannot make t
On Tue, Sep 15, 2009 at 3:03 PM, Scott Marlowe wrote:
> On Tue, Sep 15, 2009 at 1:49 PM, John R Pierce wrote:
>> std pik wrote:
>>>
>>> Hello all..
>>> I'm using PostgreSQL 8.3..
>>> How can I get information about the hardware utilization:
>>> - CPU usage.
>>> - Disk space.
>>>
1)
Run both "psql" and "perl" under "strace" and search the output for which
sockets it connects to.
eg, strace -o /tmp/psql.log psql -Upgsql -dmydatabase -c"select
version();"
2)
Add a query into your perl script to perform the following SQL and print
the results:
select current_database();
On Sun, Apr 24, 2011 at 4:16 PM, Tom Lane wrote:
> Phil Couling writes:
> > I'm looking for a way to extract the data from a PostgreSQL 8.3.14
> > database (cluster) that was built using an an ARM/Linux server. The
> > ...
> > Are there any tools for recovering data from a database built with a
On Tue, Jun 28, 2011 at 8:43 AM, Merlin Moncure wrote:
>
> The rebuttal to the above points is that the problem with not quoting
> is that your identifiers are folded to lower case on the server which
> can make them difficult to read in psql, pgadmin, etc. when outputted.
> This is true and I c
On Tue, Jul 19, 2011 at 5:41 AM, Antonio Vieiro wrote:
> Hi all,
>
> I'm building a small C application that uses libpq and I was wondering
> if there's an easy way to detect memory leaks in my code.
>
> I think I'm calling PQclear and friends correctly, but I'd like to
> double-check it. I was wo
Hello Postgresql Community Members,
I am stumped trying to install a few 'c' language functions
on a particular Solaris server (64-bit, amd cpu arch (not sparc)). I
actually
have 5 Postgresql servers, and the .so loads fine into 4 of them, but
refuses to load into the 5th. I've quintuple che
On Thu, Sep 29, 2011 at 12:08 PM, dennis jenkins <
dennis.jenkins...@gmail.com> wrote:
>
> (root@failed: ) # psql -Upgsql -dmy_db -c"create or replace function
> parse_micr(text) returns micr_struct
> as '/db/pgsql_micr_parser_64.so', 'pgsql_micr_parser&#
On Wed, May 12, 2010 at 11:33 AM, Richard Broersma <
richard.broer...@gmail.com> wrote:
> On Wed, May 12, 2010 at 9:18 AM, Justin Graf wrote:
>
> > I would do a plain text file something like XML. Given this is for
> > industrial use 10 years is a good number for warranty and support, but
> > th
On Thu, May 20, 2010 at 7:49 AM, Hernan Danielan
wrote:
> The server and the client are running in the same machine.That is why a
> network connection problem is almost imposible. I do not know if i am doing
> something wrong, my code is in my fist message. It is a extrange thing
> because with fi
On Fri, Jun 25, 2010 at 6:58 AM, Scott Marlowe wrote:
>
> Biggest difference between MySQL and PostgreSQL? The developers.
>
>
I like that... It has a nice ring to it.
On Fri, Aug 13, 2010 at 10:56 AM, Joshua D. Drake
wrote:
> On Fri, 2010-08-13 at 11:38 -0400, Tom Lane wrote:
>>
>> I don't really see that. The case where it's sensible to use
>> compression on the connection is where you're pushing data across
>> a WAN. That's also pretty much exactly the sit
On Wed, Mar 10, 2010 at 10:55 AM, Ben Chobot wrote:
> On Mar 10, 2010, at 12:15 AM, Stuart Bishop wrote:
>
> > syslog doesn't give you easily machine readable output. I'm not sure how
> syslog implementations handle high load (our sysadmins won't use it, so I
> haven't investigated this further).
djenkins@ostara ~/code/capybara $ psql -U$someuser -dpostgres -c
"select version();"
version
--
PostgreSQL 9.
On Wed, Feb 15, 2012 at 9:18 AM, Tom Lane wrote:
> Magnus Hagander writes:
>> On Wed, Feb 15, 2012 at 06:40, dennis jenkins
>> wrote:
>>> I recently updated my Gentoo Linux development system from postgresql
>>> 9.0.4 to 9.0.6-r1 (9.0.6 plus some Gentoo spe
On Tue, Feb 28, 2012 at 8:48 AM, Adam Bruss wrote:
> The handles persist through restarting the postgresql service and restarting
> the IIS server. The handles are accumulating on the System process. I think
> the handles are created when the web service is accessed but that would mean
> the II
On Wed, Feb 29, 2012 at 8:54 AM, Adam Bruss wrote:
> I ran process explorer and looked at the handles for the System process. The
> vast majority of the handles are of type "Key". I can find them in the
> registry. I took two at random from process explorer and exported the
> registry branch fo
On Tue, Mar 6, 2012 at 10:11 AM, Thom Brown wrote:
> On 6 March 2012 16:04, Adrian Klaver wrote:
>> The postmaster.pid is located outside the data directory, but points back to
>> the
>> data directory. Not sure where Debian, though at a guess somewhere in /var.
>> Any way search for postmaste
On Wed, Mar 7, 2012 at 6:34 AM, David Johnston wrote:
> I know there is currently work ongoing regarding normalizing SQL statements
> for logging purposes but has anyone considered given us the ability to name
> our statements.
>
> SELECT
> FROM ...
> WHERE
> NAMEAS 'Name to track by'
I've also looked at the Fusion-IO products. They are not standard
flash drives. They don't appear as SATA devices. They contains an
FPGA that maps the flash directly to the PCI bus. The kernel-mode
drivers blits data to/from them via DMA, not a SATA or SAS drive (that
would limit transfer rates
>> Now I have the "burden" to look for a cool project... Any ideas?
>>
>> -Stefan
>>
>
> How about one of:
>
> 1) on disk page level compression (maybe with LZF or snappy) (maybe not page
> level, any level really)
>
> I know toast compresses, but I believe its only one row. page level would
> com
On Thu, Mar 15, 2012 at 4:12 PM, Jeff Davis wrote:
> On Fri, 2012-03-16 at 01:57 +0530, alexander.bager...@cognizant.com
> wrote:
>> Hi,
>>
>> We are looking to use Postgres 9 for the document storing and would
>> like to take advantage of the full text search capabilities. We have
>> hard time id
On Fri, Mar 16, 2012 at 2:20 PM, Aleksey Tsalolikhin
wrote:
> On Thu, Mar 15, 2012 at 6:43 AM, Aleksey Tsalolikhin
> wrote:
> Our database is about 200 GB - over a WAN link, last time it took 8
> hours to do a full sync, I expect it'll be
> more like 9 or 10 hours this time.
>
Aleksey, a sugges
On Tue, Mar 20, 2012 at 8:27 PM, Jeff Davis wrote:
> On Tue, 2012-03-20 at 22:21 +0100, Henk Bronk wrote:
> > actually rsync works fine on file level and is good for manual syncing.
> > it check really the files with the stat command, so a bit change will
> trigger the copy
> > in practice you ne
On Thu, Apr 26, 2012 at 1:59 PM, Kenneth Tilton wrote:
> On Thu, Apr 26, 2012 at 2:24 PM, Tom Lane wrote:
>
>
>> Can you produce a self-contained test case?
>>
>
> I doubt it. Every test iteration I run includes a lot of redefining of
> functions and triggers all over the map, and it works fine
e to get
everyone to disconnect before we can create a
database.
Everyone out of the pool! Adult swim!
Dennis Jenkins
---(end of broadcast)---
TIP 6: explain analyze is your friend
essed) < 1)
{
elog(NOTICE, "No rows found for transit \"%s\"
(%d).", transit, rows);
goto done;
}
// The rest of the code has been omitted as the
problem has already occurred. "SPI_processed" is
zero.
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Dennis Jenkins <[EMAIL PROTECTED]>
> writes:
> > My problem is that a query that should be
> returning a
> > row is returning zero rows when I use a
> parametrized
> > query.
>
> You're passing the w
st robust way to do it.
> Make sure you don't
> call any PG-internal functions in the child process,
> as that will
> confuse things badly.
>
Is it safe for the postgres engine to fork()? Would
the child need to close down anything immediately in
its main() to av
the other. You can
write stubs for both ends: a fake server for testing
the PostgreSQL part, and a fake "client" for testing
the daemon that you wrote.
Dennis Jenkins
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
_name);
ret_text = palloc(ret_len + VARHDRSZ);
VARATT_SIZEP(ret_text) = ret_len + VARHDRSZ;
memcpy(VARDATA(ret_text), he->h_name, ret_len);
PG_RETURN_TEXT_P(ret_text);
}
Dennis Jenkins
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
46 matches
Mail list logo
